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