private void InitcboItem_group_detail()
{
cItem_group_detail oItem_group_detail = new cItem_group_detail();
string strMessage = string.Empty, strCriteria = string.Empty;
string strYear = cboYear.SelectedValue;
string strItem_group_detail_id = cboItem_group_detail.SelectedValue;
string strItem_group_code = cboItem_group.SelectedValue;
DataSet ds = new DataSet();
DataTable dt = new DataTable();
strCriteria = " and Item_group_year = '" + strYear + "' and c_active='Y' ";
if (!string.IsNullOrEmpty(strItem_group_code))
{
strCriteria += " and item_group_code = '" + strItem_group_code + "' ";
}
if (oItem_group_detail.SP_ITEM_GROUP_DETAIL_SEL(strCriteria, ref ds, ref strMessage))
{
dt = ds.Tables[0];
cboItem_group_detail.Items.Clear();
cboItem_group_detail.Items.Add(new ListItem("---- เลือกข้อมูลทั้งหมด ----", ""));
int i;
for (i = 0; i <= dt.Rows.Count - 1; i++)
{
cboItem_group_detail.Items.Add(new ListItem(dt.Rows[i]["Item_group_detail_name"].ToString(), dt.Rows[i]["Item_group_detail_id"].ToString()));
}
if (cboItem_group_detail.Items.FindByValue(strItem_group_detail_id) != null)
{
cboItem_group_detail.SelectedIndex = -1;
cboItem_group_detail.Items.FindByValue(strItem_group_detail_id).Selected = true;
}
}
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string strMessage = string.Empty;
string strCheck = string.Empty;
string strScript = string.Empty;
string strUpdatedBy = Session["username"].ToString();
HiddenField hdditem_group_detail_id = (HiddenField)GridView1.Rows[e.RowIndex].FindControl("hdditem_group_detail_id");
cItem_group_detail oItem_group_detail = new cItem_group_detail();
try
{
if (!oItem_group_detail.SP_ITEM_GROUP_DETAIL_DEL(hdditem_group_detail_id.Value, ref strMessage))
{
lblError.Text = strMessage;
}
else
{
string strScript1 = "RefreshMain('" + ViewState["page"].ToString() + "');";
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "OpenPage", strScript1, true);
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
finally
{
oItem_group_detail.Dispose();
}
BindGridView();
}
protected void GridView1_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
string strMessage = string.Empty;
string strCheck = string.Empty;
string strScript = string.Empty;
string strUpdatedBy = Session["username"].ToString();
HiddenField hdditem_group_detail_id = (HiddenField)GridView1.Rows[e.RowIndex].FindControl("hdditem_group_detail_id");
cItem_group_detail oItem_group_detail = new cItem_group_detail();
try
{
if (!oItem_group_detail.SP_ITEM_GROUP_DETAIL_DEL(hdditem_group_detail_id.Value, ref strMessage))
{
lblError.Text = strMessage;
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
finally
{
oItem_group_detail.Dispose();
}
BindGridView(0);
}
private bool saveData()
{
bool blnResult = false;
string strMessage = string.Empty;
string strScript = string.Empty;
Item_group_detail item_group_detail = new Item_group_detail();
cItem_group_detail oItem_group_detail = new cItem_group_detail();
DataSet ds = new DataSet();
try
{
#region set Data
item_group_detail.item_group_detail_id = string.IsNullOrEmpty(hdditem_group_detail_id.Value) ? 0 : int.Parse(hdditem_group_detail_id.Value);
item_group_detail.item_group_detail_code = txtitem_group_detail_code.Text.Trim();
item_group_detail.item_group_detail_name = txtitem_group_detail_name.Text.Trim();
item_group_detail.item_group_code = cboItemGroup.SelectedValue;
item_group_detail.c_active = chkStatus.Checked == true ? "Y" : "N";
item_group_detail.c_created_by = Session["username"].ToString();
item_group_detail.c_updated_by = Session["username"].ToString();
#endregion
string strCheckAdd = " and item_group_detail_id = '" + item_group_detail.item_group_detail_id + "' ";
var item = oItem_group_detail.GET(strCheckAdd);
if (item != null)
{
blnResult = oItem_group_detail.SP_ITEM_GROUP_DETAIL_UPD(item_group_detail);
}
else
{
blnResult = oItem_group_detail.SP_ITEM_GROUP_DETAIL_INS(item_group_detail);
}
}
catch (Exception ex)
{
if (ex.Message.Contains("duplicate key"))
{
strScript = @"ไม่สามารถแก้ไขข้อมูลได้ เนื่องจาก";
if (ex.Message.Contains("IX_item_group_detail_code"))
{
strScript += "ข้อมูลรหัสรายละเอียดหมวดค่าใช้จ่าย : " + txtitem_group_detail_code.Text + " ซ้ำ";
}
else if (ex.Message.Contains("IX_item_group_detail_name"))
{
strScript += "ข้อมูลรายละเอียดหมวดค่าใช้จ่าย : " + txtitem_group_detail_name.Text + " ซ้ำ";
}
MsgBox(strScript);
}
else
{
lblError.Text = ex.Message.ToString();
}
}
finally
{
oItem_group_detail.Dispose();
}
return(blnResult);
}
private void setData()
{
cItem_group_detail oItem_group_detail = new cItem_group_detail();
string strMessage = string.Empty, strCriteria = string.Empty;
try
{
strCriteria = " and item_group_detail_id = '" + ViewState["item_group_detail_id"].ToString() + "' ";
var item = oItem_group_detail.GET(strCriteria);
if (item != null)
{
hdditem_group_detail_id.Value = item.item_group_detail_id.ToString();
txtitem_group_detail_code.Text = item.item_group_detail_code;
txtitem_group_detail_name.Text = item.item_group_detail_name;
InitcboYear();
if (cboYear.Items.FindByValue(item.item_group_year) != null)
{
cboYear.SelectedIndex = -1;
cboYear.Items.FindByValue(item.item_group_year).Selected = true;
}
InitcboItemGroup();
if (cboItemGroup.Items.FindByValue(item.item_group_code) != null)
{
cboItemGroup.SelectedIndex = -1;
cboItemGroup.Items.FindByValue(item.item_group_code).Selected = true;
}
chkStatus.Checked = item.c_active == "Y";
//if (strC_active.Equals("Y"))
//{
// txtitem_group_detail_name.ReadOnly = false;
// txtitem_group_detail_name.CssClass = "textbox";
// chkStatus.Checked = true;
//}
//else
//{
// txtitem_group_detail_name.ReadOnly = true;
// txtitem_group_detail_name.CssClass = "textboxdis";
// chkStatus.Checked = false;
//}
////cboItemGroup.Enabled = false;
////cboItemGroup.CssClass = "textboxdis";
//cboYear.Enabled = false;
//cboYear.CssClass = "textboxdis";
txtUpdatedBy.Text = item.c_updated_by;
txtUpdatedDate.Text = item.d_created_date.ToString();
BindGridView();
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
}
private void BindGridView()
{
cItem_group_detail oItem_group_detail = new cItem_group_detail();
DataSet ds = new DataSet();
string strMessage = string.Empty;
string strCriteria = string.Empty;
string stritem_group_code = string.Empty;
stritem_group_code = cboItemGroup.SelectedValue;
strCriteria = strCriteria + " And (item_group_code = '" + stritem_group_code + "') ";
try
{
if (!oItem_group_detail.SP_ITEM_GROUP_DETAIL_SEL(strCriteria, ref ds, ref strMessage))
{
lblError.Text = strMessage;
}
else
{
try
{
ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
catch
{
GridView1.PageIndex = 0;
ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
finally
{
oItem_group_detail.Dispose();
ds.Dispose();
}
}
private void InitcboItemGroupDetail()
{
cItem_group_detail oItem_group_detail = new cItem_group_detail();
string strMessage = string.Empty, strCriteria = string.Empty;
var strYear = string.Empty;
if (this.BudgetType == "B")
{
strYear = ((DataSet)Application["xmlconfig"]).Tables["default"].Rows[0]["yearnow"].ToString();
}
else
{
strYear = ((DataSet)Application["xmlconfig"]).Tables["default"].Rows[0]["yearnow2"].ToString();
}
string strItem_group_detail_id = cboItem_group_detail.SelectedValue;
string strItem_group_code = cboItem_group.SelectedValue;
DataSet ds = new DataSet();
DataTable dt = new DataTable();
strCriteria = " and Item_group_year = '" + strYear + "' and c_active='Y' And Item_group_code ='" + strItem_group_code + "' ";
if (oItem_group_detail.SP_ITEM_GROUP_DETAIL_SEL(strCriteria, ref ds, ref strMessage))
{
dt = ds.Tables[0];
cboItem_group_detail.Items.Clear();
cboItem_group_detail.Items.Add(new ListItem("---- เลือกข้อมูลทั้งหมด ----", ""));
int i;
for (i = 0; i <= dt.Rows.Count - 1; i++)
{
cboItem_group_detail.Items.Add(new ListItem(dt.Rows[i]["Item_group_detail_name"].ToString(), dt.Rows[i]["Item_group_detail_id"].ToString()));
}
if (cboItem_group_detail.Items.FindByValue(strItem_group_detail_id) != null)
{
cboItem_group_detail.SelectedIndex = -1;
cboItem_group_detail.Items.FindByValue(strItem_group_detail_id).Selected = true;
}
}
}
private void BindGridView(int nPageNo)
{
InitcboYear();
InitcboItem_group();
cItem_group_detail oitem_group_detail = new cItem_group_detail();
DataSet ds = new DataSet();
string strMessage = string.Empty;
string strCriteria = string.Empty;
string stritem_group_detail_code = string.Empty;
string stritem_group_detail_name = string.Empty;
string strItem_group_code = string.Empty;
string strActive = string.Empty;
string stritem_group_year = string.Empty;
stritem_group_detail_code = txtitem_group_detail_code.Text.Replace("'", "''").Trim();
stritem_group_detail_name = txtitem_group_detail_name.Text.Replace("'", "''").Trim();
stritem_group_year = cboYear.SelectedValue;
strItem_group_code = cboItem_group.SelectedValue;
if (!stritem_group_detail_code.Equals(""))
{
strCriteria = strCriteria + " And (item_group_detail_code like '%" + stritem_group_detail_code + "%') ";
}
if (!stritem_group_detail_name.Equals(""))
{
strCriteria = strCriteria + " And (item_group_detail_name like '%" + stritem_group_detail_name + "%')";
}
if (!stritem_group_year.Equals(""))
{
strCriteria = strCriteria + " And (item_group_year = '" + stritem_group_year + "') ";
}
if (!strItem_group_code.Equals(""))
{
strCriteria = strCriteria + " And (Item_group_code = '" + strItem_group_code + "') ";
}
if (RadioActive.Checked)
{
strCriteria = strCriteria + " And (c_active ='Y') ";
}
else if (RadioCancel.Checked)
{
strCriteria = strCriteria + " And (c_active ='N') ";
}
try
{
if (!oitem_group_detail.SP_ITEM_GROUP_DETAIL_SEL(strCriteria, ref ds, ref strMessage))
{
lblError.Text = strMessage;
}
else
{
try
{
GridView1.PageIndex = nPageNo;
txthTotalRecord.Value = ds.Tables[0].Rows.Count.ToString();
ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
catch
{
GridView1.PageIndex = 0;
txthTotalRecord.Value = ds.Tables[0].Rows.Count.ToString();
ds.Tables[0].DefaultView.Sort = ViewState["sort"] + " " + ViewState["direction"];
GridView1.DataSource = ds.Tables[0];
GridView1.DataBind();
}
}
}
catch (Exception ex)
{
lblError.Text = ex.Message.ToString();
}
finally
{
oitem_group_detail.Dispose();
ds.Dispose();
if (GridView1.Rows.Count > 0)
{
GridView1.TopPagerRow.Visible = true;
}
}
}