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