public static Boolean UpdateItem_New(dbo_ItemClass clsItem, string userName)
{
SqlConnection connection = SAMDataClass.GetConnection();
string insertProcedure = "UpdateItemValue";
SqlCommand insertCommand = new SqlCommand(insertProcedure, connection);
insertCommand.CommandType = CommandType.StoredProcedure;
insertCommand.Parameters.AddWithValue("@Mode", "UpdItem");
insertCommand.Parameters.AddWithValue("@Item_ID", clsItem.Item_ID);
insertCommand.Parameters.AddWithValue("@UpdateBY", userName);
insertCommand.Parameters.AddWithValue("@UpdateParam", clsItem.Item_Name);
try
{
connection.Open();
int count = insertCommand.ExecuteNonQuery();
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException ex)
{
logger.Error(ex.Message);
return(false);
}
finally
{
connection.Close();
}
}
public static bool Delete(dbo_ItemClass clsdbo_Item)
{
SqlConnection connection = SAMDataClass.GetConnection();
string deleteProcedure = "[dbo].[ItemDelete]";
SqlCommand deleteCommand = new SqlCommand(deleteProcedure, connection);
deleteCommand.CommandType = CommandType.StoredProcedure;
if (clsdbo_Item.Item_ID != null)
{
deleteCommand.Parameters.AddWithValue("@OldItem_ID", clsdbo_Item.Item_ID);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldItem_ID", DBNull.Value);
}
if (clsdbo_Item.Item_Name != null)
{
deleteCommand.Parameters.AddWithValue("@OldItem_Name", clsdbo_Item.Item_Name);
}
else
{
deleteCommand.Parameters.AddWithValue("@OldItem_Name", DBNull.Value);
}
deleteCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int);
deleteCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output;
try
{
connection.Open();
deleteCommand.ExecuteNonQuery();
int count = System.Convert.ToInt32(deleteCommand.Parameters["@ReturnValue"].Value);
if (count > 0)
{
return(true);
}
else
{
return(false);
}
}
catch (SqlException ex)
{
logger.Error(ex.Message);
return(false);
}
finally
{
connection.Close();
}
}
protected void gdvItem_RowUpdating(object sender, GridViewUpdateEventArgs e)
{
try
{
int RowIndex = Convert.ToInt32((e.RowIndex).ToString());
Label lblItem_ID = (Label)gdvItem.Rows[RowIndex].FindControl("lblItem_ID");
TextBox txtEditItem_Name = (TextBox)gdvItem.Rows[RowIndex].FindControl("txtEditItem_Name");
if (txtEditItem_Name.Text.Trim() != string.Empty)
{
dbo_ItemClass cycle = new dbo_ItemClass()
{
Item_ID = lblItem_ID.Text, Item_Name = txtEditItem_Name.Text
};
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
bool success = false;
success = dbo_ItemDataClass.UpdateItem_New(cycle, User_ID);
if (success)
{
gdvItem.EditIndex = -1;
gdvItem.ShowFooter = false;
gdvItem.DataSource = dbo_ItemDataClass.GetItem_New();
gdvItem.DataBind();
}
}
else
{
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
Show("กรุณากรอกข้อมูลที่จำเป็นให้ครบถ้วน");
}
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
}
catch (Exception ex)
{
}
}
public static dbo_ItemClass Select_Record(dbo_ItemClass clsdbo_ItemPara)
{
dbo_ItemClass clsdbo_Item = new dbo_ItemClass();
SqlConnection connection = SAMDataClass.GetConnection();
string selectProcedure = "[dbo].[ItemSelect]";
SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@Item_ID", clsdbo_ItemPara.Item_ID);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsdbo_Item.Item_ID = reader["Item_ID"] is DBNull ? null : reader["Item_ID"].ToString();
clsdbo_Item.Item_Name = reader["Item_Name"] is DBNull ? null : reader["Item_Name"].ToString();
}
else
{
clsdbo_Item = null;
}
reader.Close();
}
catch (SqlException ex)
{
logger.Error(ex.Message);
return(clsdbo_Item);
}
finally
{
connection.Close();
}
return(clsdbo_Item);
}
protected void gdvItem_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "EditItemValue")
{
int RowIndex = Convert.ToInt32((e.CommandArgument).ToString());
List <dbo_ItemClass> item1 = dbo_ItemDataClass.GetItem_New();
if (item1.Count < gdvItem.Rows.Count && RowIndex > int.Parse(ViewState["current_index"].ToString()))
{
RowIndex--;
}
current_index = RowIndex;
ViewState["current_index"] = current_index;
LinkButton currbtn = (LinkButton)gdvItem.Rows[RowIndex].FindControl("lnkB_SetItem_Value");
//Label lblItem_ID = (Label)gdvItem.Rows[RowIndex].FindControl("lblItem_ID");
string ItemID = item1[RowIndex].Item_ID;
if (currbtn.Text == "แก้ไข Value")
{
dbo_ItemClass cycle = new dbo_ItemClass()
{
};
List <dbo_ItemClass> item = dbo_ItemDataClass.GetItem_New();
item.Insert(RowIndex + 1, new dbo_ItemClass()
{
});
gdvItem.DataSource = item;
gdvItem.DataBind();
currbtn = (LinkButton)gdvItem.Rows[RowIndex].FindControl("lnkB_SetItem_Value");
currbtn.Text = "ปิด";
//List<dbo_ItemValueClass> item_value = dbo_ItemDataClass.GetItemValue_New(lblItem_ID.Text);
List <dbo_ItemValueClass> item_value = dbo_ItemDataClass.GetItemValue_New(ItemID);
GridView gv = (GridView)gdvItem.Rows[RowIndex + 1].FindControl("gdvItemValue");
Button newbutton1 = (Button)gdvItem.Rows[RowIndex + 1].FindControl("btnCreateItemValue");
LinkButton Cycle_Name = (LinkButton)gdvItem.Rows[RowIndex + 1].FindControl("lnkB_SetItem_Value");
gv.DataSource = item_value;
gv.DataBind();
gv.Visible = true;
newbutton1.Visible = true;
Cycle_Name.Visible = false;
gdvItem.Rows[RowIndex + 1].Cells[2].ColumnSpan = 5;
gdvItem.Rows[RowIndex + 1].Cells[0].Visible = false;
gdvItem.Rows[RowIndex + 1].Cells[1].Visible = false;
gdvItem.Rows[RowIndex + 1].Cells[3].Visible = false;
gdvItem.Rows[RowIndex + 1].Cells[4].Visible = false;
gdvItem.Rows[RowIndex + 1].Cells[5].Visible = false;
Label currlbl = (Label)gdvItem.Rows[RowIndex + 1].FindControl("lblOrder");
currlbl.Visible = false;
currbtn.Visible = true;
for (int i = RowIndex + 1; i < gdvItem.Rows.Count; i++)
{
Label lbl_Amount = (Label)gdvItem.Rows[i].FindControl("lblOrder");
lbl_Amount.Text = i.ToString();
}
}
else
{
List <dbo_ItemClass> item = dbo_ItemDataClass.GetItem_New();
gdvItem.DataSource = item;
gdvItem.DataBind();
}
}
else if (e.CommandName == "AddNew")
{
TextBox txtNewItem_Name = (TextBox)gdvItem.FooterRow.FindControl("txtNewItem_Name");
if (txtNewItem_Name.Text.Trim() != string.Empty)
{
dbo_ItemClass cycle = new dbo_ItemClass()
{
Item_Name = txtNewItem_Name.Text
};
bool success = false;
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
success = dbo_ItemDataClass.InsertItem_New(cycle, User_ID);
if (success)
{
gdvItem.ShowFooter = false;
List <dbo_ItemClass> item = dbo_ItemDataClass.GetItem_New();
gdvItem.DataSource = item;
gdvItem.DataBind();
}
}
else
{
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
Show("กรุณากรอกข้อมูลที่จำเป็นให้ครบถ้วน");
}
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
}
}
