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); }