MapperCommand Class

public class MapperCommand : ICloneable

Public Class MapperCommand
	Implements ICloneable

public override void MapperBeforeLayout(IMapper sender, EAPEventArgs e)
{
    MapperCommand cmd = new MapperCommand();
    MapperCommandLocation location = MapperCommandLocation.MoreMenu;

    cmd.Caption = "Export to Excel";

    int nLocation = this.Properties.GetIntValue("CommandLocation", (int)MapperCommandLocation.MoreMenu);

    if (((MapperCommandLocation)nLocation) == MapperCommandLocation.Toolbar)
    {
        location = MapperCommandLocation.Toolbar;
    }

    cmd.Location = location;
    cmd.ToolTip = "Export the current data to Microsoft Excel";
    cmd.WindowOptions = EAPUtil.WindowOpenFeatures(WindowOpenOptions.Standard, 0, 0);

    if ((location == MapperCommandLocation.Toolbar) &&
        sender.Application.Properties.GetBoolValue("ToolbarLargeIcons"))
    {
        cmd.ImageURL = "images/excel32.bmp";
    }
    else
    {
        cmd.ImageURL = "images/excel.bmp";
    }

    cmd.Atributes |= UICommandAttrs.ExistingOnly;

    sender.Commands.Add("excelexport", cmd);
}

public override void FieldButtonClick(IField sender, EAPEventArgs e)
{
    if (sender.Key == "btn_enable")
    {
        IField fldID = sender.Fields["dealer_id"];
        IField fldDealershipID = sender.Fields["dealership_id"];
        string dealerID = EAPUtil.ToString(fldID.Value);
        string sql = string.Format("UPDATE dealer SET status_id = 1 WHERE dealer_id = '{0}'", dealerID);

        if (0 == EAPUtil.ToString(fldDealershipID.Value).Length)
        {
            e.Error("You must select a dealership for this dealer before they can be enabled.");
            return;
        }                
        sender.Database.Execute(sql);
    }
}