public static string DeleteMasterDataTransporter(MasterDataModel.MasterDataTransporter item)
{
string res = DbTransaction.DbToString("sp_DeleteMasterDataTransporter",
new
{
Transporter_ID = item.Transporter_ID,
UpdateBy = item.UpdateBy
}, true);
return(res);
}
protected void gvMasterDataTransportir_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
BootstrapGridView gv = (BootstrapGridView)sender;
MasterDataModel.MasterDataTransporter item = new MasterDataModel.MasterDataTransporter();
item.Transporter_ID = (int)e.Keys[0];
item.UpdateBy = UserProfile.Username;
string res = MasterDataEntity.DeleteMasterDataTransporter(item);
gv.JSProperties["cpRes"] = res;
e.Cancel = true;
gv.DataBind();
}
public static string AddMasterDataTransporter(MasterDataModel.MasterDataTransporter item)
{
string res = DbTransaction.DbToString("sp_AddMasterDataTransporter",
new
{
TransporterName = item.TransporterName,
Address = item.Address,
Phone = item.Phone,
Email = item.Email,
Contact1 = item.Contact1,
Contact2 = item.Contact2,
CreationBy = item.CreationBy
}, true);
return(res);
}
protected void gvMasterDataTransportir_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
BootstrapGridView gv = (BootstrapGridView)sender;
MasterDataModel.MasterDataTransporter item = GetGvValue(gv, (int)e.Keys[0]);
string res = MasterDataEntity.EditMasterDataTransporter(item);
gv.JSProperties["cpRes"] = res;
e.Cancel = true;
if (res.Contains("Success"))
{
gv.CancelEdit();
gv.DataBind();
}
}
protected MasterDataModel.MasterDataTransporter GetGvValue(BootstrapGridView gv, int key = 0)
{
BootstrapTextBox txtName = gv.FindEditFormTemplateControl("txtName") as BootstrapTextBox;
BootstrapMemo txtAddress = gv.FindEditFormTemplateControl("txtAddress") as BootstrapMemo;
BootstrapTextBox txtEmail = gv.FindEditFormTemplateControl("txtEmail") as BootstrapTextBox;
BootstrapTextBox txtPhone = gv.FindEditFormTemplateControl("txtPhone") as BootstrapTextBox;
BootstrapTextBox txtContact1 = gv.FindEditFormTemplateControl("txtContact1") as BootstrapTextBox;
BootstrapTextBox txtContact2 = gv.FindEditFormTemplateControl("txtContact2") as BootstrapTextBox;
MasterDataModel.MasterDataTransporter item = new MasterDataModel.MasterDataTransporter();
item.Transporter_ID = key;
item.TransporterName = txtName.Text;
item.Address = txtAddress.Text;
item.Email = txtEmail.Text;
item.Phone = txtPhone.Text;
item.Contact1 = txtContact1.Text;
item.Contact2 = txtContact2.Text;
item.CreationBy = UserProfile.Username;
item.UpdateBy = UserProfile.Username;
return(item);
}
