public static string DeleteMasterDataTBBM(MasterDataModel.MasterDataTBBM item)
{
string res = DbTransaction.DbToString("sp_DeleteMasterDataTBBM",
new
{
TBBM_ID_PK = item.TBBM_ID_PK,
UpdateBy = item.UpdateBy
}, true);
return(res);
}
public static string AddMasterDataTBBM(MasterDataModel.MasterDataTBBM item)
{
string res = DbTransaction.DbToString("sp_AddMasterDataTBBM",
new
{
Region_ID_FK = item.Region_ID_FK,
Name = item.Name,
Address = item.Address,
Telp = item.Telp,
Email = item.Email,
CreationBy = item.CreationBy
}, true);
return(res);
}
public static string EditMasterDataTBBM(MasterDataModel.MasterDataTBBM item)
{
string res = DbTransaction.DbToString("sp_EditMasterDataTBBM",
new
{
TBBM_ID_PK = item.TBBM_ID_PK,
Region_ID_FK = item.Region_ID_FK,
Name = item.Name,
Address = item.Address,
Telp = item.Telp,
Email = item.Email,
UpdateBy = item.UpdateBy
}, true);
return(res);
}
protected void gv_RowDeleting(object sender, DevExpress.Web.Data.ASPxDataDeletingEventArgs e)
{
BootstrapGridView gv = (BootstrapGridView)sender;
MasterDataModel.MasterDataTBBM item = new MasterDataModel.MasterDataTBBM();
item.TBBM_ID_PK = Convert.ToInt32(e.Keys[0].ToString());
item.UpdateBy = UserProfile.Username;
string res = MasterDataEntity.DeleteMasterDataTBBM(item);
gv.JSProperties["cpRes"] = res;
e.Cancel = true;
gv.DataBind();
}
protected void gv_RowUpdating(object sender, DevExpress.Web.Data.ASPxDataUpdatingEventArgs e)
{
BootstrapGridView gv = (BootstrapGridView)sender;
MasterDataModel.MasterDataTBBM item = GetGvValue(gv, Convert.ToInt32(e.Keys[0].ToString()));
string res = MasterDataEntity.EditMasterDataTBBM(item);
gv.JSProperties["cpRes"] = res;
e.Cancel = true;
if (res.Contains("Success"))
{
gv.CancelEdit();
gv.DataBind();
}
}
protected MasterDataModel.MasterDataTBBM GetGvValue(BootstrapGridView gv, int key = 0)
{
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.MasterDataTBBM item = new MasterDataModel.MasterDataTBBM();
item.TBBM_ID_PK = key;
item.Region_ID_FK = 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);
}
