protected void btnModalSave_Click(object sender, EventArgs e)
{
try
{
//Validate
if (txtMItemTypeCode.Text == "")
{
ShowMessageBox("กรุณาระบุ รหัส !!!");
ModalPopupExtender1.Show();
return;
}
if (txtMItemTypeName.Text == "")
{
ShowMessageBox("กรุณาระบุ ชื่อกลุ่ม !!!");
ModalPopupExtender1.Show();
return;
}
MasItemType o = new MasItemType();
if (hddMode.Value == "Add") // Add
{
o = new MasItemType();
o.ItemTypeName = txtMItemTypeName.Text;
o.ItemTypeCode = txtMItemTypeCode.Text;
o.Active = "Y";
o.CreatedBy = GetUsername();
o.CreatedDate = DateTime.Now;
using (BillingEntities cre = new BillingEntities())
{
cre.MasItemTypes.Add(o);
cre.SaveChanges();
};
}
else //Edit
{
int objID = ToInt32(hddID.Value);
using (BillingEntities cre = new BillingEntities())
{
o = cre.MasItemTypes.FirstOrDefault(w => w.ItemTypeID.Equals(objID));
if (o != null)
{
o.ItemTypeName = txtMItemTypeName.Text;
o.ItemTypeCode = txtMItemTypeCode.Text;
o.UpdatedBy = GetUsername();
o.UpdatedDate = DateTime.Now;
}
cre.SaveChanges();
};
}
BindData();
ShowMessageBox("บันทึกข้อมูลสำเร็จ.");
}
catch (Exception ex)
{
ShowMessageBox("เกิดข้อผิดพลาด กรุณาติดต่อผู้ดูแลระบบ.");
SendMailError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod());
}
}
protected void imgbtnDelete_Click(object sender, ImageClickEventArgs e)
{
try
{
ImageButton imb = (ImageButton)sender;
if (imb != null)
{
MasItemType obj = new MasItemType();
int objID = ToInt32(imb.CommandArgument);
using (BillingEntities cre = new BillingEntities())
{
obj = cre.MasItemTypes.FirstOrDefault(w => w.ItemTypeID.Equals(objID));
if (obj != null)
{
obj.Active = "N";
obj.UpdatedBy = GetUsername();
obj.UpdatedDate = DateTime.Now;
}
//cre.MasItemTypes.Remove(obj);
cre.SaveChanges();
};
BindData();
}
else
{
SendMailError("imb is null", System.Reflection.MethodBase.GetCurrentMethod());
}
}
catch (Exception ex)
{
ShowMessageBox("เกิดข้อผิดพลาด กรุณาติดต่อผู้ดูแลระบบ.");
SendMailError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod());
}
}
public List <MasItemType> GetSearchItemType()
{
List <MasItemType> lst = new List <MasItemType>();
try
{
List <SqlParameter> param = new List <SqlParameter>();
DataSet ds = conn.GetDataSet("GetSearchItemType", param);
if (ds != null && ds.Tables.Count > 0 && ds.Tables[0] != null)
{
MasItemType o = new MasItemType();
foreach (DataRow dr in ds.Tables[0].Rows)
{
o = new MasItemType();
o.ItemTypeID = Convert.ToInt32(dr["ItemTypeID"].ToString());
o.ItemTypeCode = dr["ItemTypeCode"].ToString();
o.ItemTypeName = dr["ItemTypeName"].ToString();
o.Active = dr["Active"].ToString();
lst.Add(o);
}
}
}
catch (Exception ex)
{
}
return(lst);
}
protected void imgbtnEdit_Click(object sender, ImageClickEventArgs e)
{
try
{
ImageButton imb = (ImageButton)sender;
MasItemType obj = new MasItemType();
if (imb != null)
{
int objID = ToInt32(imb.CommandArgument);
using (BillingEntities cre = new BillingEntities())
{
obj = cre.MasItemTypes.FirstOrDefault(w => w.ItemTypeID.Equals(objID));
};
if (obj != null)
{
hddID.Value = imb.CommandArgument;
txtMItemTypeCode.Text = obj.ItemTypeCode;
txtMItemTypeName.Text = obj.ItemTypeName;
ModalPopupExtender1.Show();
hddMode.Value = "Edit";
}
else
{
SendMailError("obj is null, objID = " + imb.CommandArgument, System.Reflection.MethodBase.GetCurrentMethod());
}
}
else
{
SendMailError("imb is null", System.Reflection.MethodBase.GetCurrentMethod());
}
}
catch (Exception ex)
{
ShowMessageBox("เกิดข้อผิดพลาด กรุณาติดต่อผู้ดูแลระบบ.");
SendMailError(ex.Message, System.Reflection.MethodBase.GetCurrentMethod());
}
}
