private bool saveData()
{
bool blnResult = false;
string strMessage = string.Empty;
string strScript = string.Empty;
Item_detail item_detail = new Item_detail();
cItem_detail oItem_detail = new cItem_detail();
DataSet ds = new DataSet();
try
{
#region set Data
item_detail.item_detail_id = string.IsNullOrEmpty(hdditem_detail_id.Value) ? 0 : int.Parse(hdditem_detail_id.Value);
item_detail.item_detail_code = txtitem_detail_code.Text.Trim();
item_detail.item_detail_name = txtitem_detail_name.Text.Trim();
item_detail.item_code = cboItem.SelectedValue;
item_detail.c_active = chkStatus.Checked == true ? "Y" : "N";
item_detail.c_created_by = Session["username"].ToString();
item_detail.c_updated_by = Session["username"].ToString();
#endregion
string strCheckAdd = " and item_detail_id = '" + item_detail.item_detail_id + "' ";
var item = oItem_detail.GET(strCheckAdd);
if (item != null)
{
blnResult = oItem_detail.SP_ITEM_DETAIL_UPD(item_detail);
}
else
{
blnResult = oItem_detail.SP_ITEM_DETAIL_INS(item_detail);
}
}
catch (Exception ex)
{
if (ex.Message.Contains("duplicate key"))
{
strScript = @"ไม่สามารถแก้ไขข้อมูลได้ เนื่องจาก";
if (ex.Message.Contains("IX_item_code"))
{
strScript += "ข้อมูลรหัสรายละเอียดค่าใช้จ่าย : " + txtitem_detail_code.Text + " ซ้ำ";
}
else if (ex.Message.Contains("IX_item_name"))
{
strScript += "ข้อมูลรายละเอียดค่าใช้จ่าย : " + txtitem_detail_name.Text + " ซ้ำ";
}
MsgBox(strScript);
}
else
{
lblError.Text = ex.Message.ToString();
}
}
finally
{
oItem_detail.Dispose();
}
return(blnResult);
}
private void setData()
{
cItem_detail oItem_detail = new cItem_detail();
string strMessage = string.Empty, strCriteria = string.Empty;
try
{
strCriteria = " and item_detail_id = '" + ViewState["item_detail_id"].ToString() + "' ";
var item = oItem_detail.GET(strCriteria);
if (item != null)
{
hdditem_detail_id.Value = item.item_detail_id.ToString();
txtitem_detail_code.Text = item.item_detail_code;
txtitem_detail_name.Text = item.item_detail_name;
InitcboYear();
if (cboYear.Items.FindByValue(item.item_year) != null)
{
cboYear.SelectedIndex = -1;
cboYear.Items.FindByValue(item.item_year).Selected = true;
}
InitcboItem_group();
if (cboItem_group.Items.FindByValue(item.item_group_code) != null)
{
cboItem_group.SelectedIndex = -1;
cboItem_group.Items.FindByValue(item.item_group_code).Selected = true;
}
InitcboItem_group_detail();
if (cboItem_group_detail.Items.FindByValue(item.item_group_detail_id.ToString()) != null)
{
cboItem_group_detail.SelectedIndex = -1;
cboItem_group_detail.Items.FindByValue(item.item_group_detail_id.ToString()).Selected = true;
}
InitcboItem();
if (cboItem.Items.FindByValue(item.item_code) != null)
{
cboItem.SelectedIndex = -1;
cboItem.Items.FindByValue(item.item_code).Selected = true;
}
chkStatus.Checked = item.c_active == "Y";
txtUpdatedBy.Text = item.c_updated_by;
txtUpdatedDate.Text = item.d_created_date.ToString();
BindGridView();
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
}
protected void lbkRefresh_Click(object sender, EventArgs e)
{
cItem_detail oItem_detail = new cItem_detail();
string strMessage = string.Empty, strCriteria = string.Empty;
try
{
strCriteria = " and item_detail_id = '" + hdditem_detail_id.Value.ToString() + "' ";
var item = oItem_detail.GET(strCriteria);
if (item != null)
{
hdditem_detail_id.Value = item.item_detail_id.ToString();
txtitem_detail_code.Text = item.item_detail_code;
txtitem_detail_name.Text = item.item_detail_name;
InitcboLot();
if (cboLot.Items.FindByValue(item.lot_code) != null)
{
cboLot.SelectedIndex = -1;
cboLot.Items.FindByValue(item.lot_code).Selected = true;
}
InitcboItem_group();
if (cboItem_group.Items.FindByValue(item.item_group_code) != null)
{
cboItem_group.SelectedIndex = -1;
cboItem_group.Items.FindByValue(item.item_group_code).Selected = true;
}
InitcboItemGroupDetail();
if (cboItem_group_detail.Items.FindByValue(item.item_group_detail_id.ToString()) != null)
{
cboItem_group_detail.SelectedIndex = -1;
cboItem_group_detail.Items.FindByValue(item.item_group_detail_id.ToString()).Selected = true;
}
txtitem_detail_code.Text = item.item_detail_code;
txtitem_detail_name.Text = item.item_detail_name;
txtitem_name.Text = item.item_name;
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
}