protected void grdNewValue_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 == "AddNewValue")
{
int current_index = int.Parse(ViewState["current_index"].ToString());
GridView gv = (GridView)GridViewCycle.Rows[current_index + 1].FindControl("grdNewValue");
Label cycle_id = (Label)GridViewCycle.Rows[current_index].FindControl("lblOrder_Cycle_ID");
DropDownList _ddlFooterOrder_Cycle_Date = (DropDownList)gv.FooterRow.FindControl("ddlFooterOrder_Cycle_Date");
DropDownList _ddlFooterOrder_Cycle_Hour = (DropDownList)gv.FooterRow.FindControl("ddlFooterOrder_Cycle_Hour");
DropDownList _ddlFooterOrder_Cycle_Minute = (DropDownList)gv.FooterRow.FindControl("ddlFooterOrder_Cycle_Minute");
DropDownList _ddlFooterDelivery_Cycle_Date = (DropDownList)gv.FooterRow.FindControl("ddlFooterDelivery_Cycle_Date");
TextBox _txtRoute = (TextBox)gv.FooterRow.FindControl("txtFooterRoute");
//if (!string.IsNullOrEmpty(_txtRoute.Text))
//{
dbo_OrderAndDeliveryCycleValueClass cycle = new dbo_OrderAndDeliveryCycleValueClass()
{
Order_Cycle_ID = cycle_id.Text,
Order_Cycle_Date = _ddlFooterOrder_Cycle_Date.SelectedValue,
Order_Cycle_Hour = _ddlFooterOrder_Cycle_Hour.SelectedValue,
Order_Cycle_Minute = _ddlFooterOrder_Cycle_Minute.SelectedValue,
Delivery_Cycle_Date = _ddlFooterDelivery_Cycle_Date.SelectedValue,
Route = _txtRoute.Text
};
bool success = false;
string User_ID = HttpContext.Current.Request.Cookies["User_ID"].Value;
success = dbo_OrderAndDeliveryCycleValueDataClass.Add(cycle, User_ID);
if (success)
{
// string script = @"swal(""บันทึกสำเร็จ!"", """", ""success"")";
// Show("บันทึกสำเร็จ!");
// ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAM", script, true);
gv.ShowFooter = false;
List <dbo_OrderAndDeliveryCycleValueClass> item_value = dbo_OrderAndDeliveryCycleValueDataClass.Search(cycle_id.Text);
gv.DataSource = item_value;
gv.DataBind();
}
System.Threading.Thread.Sleep(500);
ScriptManager.RegisterStartupScript(this.Page, Page.GetType(), "SAMWAIT", "myApp.hidePleaseWait();", true);
//}
/*else
* {
* Show("กรุณากรอกข้อมูลที่จำเป็นให้ครบถ้วน");
* }*/
}
}
public static dbo_OrderAndDeliveryCycleValueClass Select_Record(dbo_OrderAndDeliveryCycleValueClass clsdbo_OrderAndDeliveryCycleValuePara)
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
dbo_OrderAndDeliveryCycleValueClass clsdbo_OrderAndDeliveryCycleValue = new dbo_OrderAndDeliveryCycleValueClass();
SqlConnection connection = SAMDataClass.GetConnection();
string selectProcedure = "[dbo].[OrderAndDeliveryCycleValueSelect]";
SqlCommand selectCommand = new SqlCommand(selectProcedure, connection);
selectCommand.CommandType = CommandType.StoredProcedure;
selectCommand.Parameters.AddWithValue("@Order_Cycle_ID", clsdbo_OrderAndDeliveryCycleValuePara.Order_Cycle_ID);
try
{
connection.Open();
SqlDataReader reader
= selectCommand.ExecuteReader(CommandBehavior.SingleRow);
if (reader.Read())
{
clsdbo_OrderAndDeliveryCycleValue.Order_Cycle_ID = reader["Order_Cycle_ID"] is DBNull ? null : reader["Order_Cycle_ID"].ToString();
clsdbo_OrderAndDeliveryCycleValue.CV_CODE = reader["CV_CODE"] is DBNull ? null : reader["CV_CODE"].ToString();
clsdbo_OrderAndDeliveryCycleValue.Order_Cycle_Date = reader["Order_Cycle_Date"] is DBNull ? null : reader["Order_Cycle_Date"].ToString();
clsdbo_OrderAndDeliveryCycleValue.Order_Cycle_Hour = reader["Order_Cycle_Hour"] is DBNull ? null : reader["Order_Cycle_Hour"].ToString();
clsdbo_OrderAndDeliveryCycleValue.Order_Cycle_Minute = reader["Order_Cycle_Minute"] is DBNull ? null : reader["Order_Cycle_Minute"].ToString();
clsdbo_OrderAndDeliveryCycleValue.Delivery_Cycle_Date = reader["Delivery_Cycle_Date"] is DBNull ? null : reader["Delivery_Cycle_Date"].ToString();
clsdbo_OrderAndDeliveryCycleValue.Route = reader["Route"] is DBNull ? null : reader["Route"].ToString();
clsdbo_OrderAndDeliveryCycleValue.OrderAndDeliveryCycleValue_ID = reader["OrderAndDeliveryCycleValue_ID"] is DBNull ? null : (int?)reader["OrderAndDeliveryCycleValue_ID"];
}
else
{
clsdbo_OrderAndDeliveryCycleValue = null;
}
reader.Close();
}
catch (SqlException ex)
{
logger.Error(ex.Message);
return(clsdbo_OrderAndDeliveryCycleValue);
}
finally
{
connection.Close();
}
return(clsdbo_OrderAndDeliveryCycleValue);
}
public static bool Update(dbo_OrderAndDeliveryCycleValueClass newdbo_OrderAndDeliveryCycleValueClass, String Last_Modified_By)
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
SqlConnection connection = SAMDataClass.GetConnection();
string updateProcedure = "[OrderAndDeliveryCycleValueUpdate]";
SqlCommand updateCommand = new SqlCommand(updateProcedure, connection);
updateCommand.CommandType = CommandType.StoredProcedure;
if (newdbo_OrderAndDeliveryCycleValueClass.Order_Cycle_ID != null)
{
updateCommand.Parameters.AddWithValue("@NewOrder_Cycle_ID", newdbo_OrderAndDeliveryCycleValueClass.Order_Cycle_ID);
}
else
{
updateCommand.Parameters.AddWithValue("@NewOrder_Cycle_ID", DBNull.Value);
}
//if (newdbo_OrderAndDeliveryCycleValueClass.CV_CODE != null)
//{
// updateCommand.Parameters.AddWithValue("@NewCV_CODE", newdbo_OrderAndDeliveryCycleValueClass.CV_CODE);
//}
//else
//{
// updateCommand.Parameters.AddWithValue("@NewCV_CODE", DBNull.Value);
//}
if (newdbo_OrderAndDeliveryCycleValueClass.Order_Cycle_Date != null)
{
updateCommand.Parameters.AddWithValue("@NewOrder_Cycle_Date", newdbo_OrderAndDeliveryCycleValueClass.Order_Cycle_Date);
}
else
{
updateCommand.Parameters.AddWithValue("@NewOrder_Cycle_Date", DBNull.Value);
}
if (newdbo_OrderAndDeliveryCycleValueClass.Order_Cycle_Hour != null)
{
updateCommand.Parameters.AddWithValue("@NewOrder_Cycle_Hour", newdbo_OrderAndDeliveryCycleValueClass.Order_Cycle_Hour);
}
else
{
updateCommand.Parameters.AddWithValue("@NewOrder_Cycle_Hour", DBNull.Value);
}
if (newdbo_OrderAndDeliveryCycleValueClass.Order_Cycle_Minute != null)
{
updateCommand.Parameters.AddWithValue("@NewOrder_Cycle_Minute", newdbo_OrderAndDeliveryCycleValueClass.Order_Cycle_Minute);
}
else
{
updateCommand.Parameters.AddWithValue("@NewOrder_Cycle_Minute", DBNull.Value);
}
if (newdbo_OrderAndDeliveryCycleValueClass.Delivery_Cycle_Date != null)
{
updateCommand.Parameters.AddWithValue("@NewDelivery_Cycle_Date", newdbo_OrderAndDeliveryCycleValueClass.Delivery_Cycle_Date);
}
else
{
updateCommand.Parameters.AddWithValue("@NewDelivery_Cycle_Date", DBNull.Value);
}
if (newdbo_OrderAndDeliveryCycleValueClass.Route != null)
{
updateCommand.Parameters.AddWithValue("@NewRoute", newdbo_OrderAndDeliveryCycleValueClass.Route);
}
else
{
updateCommand.Parameters.AddWithValue("@NewRoute", DBNull.Value);
}
//if (newdbo_OrderAndDeliveryCycleValueClass.Route != null)
//{
// updateCommand.Parameters.AddWithValue("@NewRoute", newdbo_OrderAndDeliveryCycleValueClass.Route);
//}
//else
//{
// updateCommand.Parameters.AddWithValue("@NewRoute", DBNull.Value);
//}
if (newdbo_OrderAndDeliveryCycleValueClass.OrderAndDeliveryCycleValue_ID != null)
{
updateCommand.Parameters.AddWithValue("@OrderAndDeliveryCycleValue_ID", newdbo_OrderAndDeliveryCycleValueClass.OrderAndDeliveryCycleValue_ID);
}
else
{
updateCommand.Parameters.AddWithValue("@OrderAndDeliveryCycleValue_ID", DBNull.Value);
}
if (Last_Modified_By != null)
{
updateCommand.Parameters.AddWithValue("@Last_Modified_By", 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();
}
}
public static bool Add(dbo_OrderAndDeliveryCycleValueClass clsdbo_OrderAndDeliveryCycleValue, String Created_By)
{
logger.Info(HttpContext.Current.Request.Cookies["User_ID"].Value + " " + System.Reflection.MethodBase.GetCurrentMethod().DeclaringType.ToString() + " " + System.Reflection.MethodBase.GetCurrentMethod().Name);
SqlConnection connection = SAMDataClass.GetConnection();
string insertProcedure = "OrderAndDeliveryCycleValueInsert";
SqlCommand insertCommand = new SqlCommand(insertProcedure, connection);
insertCommand.CommandType = CommandType.StoredProcedure;
if (clsdbo_OrderAndDeliveryCycleValue.Order_Cycle_ID != null)
{
insertCommand.Parameters.AddWithValue("@Order_Cycle_ID", clsdbo_OrderAndDeliveryCycleValue.Order_Cycle_ID);
}
else
{
insertCommand.Parameters.AddWithValue("@Order_Cycle_ID", DBNull.Value);
}
//if (clsdbo_OrderAndDeliveryCycleValue.CV_CODE != null)
//{
// insertCommand.Parameters.AddWithValue("@CV_CODE", clsdbo_OrderAndDeliveryCycleValue.CV_CODE);
//}
//else
//{
insertCommand.Parameters.AddWithValue("@CV_CODE", DBNull.Value);
//}
if (clsdbo_OrderAndDeliveryCycleValue.Order_Cycle_Date != null)
{
insertCommand.Parameters.AddWithValue("@Order_Cycle_Date", clsdbo_OrderAndDeliveryCycleValue.Order_Cycle_Date);
}
else
{
insertCommand.Parameters.AddWithValue("@Order_Cycle_Date", DBNull.Value);
}
if (clsdbo_OrderAndDeliveryCycleValue.Order_Cycle_Hour != null)
{
insertCommand.Parameters.AddWithValue("@Order_Cycle_Hour", clsdbo_OrderAndDeliveryCycleValue.Order_Cycle_Hour);
}
else
{
insertCommand.Parameters.AddWithValue("@Order_Cycle_Hour", DBNull.Value);
}
if (clsdbo_OrderAndDeliveryCycleValue.Order_Cycle_Minute != null)
{
insertCommand.Parameters.AddWithValue("@Order_Cycle_Minute", clsdbo_OrderAndDeliveryCycleValue.Order_Cycle_Minute);
}
else
{
insertCommand.Parameters.AddWithValue("@Order_Cycle_Minute", DBNull.Value);
}
if (clsdbo_OrderAndDeliveryCycleValue.Delivery_Cycle_Date != null)
{
insertCommand.Parameters.AddWithValue("@Delivery_Cycle_Date", clsdbo_OrderAndDeliveryCycleValue.Delivery_Cycle_Date);
}
else
{
insertCommand.Parameters.AddWithValue("@Delivery_Cycle_Date", DBNull.Value);
}
if (clsdbo_OrderAndDeliveryCycleValue.Route != null)
{
insertCommand.Parameters.AddWithValue("@Route", clsdbo_OrderAndDeliveryCycleValue.Route);
}
else
{
insertCommand.Parameters.AddWithValue("@Route", 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();
}
}
