public static ProductBrandList GetEditProductBrandData(string id, int index) { // Set active row HttpContext.Current.Session["ROW_ID"] = id; HttpContext.Current.Session["ROW"] = index; var productBrandData = new ProductBrandList(); var dsDataProductBrand = new DataSet(); try { using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString())) { List <SqlParameter> arrParm = new List <SqlParameter> { new SqlParameter("@search_name", SqlDbType.VarChar, 200) { Value = "" }, new SqlParameter("@id", SqlDbType.Int) { Value = Convert.ToInt32(id) } }; conn.Open(); dsDataProductBrand = SqlHelper.ExecuteDataset(conn, "sp_product_brand_list", arrParm.ToArray()); conn.Close(); } if (dsDataProductBrand.Tables.Count > 0) { var row = dsDataProductBrand.Tables[0].Rows[0]; productBrandData.id = Convert.IsDBNull(row["id"]) ? 0 : Convert.ToInt32(row["id"]); productBrandData.brand_code = Convert.IsDBNull(row["brand_code"]) ? null : Convert.ToString(row["brand_code"]); productBrandData.brand_name_eng = Convert.IsDBNull(row["brand_name_tha"]) ? null : Convert.ToString(row["brand_name_tha"]); productBrandData.brand_name_tha = Convert.IsDBNull(row["brand_name_eng"]) ? null : Convert.ToString(row["brand_name_eng"]); } } catch (Exception ex) { throw ex; } return(productBrandData); }
public static EmployeeDepartmentList GetEditDepartmentData(string id, int index) { // Set active row HttpContext.Current.Session["ROW_ID"] = id; HttpContext.Current.Session["ROW"] = index; var employeeDepartmentData = new EmployeeDepartmentList(); var dsDataEmployeeDepartment = new DataSet(); try { using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString())) { List <SqlParameter> arrParm = new List <SqlParameter> { new SqlParameter("@id", SqlDbType.Int) { Value = Convert.ToInt32(id) }, new SqlParameter("@search_name", SqlDbType.VarChar, 200) { Value = "" } }; conn.Open(); dsDataEmployeeDepartment = SqlHelper.ExecuteDataset(conn, "sp_employee_department_list", arrParm.ToArray()); conn.Close(); } if (dsDataEmployeeDepartment.Tables.Count > 0) { var row = dsDataEmployeeDepartment.Tables[0].Rows[0]; employeeDepartmentData.id = Convert.IsDBNull(row["id"]) ? 0 : Convert.ToInt32(row["id"]); employeeDepartmentData.name_tha = Convert.IsDBNull(row["name_tha"]) ? null : Convert.ToString(row["name_tha"]); employeeDepartmentData.name_eng = Convert.IsDBNull(row["name_eng"]) ? null : Convert.ToString(row["name_eng"]); employeeDepartmentData.type = Convert.IsDBNull(row["service_type"]) ? "" : Convert.ToString(row["service_type"]); } } catch (Exception ex) { throw ex; } return(employeeDepartmentData); }
public static string ReadNotification(int id) { using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString())) { using (SqlCommand cmd = new SqlCommand("sp_notification_update_read", 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("READ"); }
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("@user_id", SqlDbType.Int) { Value = ConstantClass.SESSION_USER_ID }, new SqlParameter("@id", SqlDbType.Int) { Value = 0 }, new SqlParameter("@search_name", SqlDbType.VarChar, 200) { Value = "" } }; conn.Open(); dsResult = SqlHelper.ExecuteDataset(conn, "sp_sale_order_header_list", arrParm.ToArray()); conn.Close(); Session["SESSION_SALE_ORDER_LIST"] = 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); } }
protected void gridView_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var dsResult = new DataSet(); try { using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString())) { 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; } //Bind data into GridView gridView.DataSource = dsResult; gridView.FilterExpression = FilterBag.GetExpression(false); gridView.DataBind(); } } catch (Exception ex) { throw ex; } }
protected void Page_Load(object sender, EventArgs e) { if (!Page.IsPostBack) { 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(); var dsResult = SqlHelper.ExecuteDataset(conn, "sp_customer_list", arrParm.ToArray()); conn.Close(); cbbCustomer.DataSource = dsResult; cbbCustomer.TextField = "code_name"; cbbCustomer.ValueField = "id"; cbbCustomer.DataBind(); cbbProject.Items.Insert(0, new ListEditItem("ทั้งหมด", "")); cbbProject.SelectedIndex = 0; } // Get Permission and if no permission, will redirect to another page. if (!Permission.GetPermission()) { Response.Redirect(ConstantClass.CONSTANT_NO_PERMISSION_PAGE); } } else { gridAnnualServiceList.DataSource = (from t in annualServiceListData select t).ToList(); gridAnnualServiceList.FilterExpression = FilterBag.GetExpression(false); gridAnnualServiceList.DataBind(); } }
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("@search_name", SqlDbType.VarChar, 200) { Value = "" }, new SqlParameter("@service_type", SqlDbType.VarChar, 100) { Value = ConstantClass.SESSION_DEPARTMENT_SERVICE_TYPE }, }; conn.Open(); dsResult = SqlHelper.ExecuteDataset(conn, "sp_delivery_order_header_list", arrParm.ToArray()); conn.Close(); Session["SESSION_DELIVERY_ORDER_LIST"] = dsResult; } } //Bind data into GridView gridViewDeliveryOrder.DataSource = dsResult; gridViewDeliveryOrder.FilterExpression = FilterBag.GetExpression(false); gridViewDeliveryOrder.DataBind(); } catch (Exception ex) { string strErrorMsg = SPlanetUtil.LogErrorCollect(ex); Page.ClientScript.RegisterStartupScript(this.GetType(), "AlertMessage", "alertMessage('" + ex.Message + "','E')", true); } }
public static string UpdateSupplierBranch(SupplierBranchList[] supplierBranchUpdateData) { var row = (from t in supplierBranchUpdateData select t).FirstOrDefault(); if (row != null) { try { using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString())) { using (SqlCommand cmd = new SqlCommand("sp_supplier_branch_edit", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(row.id); cmd.Parameters.Add("@supplier_code", SqlDbType.VarChar, 20).Value = row.supplier_code; cmd.Parameters.Add("@branch_no", SqlDbType.VarChar, 5).Value = row.branch_no; cmd.Parameters.Add("@branch_name_tha", SqlDbType.VarChar, 100).Value = row.branch_name_tha; cmd.Parameters.Add("@branch_name_eng", SqlDbType.VarChar, 100).Value = row.branch_name_eng; cmd.Parameters.Add("@address_tha", SqlDbType.VarChar, 200).Value = row.address_tha; cmd.Parameters.Add("@address_eng", SqlDbType.VarChar, 200).Value = row.address_eng; cmd.Parameters.Add("@geo_id", SqlDbType.Int).Value = row.geo_id; cmd.Parameters.Add("@province_id", SqlDbType.Int).Value = row.province_id; cmd.Parameters.Add("@amphur_id", SqlDbType.Int).Value = row.amphur_id; cmd.Parameters.Add("@district_id", SqlDbType.Int).Value = row.district_id; cmd.Parameters.Add("@zipcode", SqlDbType.VarChar, 10).Value = row.zipcode; cmd.Parameters.Add("@is_enable", SqlDbType.Int).Value = 1; cmd.Parameters.Add("@is_delete", SqlDbType.Int).Value = 0; 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 void BindASPxComboBox(ref ASPxComboBox control_name, string storeprocedure_name) { using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString())) { if (storeprocedure_name.Equals(DataListUtil.DropdownStoreProcedureName.Issue_Sale_Order) || storeprocedure_name.Equals(DataListUtil.DropdownStoreProcedureName.Delivery_Note_Issue) || storeprocedure_name.Equals(DataListUtil.DropdownStoreProcedureName.Delivery_Order_Issue_Stock) ) { List <SqlParameter> arrParm = new List <SqlParameter> { new SqlParameter("@lang_id", SqlDbType.VarChar, 3) { Value = "tha" }, new SqlParameter("@service_type", SqlDbType.VarChar, 100) { Value = ConstantClass.SESSION_DEPARTMENT_SERVICE_TYPE }, }; conn.Open(); using (DataSet dsResult = SqlHelper.ExecuteDataset(SPlanetUtil.GetConnectionString(), storeprocedure_name, arrParm.ToArray())) { control_name.DataSource = dsResult; control_name.TextField = "data_text"; control_name.ValueField = "data_value"; control_name.DataBind(); } } else { conn.Open(); using (DataSet dsResult = SqlHelper.ExecuteDataset(SPlanetUtil.GetConnectionString(), CommandType.StoredProcedure, storeprocedure_name)) { control_name.DataSource = dsResult; control_name.TextField = "data_text"; control_name.ValueField = "data_value"; control_name.DataBind(); } } } }
public static string DeleteSaleOrder(string id) { string data = "success"; using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString())) { conn.Open(); using (SqlTransaction tran = conn.BeginTransaction()) { try { using (SqlCommand cmd = new SqlCommand("sp_sale_order_delete", conn, tran)) { 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); cmd.ExecuteNonQuery(); } } catch (Exception ex) { tran.Rollback(); tran.Dispose(); conn.Close(); //throw ex; return(ex.Message.ToString()); } finally { if (!conn.State.Equals(ConnectionState.Closed)) { tran.Commit(); tran.Dispose(); conn.Close(); } } } } return(data); }
protected void gridView_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var dsResult = new DataSet(); try { 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("@search_name", SqlDbType.VarChar, 200) { Value = e.Parameters.ToString() }, new SqlParameter("@service_type", SqlDbType.VarChar, 100) { Value = ConstantClass.SESSION_DEPARTMENT_SERVICE_TYPE }, }; conn.Open(); dsResult = SqlHelper.ExecuteDataset(conn, "sp_issue_header_list", arrParm.ToArray()); conn.Close(); Session["SESSION_ISSUE_LIST"] = 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); } }
protected void gridView_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var dsResult = new DataSet(); try { 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("@search_name", SqlDbType.VarChar, 200) { Value = e.Parameters.ToString() }, new SqlParameter("@return_type", SqlDbType.VarChar, 200) { Value = strReturnType == "" ? "" :strReturnType } }; conn.Open(); dsResult = SqlHelper.ExecuteDataset(conn, "sp_return_header_list", arrParm.ToArray()); conn.Close(); Session["SESSION_RETURN_LIST"] = dsResult; } //Bind data into GridView gridView.DataSource = dsResult;//(from t in dsResult.Tables[0].AsEnumerable() where t.Field<string>("return_type") == strReturnType select t).ToList(); ; 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 ReturnDetail GetReturnData(string id, string hdReturnType) { var data = new ReturnDetail(); 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) }, new SqlParameter("@search_name", SqlDbType.VarChar, 200) { Value = "" }, new SqlParameter("@return_type", SqlDbType.VarChar, 200) { Value = hdReturnType == "" ? "" :hdReturnType } }; conn.Open(); var dsReturnData = SqlHelper.ExecuteDataset(conn, "sp_return_header_list", arrParm.ToArray()); conn.Close(); if (dsReturnData.Tables.Count > 0) { if (dsReturnData.Tables[0].Rows.Count > 0) { var row = (from t in dsReturnData.Tables[0].AsEnumerable() select t).FirstOrDefault(); if (row != null) { data.return_no = Convert.IsDBNull(row["return_no"]) ? string.Empty : Convert.ToString(row["return_no"]); } } } } return(data); }
public static DeliveryOrderHeaderList GetDeliveryNoteData(string id) { var data = new DeliveryOrderHeaderList(); 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) }, new SqlParameter("@search_name", SqlDbType.VarChar, 200) { Value = "" }, new SqlParameter("@service_type", SqlDbType.VarChar, 100) { Value = ConstantClass.SESSION_DEPARTMENT_SERVICE_TYPE }, }; conn.Open(); var dsDeliveryNoteData = SqlHelper.ExecuteDataset(conn, "sp_delivery_order_header_list", arrParm.ToArray()); conn.Close(); if (dsDeliveryNoteData.Tables.Count > 0) { if (dsDeliveryNoteData.Tables[0].Rows.Count > 0) { var row = (from t in dsDeliveryNoteData.Tables[0].AsEnumerable() select t).FirstOrDefault(); if (row != null) { data.delivery_order_no = Convert.IsDBNull(row["delivery_order_no"]) ? string.Empty : Convert.ToString(row["delivery_order_no"]); } } } } return(data); }
public static ShelfDetail ShelfEdit(string id, int index) { // Set active row HttpContext.Current.Session["ROW_ID"] = id; HttpContext.Current.Session["ROW"] = index; var dataShelf = new ShelfDetail(); var dsShelf = new DataSet(); try { using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString())) { List <SqlParameter> arrParm = new List <SqlParameter> { new SqlParameter("@id", SqlDbType.Int) { Value = Convert.ToInt32(id) }, new SqlParameter("@search_name", SqlDbType.VarChar, 200) { Value = "" }, }; conn.Open(); dsShelf = SqlHelper.ExecuteDataset(conn, "sp_shelf_list", arrParm.ToArray()); conn.Close(); } if (dsShelf.Tables.Count > 0) { var row = dsShelf.Tables[0].Rows[0]; dataShelf.id = Convert.IsDBNull(row["id"]) ? 0 : Convert.ToInt32(row["id"]); dataShelf.shelf_name = Convert.IsDBNull(row["shelf_name"]) ? null : Convert.ToString(row["shelf_name"]); } } catch (Exception ex) { throw ex; } return(dataShelf); }
public static QuotationHeaderList GetQuotationData(string id) { var data = new QuotationHeaderList(); using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString())) { //Create array of Parameters List <SqlParameter> arrParm = new List <SqlParameter> { new SqlParameter("@id", SqlDbType.Int) { Value = id }, }; conn.Open(); var dsQuataionData = SqlHelper.ExecuteDataset(conn, "sp_quotation_list_data", arrParm.ToArray()); conn.Close(); if (dsQuataionData.Tables.Count > 0) { if (dsQuataionData.Tables[0].Rows.Count > 0) { var row = (from t in dsQuataionData.Tables[0].AsEnumerable() select t).FirstOrDefault(); if (row != null) { data.id = Convert.ToInt32(id); data.quotation_no = Convert.IsDBNull(row["quotation_no"]) ? string.Empty : Convert.ToString(row["quotation_no"]); data.quotation_status = Convert.IsDBNull(row["quotation_status"]) ? string.Empty : Convert.ToString(row["quotation_status"]); data.quotation_type = Convert.IsDBNull(row["quotation_type"]) ? string.Empty : Convert.ToString(row["quotation_type"]); data.is_discount_by_item = Convert.IsDBNull(row["is_discount_by_item"]) ? false : Convert.ToBoolean(row["is_discount_by_item"]); data.discount1_type = Convert.IsDBNull(row["discount1_type"]) ? string.Empty : Convert.ToString(row["discount1_type"]); data.is_net = Convert.IsDBNull(row["is_net"]) ? false : Convert.ToBoolean(row["is_net"]); data.discount2_type = Convert.IsDBNull(row["discount2_type"]) ? string.Empty : Convert.ToString(row["discount2_type"]); } } } } return(data); }
public static string InsertCustomerBranch(CustomerBranchList[] customerBranchAddData) { var row = (from t in customerBranchAddData select t).FirstOrDefault(); if (row != null) { try { using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString())) { using (SqlCommand cmd = new SqlCommand("sp_customer_branch_add", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@branch_no", SqlDbType.VarChar, 10).Value = Convert.ToString(row.branch_no); cmd.Parameters.Add("@branch_name", SqlDbType.VarChar, 200).Value = Convert.ToString(row.branch_name); cmd.Parameters.Add("@customer_id", SqlDbType.Int).Value = Convert.ToInt32(row.customer_id); cmd.Parameters.Add("@address_bill_tha", SqlDbType.VarChar, 200).Value = Convert.ToString(row.address_bill_tha); cmd.Parameters.Add("@address_bill_eng", SqlDbType.VarChar, 200).Value = Convert.ToString(row.address_bill_eng); cmd.Parameters.Add("@address_install_tha", SqlDbType.VarChar, 200).Value = Convert.ToString(row.address_install_tha); cmd.Parameters.Add("@address_install_eng", SqlDbType.VarChar, 200).Value = Convert.ToString(row.address_install_eng); cmd.Parameters.Add("@geo_id", SqlDbType.Int).Value = Convert.ToInt32(row.geo_id); cmd.Parameters.Add("@province_id", SqlDbType.Int).Value = Convert.ToInt32(row.province_id); cmd.Parameters.Add("@amphur_id", SqlDbType.Int).Value = Convert.ToInt32(row.amphur_id); cmd.Parameters.Add("@district_id", SqlDbType.Int).Value = Convert.ToInt32(row.district_id); cmd.Parameters.Add("@zipcode", SqlDbType.VarChar, 10).Value = Convert.ToString(row.zipcode); cmd.Parameters.Add("@created_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 gridView_CustomCallback(object sender, ASPxGridViewCustomCallbackEventArgs e) { var dsResult = new DataSet(); try { using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString())) { //Create array of Parameters List <SqlParameter> arrParm = new List <SqlParameter> { new SqlParameter("@search_name", SqlDbType.VarChar, 150) { Value = e.Parameters.ToString() }, new SqlParameter("@id", SqlDbType.Int) { Value = 0 } }; conn.Open(); dsResult = SqlHelper.ExecuteDataset(conn, "sp_supplier_brand_list", arrParm.ToArray()); conn.Close(); Session["SESSION_SUPPLIER_BRAND_MASTER"] = dsResult; Session["SEARCH"] = e.Parameters.ToString(); } //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); } }
protected void cbbSupplier_Callback(object sender, CallbackEventArgsBase e) { using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString())) { List <SqlParameter> arrParm = new List <SqlParameter> { new SqlParameter("@lang_id", SqlDbType.VarChar, 3) { Value = "" }, }; conn.Open(); var dsResult = SqlHelper.ExecuteDataset(conn, "sp_dropdown_supplier", arrParm.ToArray()); conn.Close(); cbbSupplier.DataSource = dsResult; cbbSupplier.TextField = "data_text"; cbbSupplier.ValueField = "data_value"; cbbSupplier.DataBind(); cbbSupplier.Items.Insert(0, new ListEditItem("All Supplier", "0")); } }
public static ApproveDetail EditApprove(string id) { var dataApprove = new ApproveDetail(); var dsApprove = new DataSet(); try { using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString())) { List <SqlParameter> arrParm = new List <SqlParameter> { new SqlParameter("@id", SqlDbType.Int) { Value = Convert.ToInt32(id) } }; conn.Open(); dsApprove = SqlHelper.ExecuteDataset(conn, "sp_approve_list", arrParm.ToArray()); conn.Close(); } if (dsApprove.Tables.Count > 0) { var row = dsApprove.Tables[0].Rows[0]; dataApprove.id = Convert.IsDBNull(row["id"]) ? 0 : Convert.ToInt32(row["id"]); dataApprove.name_app1 = Convert.IsDBNull(row["name_app1"]) ? null : Convert.ToString(row["name_app1"]); dataApprove.name_app2 = Convert.IsDBNull(row["name_app2"]) ? null : Convert.ToString(row["name_app2"]); dataApprove.name_app3 = Convert.IsDBNull(row["name_app3"]) ? null : Convert.ToString(row["name_app3"]); dataApprove.approve_id1 = Convert.IsDBNull(row["id_app1"]) ? null : Convert.ToString(row["id_app1"]); dataApprove.approve_id2 = Convert.IsDBNull(row["id_app2"]) ? null : Convert.ToString(row["id_app2"]); dataApprove.approve_id3 = Convert.IsDBNull(row["id_app3"]) ? null : Convert.ToString(row["id_app3"]); } } catch (Exception ex) { throw ex; } return(dataApprove); }
public static void DeleteShelf(string id) { try { using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString())) { using (SqlCommand cmd = new SqlCommand("sp_shelf_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) { throw ex; } }
public static string ChangeStatus(string refer_id, string refer_name, string refer_type) { try { using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString())) { List <SqlParameter> arrParmQU = new List <SqlParameter> { new SqlParameter("@user_id", SqlDbType.Int) { Value = Convert.ToInt32(ConstantClass.SESSION_USER_ID) }, new SqlParameter("@refer_id", SqlDbType.Int) { Value = Convert.ToInt32(refer_id) }, new SqlParameter("@refer_name", SqlDbType.VarChar, 150) { Value = Convert.ToString(refer_name) }, new SqlParameter("@refer_type", SqlDbType.VarChar, 150) { Value = Convert.ToString(refer_type) } // new SqlParameter("@customer_id", SqlDbType.Int) { Value = 0 }, }; conn.Open(); var insertLogApprove = SqlHelper.ExecuteDataset(conn, "sp_approve_log_add", arrParmQU.ToArray()); conn.Close(); } } catch (Exception ex) { throw ex; } return("success"); }
public static string UpdateIndustryType(CustomerIndustryList[] industryTypeUpdateData) { var row = (from t in industryTypeUpdateData select t).FirstOrDefault(); if (row != null) { try { using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString())) { using (SqlCommand cmd = new SqlCommand("sp_customer_industry_edit", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(row.id); 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("@is_enable", SqlDbType.Bit).Value = true; cmd.Parameters.Add("@is_delete", SqlDbType.Bit).Value = false; 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"); }
protected void cbbProductModel_Callback(object sender, CallbackEventArgsBase e) { using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString())) { List <SqlParameter> arrParm = new List <SqlParameter> { new SqlParameter("@cat_cade", SqlDbType.VarChar, 2) { Value = "AC" }, }; conn.Open(); var dsResult = SqlHelper.ExecuteDataset(conn, "sp_dropdown_product_model", arrParm.ToArray()); conn.Close(); cbbProductModel.DataSource = dsResult; cbbProductModel.TextField = "product_model"; cbbProductModel.ValueField = "product_model"; cbbProductModel.DataBind(); cbbProductModel.Items.Insert(0, new ListEditItem("All Product Model", "0")); } }
protected void cbbSecondaryCode_Callback(object sender, CallbackEventArgsBase e) { using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString())) { List <SqlParameter> arrParm = new List <SqlParameter> { new SqlParameter("@lang_id", SqlDbType.VarChar, 3) { Value = "" }, }; conn.Open(); var storeName = cbbProductType.Value.ToString() == "PP" ? "sp_dropdown_product" : "sp_dropdown_product_spare_part"; var dsResult = SqlHelper.ExecuteDataset(conn, storeName, arrParm.ToArray()); conn.Close(); cbbSecondaryCode.DataSource = dsResult; cbbSecondaryCode.TextField = "data_text"; cbbSecondaryCode.ValueField = "data_value"; cbbSecondaryCode.DataBind(); cbbSecondaryCode.Items.Insert(0, new ListEditItem("All Secondary Code", "0")); } }
public static void BindASPxComboBox(ref ASPxComboBox control_name, string storeprocedure_name, List <SqlParameter> arrParm) { using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString())) { DataSet dsResult = new DataSet(); conn.Open(); dsResult = SqlHelper.ExecuteDataset(conn, storeprocedure_name, arrParm.ToArray()); control_name.DataSource = dsResult; control_name.TextField = "data_text"; control_name.ValueField = "data_value"; control_name.DataBind(); conn.Close(); } //using (DataSet dsResult = SqlHelper.ExecuteDataset(SPlanetUtil.GetConnectionString(), CommandType.StoredProcedure, storeprocedure_name)) //{ // control_name.DataSource = dsResult; // control_name.TextField = "data_text"; // control_name.ValueField = "data_value"; // control_name.DataBind(); //} }
public static string UpdateCustomerGroup(CustomerGroupList[] customerGroupUpdateData) { var row = (from t in customerGroupUpdateData select t).FirstOrDefault(); if (row != null) { try { using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString())) { using (SqlCommand cmd = new SqlCommand("sp_customer_group_edit", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@id", SqlDbType.Int).Value = Convert.ToInt32(row.id); 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("@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 ZipcodeList GetZipcode(string districtID) { var zipcodeData = new ZipcodeList(); var dsZipcode = new DataSet(); try { using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString())) { List <SqlParameter> arrParm = new List <SqlParameter> { new SqlParameter("@district_id", SqlDbType.Int) { Value = Convert.ToInt32(districtID) } }; conn.Open(); dsZipcode = SqlHelper.ExecuteDataset(conn, "sp_dropdrown_tb_thailand_5_zipcode", arrParm.ToArray()); conn.Close(); } if (dsZipcode.Tables.Count > 0) { var row = dsZipcode.Tables[0].Rows[0]; zipcodeData.amphur_id = Convert.IsDBNull(row["amphur_id"]) ? 0 : Convert.ToInt32(row["amphur_id"]); zipcodeData.district_id = Convert.IsDBNull(row["district_id"]) ? 0 : Convert.ToInt32(row["district_id"]); zipcodeData.zipcode = Convert.IsDBNull(row["zipcode"]) ? null : Convert.ToString(row["zipcode"]); } } catch (Exception ex) { throw ex; } return(zipcodeData); }
public static int ConfirmAddParent(ProductCategoryDetail[] cateProductLevel1) { int newID = DataListUtil.emptyEntryID;//idเปล่า var parent_id = 0; var row = (from t in cateProductLevel1 select t).FirstOrDefault(); if (row != null) { try { 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_name_tha", SqlDbType.VarChar, 100).Value = row.cat_name_tha; cmd.Parameters.Add("@cat_name_eng", SqlDbType.VarChar, 100).Value = row.cat_name_eng; cmd.Parameters.Add("@cat_type", SqlDbType.VarChar, 2).Value = row.cat_type; cmd.Parameters.Add("@parent_id", SqlDbType.Int).Value = row.parent_id; cmd.Parameters.Add("@level_no", SqlDbType.Int).Value = row.level_no + 1; cmd.Parameters.Add("@created_by", SqlDbType.Int).Value = Convert.ToInt32(ConstantClass.SESSION_USER_ID); conn.Open(); newID = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); } } } catch (Exception ex) { throw ex; } parent_id = row.parent_id; } return(parent_id); }
public static void NotificationConfirmAdd(NotificationDetail[] dataNotic) { int newID = DataListUtil.emptyEntryID; //idเปล่า var row = (from t in dataNotic select t).FirstOrDefault(); if (row != null) { try { using (SqlConnection conn = new SqlConnection(SPlanetUtil.GetConnectionString())) { using (SqlCommand cmd = new SqlCommand("sp_notification_add", conn)) { cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@subject", SqlDbType.VarChar, 100).Value = row.subject; cmd.Parameters.Add("@description", SqlDbType.VarChar, 100).Value = row.description; cmd.Parameters.Add("@customer_id", SqlDbType.Int).Value = Convert.ToInt32(row.customer_id); cmd.Parameters.Add("@notice_type", SqlDbType.VarChar, 2).Value = row.notice_type; cmd.Parameters.Add("@notice_date", SqlDbType.DateTime).Value = row.notice_date; cmd.Parameters.Add("@is_enable", SqlDbType.Bit).Value = Convert.ToInt32(row.is_enable); cmd.Parameters.Add("@is_delete", SqlDbType.Bit).Value = 0; cmd.Parameters.Add("@created_by", SqlDbType.Int).Value = Convert.ToInt32(ConstantClass.SESSION_USER_ID); cmd.Parameters.Add("@company_name_tha", SqlDbType.VarChar, 300).Value = row.company_name_tha; conn.Open(); newID = Convert.ToInt32(cmd.ExecuteScalar()); conn.Close(); } } } catch (Exception ex) { throw ex; } } }