public static string DeleteMasterDataSPSH(MasterDataModel.MasterDataSPSH item)
{
string res = DbTransaction.DbToString("sp_DeleteMasterDataSPSH",
new
{
SPSH_ID = item.SPSH_ID,
UpdateBy = item.UpdateBy
}, true);
return(res);
}
protected void gv_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
BootstrapGridView gv = (BootstrapGridView)sender;
MasterDataModel.MasterDataSPSH item = new MasterDataModel.MasterDataSPSH();
item.SPSH_ID = e.Keys[0].ToString();
item.UpdateBy = UserProfile.Username;
string res = MasterDataEntity.DeleteMasterDataSPSH(item);
gv.JSProperties["cpRes"] = res;
e.Cancel = true;
gv.DataBind();
}
public static string AddMasterDataSPSH(MasterDataModel.MasterDataSPSH item)
{
string res = DbTransaction.DbToString("sp_AddMasterDataSPSH",
new
{
NewSPSH_ID = item.NewSPSH_ID,
Region_ID = item.Region_ID,
Name = item.Name,
Address = item.Address,
Telp = item.Telp,
Email = item.Email,
CreationBy = item.CreationBy
}, true);
return(res);
}
protected void gv_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
BootstrapGridView gv = (BootstrapGridView)sender;
MasterDataModel.MasterDataSPSH item = GetGvValue(gv, e.Keys[0].ToString());
string res = MasterDataEntity.EditMasterDataSPSH(item);
gv.JSProperties["cpRes"] = res;
e.Cancel = true;
if (res.Contains("Success"))
{
gv.CancelEdit();
gv.DataBind();
}
}
protected MasterDataModel.MasterDataSPSH GetGvValue(BootstrapGridView gv, string key = "")
{
BootstrapTextBox txtSPSH_ID = gv.FindEditFormTemplateControl("txtSPSH_ID") as BootstrapTextBox;
BootstrapTextBox txtName = gv.FindEditFormTemplateControl("txtName") as BootstrapTextBox;
BootstrapComboBox cmbRegion = gv.FindEditFormTemplateControl("cmbRegion") as BootstrapComboBox;
BootstrapMemo txtAddress = gv.FindEditFormTemplateControl("txtAddress") as BootstrapMemo;
BootstrapTextBox txtTelp = gv.FindEditFormTemplateControl("txtTelp") as BootstrapTextBox;
BootstrapTextBox txtEmail = gv.FindEditFormTemplateControl("txtEmail") as BootstrapTextBox;
MasterDataModel.MasterDataSPSH item = new MasterDataModel.MasterDataSPSH();
item.SPSH_ID = key;
item.NewSPSH_ID = txtSPSH_ID.Text;
item.Region_ID = Convert.ToByte(cmbRegion.Value);
item.Name = txtName.Text;
item.Address = txtAddress.Text;
item.Telp = txtTelp.Text;
item.Email = txtEmail.Text;
item.CreationBy = UserProfile.Username;
item.UpdateBy = UserProfile.Username;
return(item);
}