protected void GridViewCycle_RowDeleting(object sender, GridViewDeleteEventArgs e) { logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name); try { int index = e.RowIndex; Label _lblOrder_Cycle_ID = (Label)GridViewCycle.Rows[e.RowIndex].FindControl("lblOrder_Cycle_ID"); dbo_OrderAndDeliveryCycleClass order = dbo_OrderAndDeliveryCycleDataClass.Select_Record(_lblOrder_Cycle_ID.Text); List <dbo_OrderAndDeliveryCycleValueClass> value = dbo_OrderAndDeliveryCycleValueDataClass.Search(_lblOrder_Cycle_ID.Text); foreach (dbo_OrderAndDeliveryCycleValueClass _value in value) { dbo_OrderAndDeliveryCycleValueDataClass.Delete(_value.OrderAndDeliveryCycleValue_ID); } dbo_OrderAndDeliveryCycleDataClass.Delete(order); System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); Show("ลบข้อมูลสำเร็จ"); List <dbo_OrderAndDeliveryCycleClass> item = dbo_OrderAndDeliveryCycleDataClass.SelectAll(); GridViewCycle.DataSource = item.OrderBy(f => f.Order_Cycle_ID);; GridViewCycle.DataBind(); } catch (Exception) { } }
public static bool Add(dbo_OrderAndDeliveryCycleClass clsdbo_OrderAndDeliveryCycle, String Created_By) { SqlConnection connection = SAMDataClass.GetConnection(); string insertProcedure = "OrderAndDeliveryCycleInsert"; SqlCommand insertCommand = new SqlCommand(insertProcedure, connection); insertCommand.CommandType = CommandType.StoredProcedure; if (clsdbo_OrderAndDeliveryCycle.Order_Cycle_ID != null) { insertCommand.Parameters.AddWithValue("@Order_Cycle_ID", clsdbo_OrderAndDeliveryCycle.Order_Cycle_ID); } else { insertCommand.Parameters.AddWithValue("@Order_Cycle_ID", DBNull.Value); } if (clsdbo_OrderAndDeliveryCycle.Order_Cycle_Name != null) { insertCommand.Parameters.AddWithValue("@Order_Cycle_Name", clsdbo_OrderAndDeliveryCycle.Order_Cycle_Name); } else { insertCommand.Parameters.AddWithValue("@Order_Cycle_Name", DBNull.Value); } if (Created_By != null) { insertCommand.Parameters.AddWithValue("@Created_By", Created_By); } else { insertCommand.Parameters.AddWithValue("@Created_By", DBNull.Value); } insertCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); insertCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; try { connection.Open(); insertCommand.ExecuteNonQuery(); int count = System.Convert.ToInt32(insertCommand.Parameters["@ReturnValue"].Value); 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_OrderAndDeliveryCycleClass clsdbo_OrderAndDeliveryCycle) { SqlConnection connection = SAMDataClass.GetConnection(); string deleteProcedure = "[OrderAndDeliveryCycleDelete]"; SqlCommand deleteCommand = new SqlCommand(deleteProcedure, connection); deleteCommand.CommandType = CommandType.StoredProcedure; if (clsdbo_OrderAndDeliveryCycle.Order_Cycle_ID != null) { deleteCommand.Parameters.AddWithValue("@OldOrder_Cycle_ID", clsdbo_OrderAndDeliveryCycle.Order_Cycle_ID); } else { deleteCommand.Parameters.AddWithValue("@OldOrder_Cycle_ID", DBNull.Value); } //if (clsdbo_OrderAndDeliveryCycle.Order_Cycle_Name != null) //{ // deleteCommand.Parameters.AddWithValue("@OldOrder_Cycle_Name", clsdbo_OrderAndDeliveryCycle.Order_Cycle_Name); //} //else //{ // deleteCommand.Parameters.AddWithValue("@OldOrder_Cycle_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 GridViewCycle_RowUpdating(object sender, GridViewUpdateEventArgs e) { logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name); try { int RowIndex = Convert.ToInt32((e.RowIndex).ToString()); Label _Order_Cycle_ID = (Label)GridViewCycle.Rows[RowIndex].FindControl("lblOrder_Cycle_ID"); TextBox _Order_Cycle_Name = (TextBox)GridViewCycle.Rows[RowIndex].FindControl("txtEditOrder_Cycle_Name"); dbo_OrderAndDeliveryCycleClass cycle = new dbo_OrderAndDeliveryCycleClass() { Order_Cycle_ID = _Order_Cycle_ID.Text, Order_Cycle_Name = _Order_Cycle_Name.Text }; bool success = false; success = dbo_OrderAndDeliveryCycleDataClass.Update(cycle); if (success) { System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); //string script = @"swal(""บันทึกสำเร็จ!"", """", ""success"")"; //ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAM", script, true); Show("บันทึกสำเร็จ!"); GridViewCycle.EditIndex = -1; GridViewCycle.ShowFooter = false; GridViewCycle.DataSource = dbo_OrderAndDeliveryCycleDataClass.SelectAll().OrderBy(f => f.Order_Cycle_ID); GridViewCycle.DataBind(); } System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); } catch (Exception ex) { logger.Error(ex.Message); } }
public static dbo_OrderAndDeliveryCycleClass Select_Record(String Order_Cycle_ID) { dbo_OrderAndDeliveryCycleClass clsdbo_OrderAndDeliveryCycle = new dbo_OrderAndDeliveryCycleClass(); SqlConnection connection = SAMDataClass.GetConnection(); string selectProcedure = "[dbo].[OrderAndDeliveryCycleSelect]"; SqlCommand selectCommand = new SqlCommand(selectProcedure, connection); selectCommand.CommandType = CommandType.StoredProcedure; selectCommand.Parameters.AddWithValue("@Order_Cycle_ID", Order_Cycle_ID); try { connection.Open(); SqlDataReader reader = selectCommand.ExecuteReader(CommandBehavior.SingleRow); if (reader.Read()) { clsdbo_OrderAndDeliveryCycle.Order_Cycle_ID = reader["Order_Cycle_ID"] is DBNull ? null : reader["Order_Cycle_ID"].ToString(); clsdbo_OrderAndDeliveryCycle.Order_Cycle_Name = reader["Order_Cycle_Name"] is DBNull ? null : reader["Order_Cycle_Name"].ToString(); } else { clsdbo_OrderAndDeliveryCycle = null; } reader.Close(); } catch (SqlException ex) { logger.Error(ex.Message); return(clsdbo_OrderAndDeliveryCycle); } finally { connection.Close(); } return(clsdbo_OrderAndDeliveryCycle); }
protected void GridViewCycle_RowCommand(object sender, GridViewCommandEventArgs e) { logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name); if (e.CommandName == "EditCycle") { int RowIndex = Convert.ToInt32((e.CommandArgument).ToString()); List <dbo_OrderAndDeliveryCycleClass> item1 = dbo_OrderAndDeliveryCycleDataClass.SelectAll(); if (item1.Count < GridViewCycle.Rows.Count && RowIndex > int.Parse(ViewState["current_index"].ToString())) { RowIndex--; } current_index = RowIndex; ViewState["current_index"] = current_index; LinkButton currbtn = (LinkButton)GridViewCycle.Rows[RowIndex].FindControl("lnkB_SetOrder_Cycle_Name"); //Label cycle_id = (Label)GridViewCycle.Rows[RowIndex].FindControl("lblOrder_Cycle_ID"); string orderCycleID = item1[RowIndex].Order_Cycle_ID; if (currbtn.Text == "แก้ไขรอบสั่งรอบส่ง") { dbo_OrderAndDeliveryCycleClass cycle = new dbo_OrderAndDeliveryCycleClass() { }; List <dbo_OrderAndDeliveryCycleClass> item = dbo_OrderAndDeliveryCycleDataClass.SelectAll(); item.Insert(RowIndex + 1, new dbo_OrderAndDeliveryCycleClass() { }); GridViewCycle.DataSource = item; GridViewCycle.DataBind(); currbtn = (LinkButton)GridViewCycle.Rows[RowIndex].FindControl("lnkB_SetOrder_Cycle_Name"); currbtn.Text = "ปิด"; //List<dbo_OrderAndDeliveryCycleValueClass> item_value = dbo_OrderAndDeliveryCycleValueDataClass.Search(cycle_id.Text); List <dbo_OrderAndDeliveryCycleValueClass> item_value = dbo_OrderAndDeliveryCycleValueDataClass.Search(orderCycleID); GridView gv = (GridView)GridViewCycle.Rows[RowIndex + 1].FindControl("grdNewValue"); Button newbutton1 = (Button)GridViewCycle.Rows[RowIndex + 1].FindControl("btnNewValue"); LinkButton Cycle_Name = (LinkButton)GridViewCycle.Rows[RowIndex + 1].FindControl("lnkB_SetOrder_Cycle_Name"); gv.DataSource = item_value; gv.DataBind(); gv.Visible = true; newbutton1.Visible = true; Cycle_Name.Visible = false; GridViewCycle.Rows[RowIndex + 1].Cells[2].ColumnSpan = 5; GridViewCycle.Rows[RowIndex + 1].Cells[0].Visible = false; GridViewCycle.Rows[RowIndex + 1].Cells[1].Visible = false; GridViewCycle.Rows[RowIndex + 1].Cells[3].Visible = false; GridViewCycle.Rows[RowIndex + 1].Cells[4].Visible = false; GridViewCycle.Rows[RowIndex + 1].Cells[5].Visible = false; Label currlbl = (Label)GridViewCycle.Rows[RowIndex + 1].FindControl("lblOrder"); currlbl.Visible = false; // currbtn.Visible = true; for (int i = RowIndex + 1; i < GridViewCycle.Rows.Count; i++) { Label lbl_Amount = (Label)GridViewCycle.Rows[i].FindControl("lblOrder"); lbl_Amount.Text = i.ToString(); } } else { List <dbo_OrderAndDeliveryCycleClass> item = dbo_OrderAndDeliveryCycleDataClass.SelectAll(); GridViewCycle.DataSource = item.OrderBy(f => f.Order_Cycle_ID);; GridViewCycle.DataBind(); } } else if (e.CommandName == "AddNew") { string _Order_Cycle_ID = GenerateID.Order_Cycle_ID(); TextBox _Order_Cycle_Name = (TextBox)GridViewCycle.FooterRow.FindControl("txtNewOrder_Cycle_Name"); if (_Order_Cycle_Name.Text.Trim() != string.Empty) { dbo_OrderAndDeliveryCycleClass cycle = new dbo_OrderAndDeliveryCycleClass() { Order_Cycle_ID = _Order_Cycle_ID, Order_Cycle_Name = _Order_Cycle_Name.Text }; bool success = false; string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value; success = dbo_OrderAndDeliveryCycleDataClass.Add(cycle, User_ID); if (success) { //string script = @"swal(""บันทึกสำเร็จ!"", """", ""success"")"; //ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAM", script, true); // Show("บันทึกสำเร็จ"); GridViewCycle.ShowFooter = false; List <dbo_OrderAndDeliveryCycleClass> item = dbo_OrderAndDeliveryCycleDataClass.SelectAll(); GridViewCycle.DataSource = item.OrderBy(f => f.Order_Cycle_ID);; GridViewCycle.DataBind(); } System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); } else { System.Threading.Thread.Sleep(500); ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true); Show("กรุณากรอกข้อมูลที่จำเป็นให้ครบถ้วน"); } } }
public static bool Update(dbo_OrderAndDeliveryCycleClass newdbo_OrderAndDeliveryCycleClass) { SqlConnection connection = SAMDataClass.GetConnection(); string updateProcedure = "OrderAndDeliveryCycleUpdate"; SqlCommand updateCommand = new SqlCommand(updateProcedure, connection); updateCommand.CommandType = CommandType.StoredProcedure; if (newdbo_OrderAndDeliveryCycleClass.Order_Cycle_ID != null) { updateCommand.Parameters.AddWithValue("@NewOrder_Cycle_ID", newdbo_OrderAndDeliveryCycleClass.Order_Cycle_ID); } else { updateCommand.Parameters.AddWithValue("@NewOrder_Cycle_ID", DBNull.Value); } if (newdbo_OrderAndDeliveryCycleClass.Order_Cycle_Name != null) { updateCommand.Parameters.AddWithValue("@NewOrder_Cycle_Name", newdbo_OrderAndDeliveryCycleClass.Order_Cycle_Name); } else { updateCommand.Parameters.AddWithValue("@NewOrder_Cycle_Name", DBNull.Value); } if (newdbo_OrderAndDeliveryCycleClass.Last_Modified_By != null) { updateCommand.Parameters.AddWithValue("@Last_Modified_By", newdbo_OrderAndDeliveryCycleClass.Last_Modified_By); } else { updateCommand.Parameters.AddWithValue("@Last_Modified_By", DBNull.Value); } updateCommand.Parameters.Add("@ReturnValue", System.Data.SqlDbType.Int); updateCommand.Parameters["@ReturnValue"].Direction = ParameterDirection.Output; try { connection.Open(); updateCommand.ExecuteNonQuery(); int count = System.Convert.ToInt32(updateCommand.Parameters["@ReturnValue"].Value); if (count > 0) { return(true); } else { return(false); } } catch (SqlException ex) { logger.Error(ex.Message); return(false); } finally { connection.Close(); } }