public static void ShelfConfirmEdit(string shelf_name, string id)
{
try
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("sp_shelf_edit", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(id);
cmd.Parameters.Add("@shelf_name", SqlDbType.VarChar, 50).Value = shelf_name;
cmd.Parameters.Add("@updated_by", SqlDbType.Int).Value = Convert.ToInt32(ConstantClass.SESSION_USER_ID);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
// Set new id
HttpContext.Current.Session["ROW_ID"] = Convert.ToString(id);
}
catch (Exception ex)
{
throw ex;
}
}
public static string SetPermissionUserGroup(string id, string column, string is_enable)
{
try
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("sp_security_set_permission_group", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(id);
cmd.Parameters.Add("@column", SqlDbType.VarChar, 150).Value = Convert.ToString(column);
cmd.Parameters.Add("@is_enable", SqlDbType.Bit).Value = Convert.ToInt32(is_enable);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return("success");
}
protected void Page_Load(object sender, EventArgs e)
{
// Load Combobox Thailand Geo Data
SPlanetUtil.BindASPxComboBox(ref cboGEO, DataListUtil.DropdownStoreProcedureName.Thailand_Geo);
cboGEO.Items.Insert(0, new ListEditItem("--โปรดเลือก--", "0"));
SPlanetUtil.BindASPxComboBox(ref cboSupplierBrand, DataListUtil.DropdownStoreProcedureName.Supplier_Brand);
cboSupplierBrand.Items.Insert(0, new ListEditItem("--โปรดเลือก--", "0"));
SPlanetUtil.BindASPxComboBox(ref cboSupplierGroup, DataListUtil.DropdownStoreProcedureName.Supplier_Group);
cboSupplierGroup.Items.Insert(0, new ListEditItem("--โปรดเลือก--", "0"));
// Setting height gridView
gridView.Settings.VerticalScrollableHeight = Convert.ToInt32(BasePage.SizeScreen);
gridView.SettingsBehavior.AllowFocusedRow = true;
//Bind Data into GridView
if (!Page.IsPostBack)
{
// Get Permission and if no permission, will redirect to another page.
if (!Permission.GetPermission())
{
Response.Redirect(ConstantClass.CONSTANT_NO_PERMISSION_PAGE);
}
dsResult = null;
BindGrid(true);
}
else
{
dsResult = (DataSet)Session["SESSION_SUPPLIER_MASTER"];
BindGrid(false);
}
}
public static void NotificationConfirmEdit(NotificationDetail[] dataNotic)
{
var dataedit = (from Notificationedit in dataNotic select Notificationedit).FirstOrDefault();
if (dataedit != null)
{
try
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("sp_notification_edit", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(dataedit.id);
cmd.Parameters.Add("@subject", SqlDbType.VarChar, 100).Value = dataedit.subject;
cmd.Parameters.Add("@description", SqlDbType.VarChar, 100).Value = dataedit.description;
cmd.Parameters.Add("@notice_date", SqlDbType.DateTime).Value = dataedit.notice_date;
cmd.Parameters.Add("@is_enable", SqlDbType.Bit).Value = Convert.ToInt32(dataedit.is_enable);
cmd.Parameters.Add("@updated_by", SqlDbType.Int).Value = Convert.ToInt32(ConstantClass.SESSION_USER_ID);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
}
protected void MainCallbackPanel_Callback(object sender, CallbackEventArgsBase e)
{
try
{
var args = SPlanetUtil.DeserializeCallbackArgs(e.Parameter);
if (args.Count == 0)
{
return;
}
if (args[0] == "SaveEditForm") // When click Save button in EditForm Popup Windows
{
BasePage.SaveEditFormChanges(args[2]);
}
if (args[0] == "DeleteEntry") // When click Delete button at Toolbar menu
{
BasePage.DeleteEntry(args[1]);
}
if (args[0] == "RefreshEntry") // When click Refresh button at Toolbar menu
{
BasePage.RefreshEntry();
}
if (args[0] == "FilterChanged") // When click Save button in Filter Popup Windows
{
FilterBag.FilterControlExpression = args[1];
UpdateFilterControlExpression();
//MainCallbackPanel.JSProperties["cpSelectedFilterNavBarItemName"] = FilterBag.GetActiveFilterName();
BasePage.OnFilterChanged();
}
}
catch (Exception ex)
{
throw ex;
}
}
public static string DeleteProductSet(int id)
{
string returnData = "error";
try
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
if (id > 0)
{
using (SqlCommand cmd = new SqlCommand("sp_product_spare_part_delete", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = id;
cmd.Parameters.Add("@updated_by", SqlDbType.Int).Value = Convert.ToInt32(ConstantClass.SESSION_USER_ID);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
}
return(returnData);
}
catch (Exception ex)
{
throw ex;
}
}
public static string EditEnable(string id, string is_enable)
{
try
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("sp_status_edit_product_set", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(id);
cmd.Parameters.Add("@is_enable", SqlDbType.Bit).Value = Convert.ToInt32(is_enable);
cmd.Parameters.Add("@updated_by", SqlDbType.Int).Value = Convert.ToInt32(ConstantClass.SESSION_USER_ID);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return("success");
}
public static string UpdateConfig(ConfigList[] configUpdateData)
{
var row = (from t in configUpdateData select t).FirstOrDefault();
if (row != null)
{
try
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("sp_config_edit", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(row.id);
cmd.Parameters.Add("@config_document", SqlDbType.Char, 2).Value = row.config_document;
cmd.Parameters.Add("@config_type", SqlDbType.Char, 1).Value = row.config_type;
cmd.Parameters.Add("@config_description", SqlDbType.VarChar, 50).Value = row.config_description;
cmd.Parameters.Add("@updated_by", SqlDbType.Int).Value = Convert.ToInt32(ConstantClass.SESSION_USER_ID);
cmd.Parameters.Add("@is_enable", SqlDbType.Bit).Value = 1;
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
return("success");
}
public static int DeleteProductCategory(string id)
{
var parent_id = 0;
var dataProductCate = (List <ProductCategoryDetail>)HttpContext.Current.Session["SESSION_PRODUCT_CATEGORY_LIST"];
if (dataProductCate != null)
{
parent_id = (from t in dataProductCate where t.id == Convert.ToInt32(id) select t.parent_id).FirstOrDefault();
}
try
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("sp_product_category_delete", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(id);
cmd.Parameters.Add("@updated_by", SqlDbType.Int).Value = Convert.ToInt32(ConstantClass.SESSION_USER_ID);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
}
catch (Exception ex)
{
string strErrorMsg = SPlanetUtil.LogErrorCollect(ex);
}
return(parent_id);
}
public static string SubmitRemarkEdit(RemarkDetail[] parametersEdit)
{
var row = (from t in parametersEdit select t).ToList();
if (row != null)
{
foreach (var data in row)
{
try
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("sp_remark_edit", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(data.id);
cmd.Parameters.Add("@remark_description", SqlDbType.VarChar, 200).Value = data.remark_description;
cmd.Parameters.Add("@updated_by", SqlDbType.Int).Value = Convert.ToInt32(ConstantClass.SESSION_USER_ID);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
}
return("success");
}
protected void LoadData(bool isForceRefreshData = false)
{
var dsResult = new DataSet();
try
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
if (!Page.IsPostBack || isForceRefreshData)
{
using (SqlCommand cmd = new SqlCommand("sp_config_list", conn))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@config_document", SqlDbType.Char, 2)
{
Value = ""
},
new SqlParameter("@config_type", SqlDbType.Char, 1)
{
Value = ""
},
new SqlParameter("@id", SqlDbType.Int)
{
Value = 0
},
};
conn.Open();
dsResult = SqlHelper.ExecuteDataset(conn, "sp_config_list_doc", arrParm.ToArray());
conn.Close();
ViewState["dsResult"] = dsResult;
}
}
else
{
dsResult = (DataSet)ViewState["dsResult"];
}
//Bind data into GridView
gridView.DataSource = dsResult;
gridView.FilterExpression = FilterBag.GetExpression(false);
gridView.DataBind();
if (Session["ROW_ID"] != null)
{
int row = Convert.ToInt32(Session["ROW"]);
gridView.FocusedRowIndex = row;
}
if (Session["PAGE"] != null)
{
int page = Convert.ToInt32(Session["PAGE"]);
gridView.PageIndex = page;
}
}
}
catch (Exception ex)
{
throw ex;
}
}
private void cbbProductCat_RetreiveDataIntoCombo(string productType)
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@lang_id", SqlDbType.VarChar, 3)
{
Value = "tha"
},
new SqlParameter("@cat_type", SqlDbType.Int)
{
Value = productType
},
};
conn.Open();
var dsResult = SqlHelper.ExecuteDataset(conn, "sp_dropdown_product_category_export", arrParm.ToArray());
conn.Close();
cbbProductCat.DataSource = dsResult;
cbbProductCat.TextField = "data_text";
cbbProductCat.ValueField = "data_value";
cbbProductCat.DataBind();
cbbProductCat.Items.Insert(0, new ListEditItem("All Category", "0"));
}
}
public override void DeleteEntry(string id)
{
try
{//Execute Delete Data Store Procedure
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@id", SqlDbType.Int)
{
Value = int.Parse(id)
},
new SqlParameter("@update_by", SqlDbType.Int)
{
Value = Session[ConstantClass.SESSION_USER_ID]
}
};
conn.Open();
SqlHelper.ExecuteNonQuery(conn, "sp_notification_delete", arrParm.ToArray());
}
BindGrid(true);
}
catch (Exception ex)
{
string strErrorMsg = SPlanetUtil.LogErrorCollect(ex);
ScriptManager.RegisterStartupScript(this, GetType(), "myalert", "alert('" + strErrorMsg + "');", true);
}
}
protected void Page_Load(object sender, EventArgs e)
{
// Set Permission
Permission.GetPermission(Convert.ToInt32(ConstantClass.SESSION_USER_GROUP_ID), PageName);
// Load Combobox Customer Group Data
SPlanetUtil.BindASPxComboBox(ref cboUserGroup, DataListUtil.DropdownStoreProcedureName.Security_User_Group);
// Setting height gridView
gridView.Settings.VerticalScrollableHeight = Convert.ToInt32(BasePage.SizeScreen);
//Bind Data into GridView
if (!Page.IsPostBack)
{
Session.Remove("SESSION_USER_PERMISSION");
dsResult = null;
BindGrid(true);
}
else
{
Page.ClientScript.RegisterStartupScript(this.GetType(), "SetCheckboxSwitch", "setTimeout(function() { setCheckboxSwitch() }, 150);", true);
dsResult = (DataSet)ViewState["dsResult"];
BindGrid(false);
}
}
public static string InsertIndustryType(CustomerIndustryList[] industryTypeAddData)
{
var row = (from t in industryTypeAddData select t).FirstOrDefault();
if (row != null)
{
try
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("sp_customer_industry_add", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@name_tha", SqlDbType.VarChar, 200).Value = row.name_tha;
cmd.Parameters.Add("@name_eng", SqlDbType.VarChar, 200).Value = row.name_eng;
cmd.Parameters.Add("@parent_id", SqlDbType.Int).Value = 0;
cmd.Parameters.Add("@begin_char_thai", SqlDbType.VarChar, 2).Value = "ก";
cmd.Parameters.Add("@created_by", SqlDbType.Int).Value = Convert.ToInt32(ConstantClass.SESSION_USER_ID);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
// Set new id
HttpContext.Current.Session["ROW_ID"] = "-1";
}
catch (Exception ex)
{
throw ex;
}
}
return("success");
}
public static string AddProductCategory(string cboCategoryType, string category_name_tha, string category_name_eng)
{
string data = "success";
int newID = DataListUtil.emptyEntryID;
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("sp_product_category_add", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@cat_type", SqlDbType.VarChar, 2).Value = cboCategoryType;
cmd.Parameters.Add("@cat_name_tha", SqlDbType.VarChar, 100).Value = category_name_tha;
cmd.Parameters.Add("@cat_name_eng", SqlDbType.VarChar, 100).Value = category_name_eng;
cmd.Parameters.Add("@parent_id", SqlDbType.Int).Value = 0;
cmd.Parameters.Add("@level_no", SqlDbType.Int).Value = 0;
cmd.Parameters.Add("@created_by", SqlDbType.Int).Value = Convert.ToInt32(ConstantClass.SESSION_USER_ID);
conn.Open();
newID = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
}
// Set new id
HttpContext.Current.Session["ROW_ID"] = Convert.ToString(newID);
}
return(data);
}
public static string UpdateSupplierBrand(SupplierBrandList[] supplierBrandUpdateData)
{
var row = (from t in supplierBrandUpdateData select t).FirstOrDefault();
if (row != null)
{
try
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("sp_supplier_brand_edit", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(row.id);
cmd.Parameters.Add("@brand_name_tha", SqlDbType.VarChar, 150).Value = row.brand_name_tha;
cmd.Parameters.Add("@brand_name_eng", SqlDbType.VarChar, 150).Value = row.brand_name_eng;
cmd.Parameters.Add("@is_enable", SqlDbType.Bit).Value = true;
cmd.Parameters.Add("@updated_by", SqlDbType.Int).Value = Convert.ToInt32(ConstantClass.SESSION_USER_ID);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
// Set new id
HttpContext.Current.Session["ROW_ID"] = Convert.ToString(row.id);
}
catch (Exception ex)
{
throw ex;
}
}
return("success");
}
public static int ProductCategoryConfirmEdit(ProductCategoryDetail[] dataProductCategory)
{
var dataSuccess = 0;
var dataRow = (from t in dataProductCategory select t).FirstOrDefault();
if (dataRow != null)
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("sp_product_category_edit", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = dataRow.id;
cmd.Parameters.Add("@cat_name_tha", SqlDbType.VarChar, 100).Value = dataRow.cat_name_tha;
cmd.Parameters.Add("@cat_name_eng", SqlDbType.VarChar, 100).Value = dataRow.cat_name_eng;
cmd.Parameters.Add("@updated_by", SqlDbType.Int).Value = Convert.ToInt32(ConstantClass.SESSION_USER_ID);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
dataSuccess = dataRow.parent_id;
// Set new id
HttpContext.Current.Session["ROW_ID"] = Convert.ToString(dataRow.id);
}
return(dataSuccess);
}
public static ProductSetList SelectedPrintSparePartSet(string id)
{
var data = new ProductSetList();
var dsSaleProductSet = new DataSet();
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@product_set_id", SqlDbType.Int)
{
Value = Convert.ToInt32(id)
},
};
conn.Open();
dsSaleProductSet = SqlHelper.ExecuteDataset(conn, "sp_report_product_set", arrParm.ToArray());
conn.Close();
if (dsSaleProductSet.Tables.Count > 0)
{
if (dsSaleProductSet.Tables[0].Rows.Count > 0)
{
var row = (from t in dsSaleProductSet.Tables[0].AsEnumerable() select t).FirstOrDefault();
if (row != null)
{
data.product_set_id = Convert.IsDBNull(row["product_set_id"]) ? 0 : Convert.ToInt32(row["product_set_id"]);
}
}
}
}
return(data);
}
public static void SubmitApprove(ApproveDetail[] approveData)
{
var dataApprove = new ApproveDetail();
var dsApprove = new DataSet();
var row = (from t in approveData select t).FirstOrDefault();
try
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("sp_approve_edit", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(row.id);
cmd.Parameters.Add("@approve_id1", SqlDbType.Int).Value = Convert.ToInt32(row.approve_id1);
cmd.Parameters.Add("@approve_id2", SqlDbType.Int).Value = Convert.ToInt32(row.approve_id2);
cmd.Parameters.Add("@approve_id3", SqlDbType.Int).Value = Convert.ToInt32(row.approve_id3);
cmd.Parameters.Add("@updated_by", SqlDbType.Int).Value = Convert.ToInt32(ConstantClass.SESSION_USER_ID);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
protected void BindGrid(bool isForceRefreshData = false)
{
try
{
if (!Page.IsPostBack || isForceRefreshData)
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@id", SqlDbType.Int)
{
Value = 0
},
new SqlParameter("@customer_id", SqlDbType.Int)
{
Value = 0
},
new SqlParameter("@user_id", SqlDbType.Int)
{
Value = ConstantClass.SESSION_USER_ID
}
};
conn.Open();
dsResult = SqlHelper.ExecuteDataset(conn, "sp_notification_list", arrParm.ToArray());
if (dsResult != null)
{
var row = (from t in dsResult.Tables[0].AsEnumerable() select t).ToList();
foreach (var data in row)
{
notificationDetail.Add(new NotificationDetail()
{
id = Convert.ToInt32(data["id"]),
notice_type = Convert.IsDBNull(data["notice_type"]) ? null : Convert.ToString(data["notice_type"]),
notice_date = Convert.ToDateTime(data["notice_date"]),
customer_id = Convert.IsDBNull(data["customer_id"]) ? 0 : Convert.ToInt32(data["customer_id"]),
subject = Convert.IsDBNull(data["subject"]) ? null : Convert.ToString(data["subject"]),
enable = Convert.IsDBNull(data["enable"]) ? null : Convert.ToString(data["enable"]),
description = Convert.IsDBNull(data["description"]) ? null : Convert.ToString(data["description"]),
company_name_tha = Convert.IsDBNull(data["company_name_tha"]) ? null : Convert.ToString(data["company_name_tha"]),
customer_code = Convert.IsDBNull(data["customer_code"]) ? null : Convert.ToString(data["customer_code"]),
});
}
}
HttpContext.Current.Session["SESSION_NOTIFICATION_LIST"] = notificationDetail;
}
}
gridView.DataSource = notificationDetail;
gridView.DataBind();
}
catch (Exception ex)
{
string strErrorMsg = SPlanetUtil.LogErrorCollect(ex);
ScriptManager.RegisterStartupScript(this, GetType(), "myalert", "alert('" + strErrorMsg + "');", true);
}
}
public static string InsertCustomerGroup(CustomerGroupList[] customerGroupAddData)
{
var row = (from t in customerGroupAddData select t).FirstOrDefault();
if (row != null)
{
try
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("sp_customer_group_add", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@mac5_code", SqlDbType.VarChar, 20).Value = row.mac5_code;
cmd.Parameters.Add("@group_name_tha", SqlDbType.VarChar, 100).Value = row.group_name_tha;
cmd.Parameters.Add("@group_name_eng", SqlDbType.VarChar, 100).Value = row.group_name_eng;
cmd.Parameters.Add("@group_remark", SqlDbType.VarChar, 150).Value = row.group_remark;
cmd.Parameters.Add("@created_by", SqlDbType.Int).Value = Convert.ToInt32(ConstantClass.SESSION_USER_ID);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
// Set new id
HttpContext.Current.Session["ROW_ID"] = "-1";
}
catch (Exception ex)
{
throw ex;
}
}
return("success");
}
protected void cbbProject_Callback(object sender, CallbackEventArgsBase e)
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@lang_id", SqlDbType.VarChar, 3)
{
Value = "tha"
},
new SqlParameter("@customer_id", SqlDbType.Int)
{
Value = cbbCustomer.Value
},
};
conn.Open();
var dsResult = SqlHelper.ExecuteDataset(conn, "sp_dropdown_annual_customer_project", arrParm.ToArray());
conn.Close();
if (dsResult.Tables.Count > 0)
{
if (dsResult.Tables[0].Rows.Count > 0)
{
cbbProject.DataSource = dsResult;
cbbProject.TextField = "data_text";
cbbProject.ValueField = "data_text";
cbbProject.DataBind();
cbbProject.Items.Insert(0, new ListEditItem("ทั้งหมด", ""));
cbbProject.SelectedIndex = 0;
}
}
}
}
public static string InsertDepartment(EmployeeDepartmentList[] departmentAddData)
{
var row = (from t in departmentAddData select t).FirstOrDefault();
if (row != null)
{
try
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("sp_employee_department_add", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@name_tha", SqlDbType.VarChar, 100).Value = row.name_tha;
cmd.Parameters.Add("@name_eng", SqlDbType.VarChar, 100).Value = row.name_eng;
cmd.Parameters.Add("@service_type", SqlDbType.VarChar, 20).Value = row.type;
cmd.Parameters.Add("@created_by", SqlDbType.Int).Value = Convert.ToInt32(ConstantClass.SESSION_USER_ID);
cmd.Parameters.Add("@updated_by", SqlDbType.Int).Value = Convert.ToInt32(ConstantClass.SESSION_USER_ID);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
// Set new id
HttpContext.Current.Session["ROW_ID"] = "-1";
}
catch (Exception ex)
{
throw ex;
}
}
return("success");
}
protected void BindGrid(bool isForceRefreshData = false)
{
try
{
if (!Page.IsPostBack || isForceRefreshData)
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@id", SqlDbType.Int)
{
Value = 0
}
};
conn.Open();
dsResult = SqlHelper.ExecuteDataset(conn, "sp_security_permission_screen_list", arrParm.ToArray());
//ViewState["dsResult"] = dsResult;
}
}
//Bind data into GridView
gridView.DataSource = UserGroupDetailList;
gridView.FilterExpression = FilterBag.GetExpression(false);
gridView.DataBind();
}
catch (Exception ex)
{
string strErrorMsg = SPlanetUtil.LogErrorCollect(ex);
ScriptManager.RegisterStartupScript(this, GetType(), "myalert", "alert('" + strErrorMsg + "');", true);
}
}
protected void gridView_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e)
{
try
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@search_name", SqlDbType.VarChar, 200)
{
Value = ""
},
new SqlParameter("@id", SqlDbType.Int)
{
Value = 0
}
};
conn.Open();
dsResult = SqlHelper.ExecuteDataset(conn, "sp_supplier_branch_list", arrParm.ToArray());
ViewState["dsResult"] = dsResult;
}
//Bind data into GridView
gridView.DataSource = dsResult;
gridView.FilterExpression = FilterBag.GetExpression(false);
gridView.DataBind();
}
catch (Exception ex)
{
string strErrorMsg = SPlanetUtil.LogErrorCollect(ex);
ScriptManager.RegisterStartupScript(this, GetType(), "myalert", "alert('" + strErrorMsg + "');", true);
}
}
public static string DeleteDeliveryNote(string id)
{
string data = "success";
try
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("sp_delivery_note_header_delete", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(id);
cmd.Parameters.Add("@updated_by", SqlDbType.Int).Value = Convert.ToInt32(ConstantClass.SESSION_USER_ID);
conn.Open();
cmd.ExecuteNonQuery();
conn.Close();
}
}
}
catch (Exception ex)
{
string strErrorMsg = SPlanetUtil.LogErrorCollect(ex);
}
return(data);
}
public static IssueHeaderList GetIssueData(string id)
{
var data = new IssueHeaderList();
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
//Create array of Parameters
List <SqlParameter> arrParm = new List <SqlParameter>
{
new SqlParameter("@id", SqlDbType.Int)
{
Value = Convert.ToInt32(id)
},
};
conn.Open();
var dsIssueData = SqlHelper.ExecuteDataset(conn, "sp_issue_stock_header_list", arrParm.ToArray());
conn.Close();
if (dsIssueData.Tables.Count > 0)
{
if (dsIssueData.Tables[0].Rows.Count > 0)
{
var row = (from t in dsIssueData.Tables[0].AsEnumerable() select t).FirstOrDefault();
if (row != null)
{
data.issue_stock_no = Convert.IsDBNull(row["issue_stock_no"]) ? string.Empty : Convert.ToString(row["issue_stock_no"]);
}
}
}
}
return(data);
}
protected void Page_Load(object sender, EventArgs e)
{
// Load Combobox Customer Data
SPlanetUtil.BindASPxComboBox(ref cboCustomerId, DataListUtil.DropdownStoreProcedureName.Customer);
// Load Combobox Thailand Geo Data
SPlanetUtil.BindASPxComboBox(ref cboGEO, DataListUtil.DropdownStoreProcedureName.Thailand_Geo);
// Setting height gridView
gridView.Settings.VerticalScrollableHeight = Convert.ToInt32(BasePage.SizeScreen);
//Bind Data into GridView
if (!Page.IsPostBack)
{
// Get Permission and if no permission, will redirect to another page.
if (!Permission.GetPermission())
{
Response.Redirect(ConstantClass.CONSTANT_NO_PERMISSION_PAGE);
}
dsResult = null;
BindGrid(true);
}
else
{
dsResult = (DataSet)ViewState["dsResult"];
BindGrid(false);
}
}
public static void ShelfConfirmAdd(string shelf_name)
{
var newID = DataListUtil.emptyEntryID;
try
{
using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString()))
{
using (SqlCommand cmd = new SqlCommand("sp_shelf_add", conn))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@shelf_name", SqlDbType.VarChar, 50).Value = shelf_name;
cmd.Parameters.Add("@created_by", SqlDbType.Int).Value = Convert.ToInt32(ConstantClass.SESSION_USER_ID);
conn.Open();
newID = Convert.ToInt32(cmd.ExecuteScalar());
conn.Close();
}
}
// Set new id
HttpContext.Current.Session["ROW_ID"] = "-1";
}
catch (Exception ex)
{
throw ex;
}
}
