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