void GetDetails() { Class1 queryResult = new Class1(); try { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.CommandType = CommandType.Text; accountantCls.Cmd.CommandText = " select * from tChartOfAccounts WHERE COAChartCode ='" + LblNodeValue.Text + "' "; accountantCls.beginTrans(); accountantCls.Reader = accountantCls.Cmd.ExecuteReader(); if (accountantCls.Reader.Read()) { Level = Convert.ToInt32(accountantCls.Reader["ChartLevel"].ToString()); ChartId = Convert.ToInt32(accountantCls.Reader["ChartId"].ToString()); AccountType = Convert.ToInt32(accountantCls.Reader["AccountType"].ToString()); } accountantCls.Reader.Close(); accountantCls.commitTrans(); } catch (Exception ex) { accountantCls.rollBackTrans(); queryResult.ErrorDesc = ex.Message; queryResult.ErrorNo = -1; } }
void GetDetails() { Class1 queryResult = new Class1(); try { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.CommandType = CommandType.Text; accountantCls.Cmd.CommandText = " select * from tCompanys WHERE CompanyID ='" + CompanyID + "' "; accountantCls.beginTrans(); accountantCls.Reader = accountantCls.Cmd.ExecuteReader(); if (accountantCls.Reader.Read()) { LblNodeText.Text = accountantCls.Reader["CMPCompanyName"].ToString(); pnlTextBoxes.Visible = true; LblNodeValue.Text = accountantCls.Reader["CompanyID"].ToString(); CompanyIDParent = Convert.ToInt64(accountantCls.Reader["CompanyID"].ToString()); } accountantCls.Reader.Close(); accountantCls.commitTrans(); } catch (Exception ex) { accountantCls.rollBackTrans(); queryResult.ErrorDesc = ex.Message; queryResult.ErrorNo = -1; } }
protected void BtnSave_Click(object sender, EventArgs e) { try { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.CommandText = "USP_Currency_Save"; accountantCls.Cmd.Parameters.Add("@CurrencyName", SqlDbType.NVarChar).Value = _CurrencyText.Text; accountantCls.Cmd.Parameters.Add("@CurrencySymbol", SqlDbType.NVarChar).Value = _CurrencySymbolText.Text; class1.ErrorNo = 0; accountantCls.beginTrans(); class1.RecordId = Convert.ToInt32(accountantCls.Cmd.ExecuteScalar()); if (class1.RecordId == 0) { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.BranchAlreadyExists; } accountantCls.commitTrans(); } catch (Exception ex) { accountantCls.rollBackTrans(); class1.ErrorDesc = ex.Message; class1.ErrorNo = -1; } finally { SqlDataSource1.DataBind(); GvCompany.DataBind(); } }
protected void BtnSave_Click(object sender, EventArgs e) { try { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.CommandText = "USP_Customer_Save"; accountantCls.Cmd.Parameters.Add("CustomerId", SqlDbType.Int).Value = 0; accountantCls.Cmd.Parameters.Add("UserName", SqlDbType.NVarChar).Value = _CustomerNameText.Text; accountantCls.Cmd.Parameters.Add("CUSTypeOfBusiness", SqlDbType.Int).Value = 0; accountantCls.Cmd.Parameters.Add("CountryId", SqlDbType.Int).Value = 966; accountantCls.Cmd.Parameters.Add("CityId", SqlDbType.Int).Value = _CustCityInfo.SelectedValue; accountantCls.Cmd.Parameters.Add("CUSIDType", SqlDbType.Int).Value = _CUSIDType.SelectedValue; accountantCls.Cmd.Parameters.Add("CUSIdNumber", SqlDbType.NVarChar).Value = CUSIdNumber.Text; accountantCls.Cmd.Parameters.Add("CUSEmail", SqlDbType.NVarChar).Value = _EmailText.Text; accountantCls.Cmd.Parameters.Add("CUSContactNo", SqlDbType.NVarChar).Value = _MobileText.Text; accountantCls.Cmd.Parameters.Add("CUSFaxNo", SqlDbType.NVarChar).Value = "-"; accountantCls.Cmd.Parameters.Add("CUSAddress", SqlDbType.NVarChar).Value = _CUSAddress.Text; accountantCls.Cmd.Parameters.Add("Password", SqlDbType.NVarChar).Value = Midwest.Security.RijndaelEncryptionAlg.RijndaelEncryption.Encrypt(_PasswordText.Text); accountantCls.Cmd.Parameters.Add("CompanyId", SqlDbType.Int).Value = Session["CompanyId"].ToString().Trim(); accountantCls.Cmd.Parameters.Add("LedgerId", SqlDbType.Int).Value = 0; accountantCls.Cmd.Parameters.Add("@CreatedBy", SqlDbType.Int).Value = Session["UserCode"].ToString().Trim(); accountantCls.Cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = DateTime.Now; class1.ErrorNo = 0; accountantCls.beginTrans(); int t = accountantCls.Cmd.ExecuteNonQuery(); if (class1.RecordId == 0) { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.CompanyAlreadyExists; } else if (t == -1) { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.UserAlreadyExists; } else { LabelErrorMessage.Text = "Successfully registered, you can add more information about your self or login to system"; } accountantCls.commitTrans(); } catch (Exception ex) { accountantCls.rollBackTrans(); class1.ErrorDesc = ex.Message; class1.ErrorNo = -1; } finally { SqlDataSource1.DataBind(); GvCompany.DataBind(); } }
protected void btnUpdate_Click(object sender, EventArgs e) { LabelErrorMessage.Text = ""; foreach (GridViewRow rows in GridView1.Rows) { CheckBox ck = (CheckBox)rows.FindControl("ck"); Label lblInvoiceNo = (Label)rows.FindControl("lblInvoiceNo"); Session["InvoiceNo"] = lblInvoiceNo.Text.Trim(); if (ck.Checked == true) { try { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.CommandText = "USP_Quotation_Edit_Invoice_Edit"; accountantCls.Cmd.Parameters.Add("@InvoiceNo", SqlDbType.NVarChar).Value = Session["InvoiceNo"].ToString(); accountantCls.Cmd.Parameters.Add("@InvoiceStatusId", SqlDbType.Int).Value = "6"; class1.ErrorNo = 0; accountantCls.beginTrans(); int t = accountantCls.Cmd.ExecuteNonQuery(); if (class1.RecordId == 0) { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.CompanyAlreadyExists; } else if (t == -1) { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.UserAlreadyExists; } accountantCls.commitTrans(); } catch (Exception ex) { accountantCls.rollBackTrans(); class1.ErrorDesc = ex.Message; class1.ErrorNo = -1; } finally { LabelErrorMessage.Text += "تمت العملية بنجاح "; } } } Response.Redirect("InvoiceConfirmation.aspx"); }
protected void BtnSave_Click(object sender, EventArgs e) { try { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.CommandText = "USP_UserRole_Save"; accountantCls.Cmd.Parameters.Add("@UserRoleId", SqlDbType.Int).Value = 0; accountantCls.Cmd.Parameters.Add("@CompanyId", SqlDbType.Int).Value = Session["CompanyId"].ToString(); accountantCls.Cmd.Parameters.Add("@UserRoleName", SqlDbType.NVarChar).Value = _UserRoleNameText.Text; accountantCls.Cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = _DescriptionText.Text; if (ViewState["EditId"].ToString() == "0") { accountantCls.Cmd.Parameters.Add("@UserId ", SqlDbType.Int).Value = Session["UserCode"].ToString(); } else { accountantCls.Cmd.Parameters.Add("@UserId ", SqlDbType.Int).Value = Session["UserCode"].ToString(); } class1.ErrorNo = 0; accountantCls.beginTrans(); class1.RecordId = Convert.ToInt32(accountantCls.Cmd.ExecuteScalar()); if (class1.RecordId == 0) { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.BranchAlreadyExists; } accountantCls.commitTrans(); } catch (Exception ex) { accountantCls.rollBackTrans(); class1.ErrorDesc = ex.Message; class1.ErrorNo = -1; } finally { SqlDataSource1.DataBind(); GvCompany.DataBind(); } }
protected void BtnSave_Click(object sender, EventArgs e) { try { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.beginTrans(); accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.Parameters.Clear(); accountantCls.Cmd.CommandText = "USP_LedgerOpeningBalance_Del"; accountantCls.Cmd.Parameters.Add("@CompanyId", SqlDbType.Int).Value = Session["CompanyId"]; accountantCls.Cmd.ExecuteNonQuery(); //Save branch opening balances for the ledger foreach (GridViewRow r in GvCompany.Rows) { accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.Parameters.Clear(); accountantCls.Cmd.CommandText = "USP_BranchOpeningBalance_Save"; accountantCls.Cmd.Parameters.Add("@FinYearID", SqlDbType.Int).Value = Session["FinYearID"].ToString(); accountantCls.Cmd.Parameters.Add("@BranchId", SqlDbType.Int).Value = Session["BranchId"].ToString(); accountantCls.Cmd.Parameters.Add("@LedgerId", SqlDbType.Int).Value = r.Cells[0].Text.Trim(); DropDownList OpeningBalanceTypeDDL = (DropDownList)r.FindControl("_OpeningBalanceTypeDDL"); if (OpeningBalanceTypeDDL.SelectedIndex != 0) { TextBox TxtOB = (TextBox)r.FindControl("TxtOB"); accountantCls.Cmd.Parameters.Add("@OpeningBalance", SqlDbType.Decimal).Value = TxtOB.Text; accountantCls.Cmd.Parameters.Add("@OpeningBalanceType", SqlDbType.NVarChar).Value = OpeningBalanceTypeDDL.SelectedValue; accountantCls.Cmd.ExecuteNonQuery(); } } class1.RecordId = 0; class1.ErrorNo = 0; accountantCls.commitTrans(); } catch (Exception ex) { accountantCls.rollBackTrans(); class1.ErrorDesc = ex.Message; class1.ErrorNo = -1; class1.ErrorFunction = " Finance.DAL.OpeningBalance.Save"; } finally { SqlDataSource1.DataBind(); GvCompany.DataBind(); } }
protected void BtnSave_Click(object sender, EventArgs e) { try { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.CommandText = "USP_City_Save"; accountantCls.Cmd.Parameters.Add("CityId", SqlDbType.Int).Value = 0; accountantCls.Cmd.Parameters.Add("CityName_Ar", SqlDbType.NVarChar).Value = _CityName_ArText.Text; accountantCls.Cmd.Parameters.Add("CityName_En", SqlDbType.NVarChar).Value = _CityName_ArText.Text; accountantCls.Cmd.Parameters.Add("CountryId", SqlDbType.Int).Value = 966; class1.ErrorNo = 0; accountantCls.beginTrans(); int t = accountantCls.Cmd.ExecuteNonQuery(); if (class1.RecordId == 0) { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.CompanyAlreadyExists; } else if (t == -1) { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.UserAlreadyExists; } accountantCls.commitTrans(); } catch (Exception ex) { accountantCls.rollBackTrans(); class1.ErrorDesc = ex.Message; class1.ErrorNo = -1; } finally { SqlDataSource1.DataBind(); GvCompany.DataBind(); } }
public string GetInvoiceNo(string com, string ColName, string TabName) { AccountantCls accountantCls = new AccountantCls(); string conString = WebConfigurationManager.ConnectionStrings["FinanceConnStr"].ConnectionString; Class1 class1 = new Class1(); int i = 0; string P = ""; try { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.Parameters.Clear(); //accountantCls.Cmd.CommandText = " select Max(" + ColName + ") as InvoiceId from " + TabName ; accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.CommandText = "USP_PathCompany_Select"; accountantCls.Cmd.Parameters.Add("@PropertyId", SqlDbType.NVarChar).Value = com; accountantCls.beginTrans(); accountantCls.Reader = accountantCls.Cmd.ExecuteReader(); if (accountantCls.Reader.Read()) { if (accountantCls.Reader["depth"].ToString() == "") { P = "1"; } else { P = accountantCls.Reader["depth"].ToString(); //P = i.ToString(); } } else { P = "1"; } accountantCls.Reader.Close(); accountantCls.commitTrans(); } catch (Exception ex) { accountantCls.rollBackTrans(); } char pad = '0'; P = P.PadLeft(6, pad); string InvNo = com + P; return(InvNo); }
protected void BtnSave_Click(object sender, EventArgs e) { LblMessage.Text = ""; try { SqlConnection MyCon = new SqlConnection(accountantCls.GetConnStr()); MyCon.Open(); SqlCommand MyCmd = new SqlCommand(); MyCmd.Connection = MyCon; MyCmd.CommandText = "select * from View_Menus where Email='" + _EmailText.Text + "' and Password = '******' and IsActive='1' and FinYearIDStatus='1'"; SqlDataReader Reader = MyCmd.ExecuteReader(); if (Reader.Read()) { Session["Type"] = Reader["UserTypeCode"].ToString().Trim(); Session["UserName"] = Reader["UserName"].ToString().Trim(); Session["UserCode"] = Reader["UserId"].ToString().Trim(); Session["EditId"] = Reader[0].ToString().Trim(); Session["CompanyId"] = Reader["CompanyId"].ToString().Trim(); Session["FinYearID"] = Reader["FinYearID"].ToString().Trim(); //Session["DepartmentId"] = Reader["DepartmentId"].ToString().Trim(); //Session["DivisionId"] = Reader["DivisionId"].ToString().Trim(); Session["UserRoleId1"] = Reader["UserRoleId"].ToString().Trim(); Session["CountryId"] = Reader["CountryId"].ToString().Trim(); Reader.Close(); Session["UserLog"] = "1"; Session["AdminUserName"] = "******"; //GetCustomization(); if (Session["cart"] != null) { Response.Redirect("Checkout.aspx"); } else { Response.Redirect("default.aspx"); } } else { Reader.Close(); LblMessage.Text = "Permission denied"; } MyCon.Close(); } catch (Exception ex) { LblMessage.Text = ex.Message.ToString(); } }
protected void BtnSave_Click(object sender, EventArgs e) { BtnChangeStatusCancel_Click(sender, e); try { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.CommandText = "USP_NextFinancialYear"; accountantCls.Cmd.Parameters.Add("@CompanyId", SqlDbType.Int).Value = Session["CompanyId"]; accountantCls.Cmd.Parameters.Add("@StartDate", SqlDbType.NVarChar).Value = _StartDateText.Text; accountantCls.Cmd.Parameters.Add("@EndDate", SqlDbType.NVarChar).Value = _EndDateText.Text; accountantCls.Cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = Session["UserCode"].ToString(); class1.ErrorNo = 0; accountantCls.beginTrans(); //int t = 0; //t = accountantCls.Cmd.ExecuteNonQuery(); class1.RecordId = Convert.ToInt32(accountantCls.Cmd.ExecuteScalar()); if (class1.RecordId == 0) { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.BranchAlreadyExists; } accountantCls.commitTrans(); } catch (Exception ex) { accountantCls.rollBackTrans(); class1.ErrorDesc = ex.Message; class1.ErrorNo = -1; } finally { SqlDataSource1.DataBind(); GvCompany.DataBind(); } }
void BindUnit() { try { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.CommandType = CommandType.Text; accountantCls.Cmd.CommandText = "select * from tvat"; DataSet MyDateSet = new DataSet(); accountantCls.beginTrans(); accountantCls.Adapter.SelectCommand = accountantCls.Cmd; accountantCls.Adapter.Fill(MyDateSet, "vat"); GridView1.DataSource = MyDateSet.Tables["vat"]; GridView1.DataBind(); accountantCls.commitTrans(); } catch (Exception ex) { LblMessage.Text = ex.Message.ToString(); } }
void BindUnit() { try { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.CommandText = "USP_Unit_Select"; accountantCls.Cmd.Parameters.Add("@UnitId", SqlDbType.Int).Value = 0; DataSet MyDateSet = new DataSet(); accountantCls.beginTrans(); accountantCls.Adapter.SelectCommand = accountantCls.Cmd; accountantCls.Adapter.Fill(MyDateSet, "Units"); GvDriver.DataSource = MyDateSet.Tables["Units"]; GvDriver.DataBind(); accountantCls.commitTrans(); } catch (Exception ex) { LblMessage.Text = ex.Message.ToString(); } }
void GetCustomization() { Class1 class1 = new Class1(); try { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.CommandText = "USP_Customization_SelById"; accountantCls.Cmd.Parameters.Clear(); accountantCls.Cmd.Parameters.Add("CompanyId", SqlDbType.Int).Value = int.Parse(Session["CompanyID"].ToString()); accountantCls.beginTrans(); accountantCls.Reader = accountantCls.Cmd.ExecuteReader(); if (accountantCls.Reader.Read()) { //TxtBankGroup.Text = accountantCls.Reader["BankGroup"].ToString(); //TxtCashGroup.Text = accountantCls.Reader["CashGroup"].ToString(); //TxtChequeGroup.Text = accountantCls.Reader["ChequeGroup"].ToString(); //TxtProfitLossLedger.Text = accountantCls.Reader["ProfitLossLedger"].ToString(); //TxtCustomerGroup.Text = accountantCls.Reader["CustomerGroup"].ToString(); //TxtEmployeeGroup.Text = accountantCls.Reader["EmployeeGroup"].ToString(); //TxtSupplierGroup.Text = accountantCls.Reader["SupplierGroup"].ToString(); //RadioButtonListPostingType.SelectedValue = accountantCls.Reader["PostingType"].ToString(); } accountantCls.Reader.Close(); accountantCls.commitTrans(); } catch (Exception ex) { accountantCls.rollBackTrans(); class1.ErrorDesc = ex.Message; class1.ErrorNo = -1; } }
void GetCustomization() { Class1 queryResult = new Class1(); try { Session["CompanyId"] = "7"; accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.CommandType = CommandType.Text; accountantCls.Cmd.CommandText = "select * from tCustomizations WHERE CompanyId = " + Session["CompanyId"].ToString(); accountantCls.beginTrans(); accountantCls.Reader = accountantCls.Cmd.ExecuteReader(); if (accountantCls.Reader.Read()) { //Class2 class2 = new Class2() //{ Session["BankGroup"] = accountantCls.Reader["BankGroup"].ToString(); Session["CashGroup"] = accountantCls.Reader["CashGroup"].ToString(); Session["ChequeGroup"] = accountantCls.Reader["ChequeGroup"].ToString(); Session["CustomerGroup"] = accountantCls.Reader["CustomerGroup"].ToString(); Session["EmployeeGroup"] = accountantCls.Reader["EmployeeGroup"].ToString(); Session["IsVoucherNoMandatory"] = accountantCls.Reader["IsVoucherNoMandatory"].ToString(); Session["PostingType"] = accountantCls.Reader["PostingType"].ToString(); Session["ProfitLossLedger"] = accountantCls.Reader["ProfitLossLedger"].ToString(); Session["SupplierGroup"] = accountantCls.Reader["SupplierGroup"].ToString(); //Session["BankGroup"] = Convert.ToInt32(accountantCls.Reader["BankGroup"].ToString()); //Session["CashGroup"] = Convert.ToInt32(accountantCls.Reader["CashGroup"].ToString()); //Session["ChequeGroup"] = Convert.ToInt32(accountantCls.Reader["ChequeGroup"].ToString()); //Session["CustomerGroup"] = Convert.ToInt32(accountantCls.Reader["CustomerGroup"].ToString()); //Session["EmployeeGroup "] = Convert.ToInt32(accountantCls.Reader["EmployeeGroup"].ToString()); //Session["IsVoucherNoMandatory "] = Convert.ToBoolean(accountantCls.Reader["IsVoucherNoMandatory"].ToString()); //Session["PostingType "] = Convert.ToInt32(accountantCls.Reader["PostingType"].ToString()); //Session["ProfitLossLedger "] = accountantCls.Reader["ProfitLossLedger"].ToString(); //Session["SupplierGroup "] = Convert.ToInt32(accountantCls.Reader["SupplierGroup"].ToString()); //}; } accountantCls.Reader.Close(); //accountantCls.commitTrans(); } catch (Exception ex) { //accountantCls.rollBackTrans(); queryResult.ErrorDesc = ex.Message; queryResult.ErrorNo = -1; } }
protected void BtnUpdate_Click(object sender, EventArgs e) { string s1 = "0"; string s2 = "0"; string s3 = "0"; string s4 = "0"; string s5 = "0"; string s6 = "0"; string s7 = "0"; string s8 = "0"; string s9 = "0"; int d = 0; TextBoxLength.Text = ""; foreach (TextBox textBox in pnlTextBoxes.Controls.OfType <TextBox>()) { d = d + 1; if (d == 1) { s1 = textBox.Text; TextBoxLength.Text += s1; } else if (d == 2) { s2 = textBox.Text; TextBoxLength.Text += s2; } else if (d == 3) { s3 = textBox.Text; TextBoxLength.Text += s3; } else if (d == 4) { s4 = textBox.Text; TextBoxLength.Text += s4; } else if (d == 5) { s5 = textBox.Text; TextBoxLength.Text += s5; } else if (d == 6) { s6 = textBox.Text; TextBoxLength.Text += s6; } else if (d == 7) { s7 = textBox.Text; TextBoxLength.Text += s7; } else if (d == 8) { s8 = textBox.Text; TextBoxLength.Text += s8; } else if (d == 9) { s9 = textBox.Text; TextBoxLength.Text += s9; } } try { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.CommandText = "USP_Company_CreateChartLength"; accountantCls.Cmd.Parameters.Add("@CompanyId", SqlDbType.Int).Value = int.Parse(ViewState["EditId"].ToString()); accountantCls.Cmd.Parameters.Add("@NoOfChartLevels", SqlDbType.Int).Value = int.Parse(_TextBoxCount.Text); accountantCls.Cmd.Parameters.Add("@ChartLastLevelLength", SqlDbType.NVarChar, 50).Value = TextBoxLength.Text; accountantCls.Cmd.Parameters.Add("@CreatedBy", SqlDbType.Int).Value = Session["UserCode"].ToString(); accountantCls.Cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = DateTime.Now; class1.ErrorNo = 0; accountantCls.beginTrans(); int t = accountantCls.Cmd.ExecuteNonQuery(); accountantCls.Cmd.Parameters.Clear(); accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.CommandText = "USP_ChartingLevel_Save"; accountantCls.Cmd.Parameters.Add("@CompanyId", SqlDbType.Int).Value = int.Parse(ViewState["EditId"].ToString()); accountantCls.Cmd.Parameters.Add("@Level1", SqlDbType.NVarChar, 50).Value = s1.ToString(); accountantCls.Cmd.Parameters.Add("@Level2", SqlDbType.NVarChar, 50).Value = s2.ToString(); accountantCls.Cmd.Parameters.Add("@Level3", SqlDbType.NVarChar, 50).Value = s3.ToString(); accountantCls.Cmd.Parameters.Add("@Level4", SqlDbType.NVarChar, 50).Value = s4.ToString(); accountantCls.Cmd.Parameters.Add("@Level5", SqlDbType.NVarChar, 50).Value = s5.ToString(); accountantCls.Cmd.Parameters.Add("@Level6", SqlDbType.NVarChar, 50).Value = s6.ToString(); accountantCls.Cmd.Parameters.Add("@Level7", SqlDbType.NVarChar, 50).Value = s7.ToString(); accountantCls.Cmd.Parameters.Add("@Level8", SqlDbType.NVarChar, 50).Value = s8.ToString(); accountantCls.Cmd.Parameters.Add("@Level9", SqlDbType.NVarChar, 50).Value = s9.ToString(); t = accountantCls.Cmd.ExecuteNonQuery(); if (ViewState["EditId"].ToString() == "0") { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.CompanyAlreadyExists; SqlDataSource1.DataBind(); GvCompany.DataBind(); } else if (t == -1) { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.UserAlreadyExists; } accountantCls.commitTrans(); } catch (Exception ex) { accountantCls.rollBackTrans(); class1.ErrorDesc = ex.Message; class1.ErrorNo = -1; } finally { SqlDataSource1.DataBind(); GvCompany.DataBind(); BtnSave.Visible = true; BtnUpdate.Visible = false; BtnClear_Click(sender, e); } }
protected void BtnUpdate_Click(object sender, EventArgs e) { string url = ""; Class_ImageResize ClsImage = new Class_ImageResize(); LabelErrorMessage.Text = ""; if (UploadCategory.HasFile) // CHECK IF ANY FILE HAS BEEN SELECTED. { HttpFileCollection hfc = Request.Files; if (hfc.Count <= 10) // 10 FILES RESTRICTION. { for (int i = 0; i <= hfc.Count - 1; i++) { HttpPostedFile hpf = hfc[i]; url = ClsImage.imageresize(hpf); } LabelErrorMessage.Text += "<br> Total <b>" + hfc.Count + "</b> file(s) "; } else { LabelErrorMessage.Text = "Max. 10 files allowed."; } } else { url = H1.NavigateUrl; } Class1 queryResult = new Class1(); try { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.CommandText = "USP_ItemGroup_Update"; accountantCls.Cmd.Parameters.Add("@ItemGroupId", SqlDbType.Int).Value = ItemGroupId; accountantCls.Cmd.Parameters.Add("@ItemGroupName", SqlDbType.NVarChar).Value = _ItemGroupNameText.Text; accountantCls.Cmd.Parameters.Add("@CategoryImage", SqlDbType.NVarChar).Value = url; queryResult.ErrorNo = 0; accountantCls.beginTrans(); queryResult.RecordId = Convert.ToInt32(accountantCls.Cmd.ExecuteScalar()); if (queryResult.RecordId == 0) { queryResult.ErrorNo = -1; queryResult.ErrorDesc = Resources.ResourceMain.ChartAlreadyExists; queryResult.ErrorFunction = " Finance.DAL.ChartOfAccount.SaveGroup"; } else if (queryResult.RecordId == -1) { queryResult.ErrorNo = -1; queryResult.ErrorDesc = Resources.ResourceMain.EndOfLevel; queryResult.ErrorFunction = " Finance.DAL.ChartOfAccount.SaveGroup"; } accountantCls.Cmd.CommandType = CommandType.Text; accountantCls.Cmd.CommandText = "select ItemGroupCode From tItemGroups where ItemGroupId = " + queryResult.RecordId; queryResult.OtherData = accountantCls.Cmd.ExecuteScalar(); accountantCls.commitTrans(); LabelErrorMessage.Text = "Saved Successfully"; TreeView1.ExpandAll(); } catch (Exception ex) { accountantCls.rollBackTrans(); queryResult.ErrorDesc = ex.Message; queryResult.ErrorNo = -1; queryResult.ErrorFunction = " Finance.DAL.ChartOfAccount.SaveGroup"; } PopulateTreeView(); LblNodeValue.Text = ""; }
protected void BtnSave_Click(object sender, EventArgs e) { //Session["CompanyId"] = "24"; try { Session["AccFrom"] = "S"; accountantCls.GetLevelChartIDLevel5(); Session["Cut"] = _CustomerNameText.Text; accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.Parameters.Clear(); accountantCls.Cmd.CommandText = "USP_Customer_Save_Supplier"; accountantCls.Cmd.Parameters.Add("CustomerId", SqlDbType.Int).Value = 0; accountantCls.Cmd.Parameters.Add("CustomerName", SqlDbType.NVarChar).Value = Session["Cut"].ToString(); accountantCls.Cmd.Parameters.Add("CUSTypeOfBusiness", SqlDbType.Int).Value = 0; accountantCls.Cmd.Parameters.Add("CountryId", SqlDbType.Int).Value = 966; accountantCls.Cmd.Parameters.Add("CityId", SqlDbType.Int).Value = 0; accountantCls.Cmd.Parameters.Add("CUSIDType", SqlDbType.Int).Value = 0; accountantCls.Cmd.Parameters.Add("CUSIdNumber", SqlDbType.NVarChar).Value = 0; accountantCls.Cmd.Parameters.Add("CUSEmail", SqlDbType.NVarChar).Value = _EmailText.Text; accountantCls.Cmd.Parameters.Add("CUSContactNo", SqlDbType.NVarChar).Value = _MobileText.Text; accountantCls.Cmd.Parameters.Add("CUSFaxNo", SqlDbType.NVarChar).Value = "-"; accountantCls.Cmd.Parameters.Add("CUSAddress", SqlDbType.NVarChar).Value = "-"; accountantCls.Cmd.Parameters.Add("Password", SqlDbType.NVarChar).Value = Midwest.Security.RijndaelEncryptionAlg.RijndaelEncryption.Encrypt(_PasswordText.Text); accountantCls.Cmd.Parameters.Add("CompanyId", SqlDbType.Int).Value = Session["CompanyId"].ToString(); accountantCls.Cmd.Parameters.Add("COAChartCode", SqlDbType.NVarChar).Value = Session["COAChartCode"].ToString(); accountantCls.Cmd.Parameters.Add("@CreatedBy", SqlDbType.Int).Value = 0; accountantCls.Cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = DateTime.Now; //accountantCls.Cmd.Parameters.Add("CustomerId", SqlDbType.Int).Value = 0; //accountantCls.Cmd.Parameters.Add("CustomerName", SqlDbType.NVarChar).Value = _CustomerNameText.Text; //accountantCls.Cmd.Parameters.Add("CUSTypeOfBusiness", SqlDbType.Int).Value = 0; //accountantCls.Cmd.Parameters.Add("CountryId", SqlDbType.Int).Value = 966; //accountantCls.Cmd.Parameters.Add("CityId", SqlDbType.Int).Value = 0; //accountantCls.Cmd.Parameters.Add("CUSIDType", SqlDbType.Int).Value = 0; //accountantCls.Cmd.Parameters.Add("CUSIdNumber", SqlDbType.NVarChar).Value = 0; //accountantCls.Cmd.Parameters.Add("CUSEmail", SqlDbType.NVarChar).Value = _EmailText.Text; //accountantCls.Cmd.Parameters.Add("CUSContactNo", SqlDbType.NVarChar).Value = _MobileText.Text; //accountantCls.Cmd.Parameters.Add("CUSFaxNo", SqlDbType.NVarChar).Value = "-"; //accountantCls.Cmd.Parameters.Add("CUSAddress", SqlDbType.NVarChar).Value = "-"; //accountantCls.Cmd.Parameters.Add("Password", SqlDbType.NVarChar).Value = Midwest.Security.RijndaelEncryptionAlg.RijndaelEncryption.Encrypt(_PasswordText.Text); //accountantCls.Cmd.Parameters.Add("CompanyId", SqlDbType.Int).Value = Session["CompanyId"].ToString(); //accountantCls.Cmd.Parameters.Add("LedgerId", SqlDbType.Int).Value = 0; //accountantCls.Cmd.Parameters.Add("@CreatedBy", SqlDbType.Int).Value = Session["UserCode"].ToString(); //accountantCls.Cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = DateTime.Now; class1.ErrorNo = 0; accountantCls.beginTrans(); class1.RecordId = Convert.ToInt32(accountantCls.Cmd.ExecuteScalar()); if (class1.RecordId == 0) { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.CompanyAlreadyExists; } else if (class1.RecordId == -1) { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.UserAlreadyExists; } else { Session["EditId"] = class1.RecordId; LabelErrorMessage.Text = "Successfully registered, you can add more information about your self or login to system"; BtnClear.Visible = true; BtnSave.Visible = false; } accountantCls.commitTrans(); } catch (Exception ex) { accountantCls.rollBackTrans(); class1.ErrorDesc = ex.Message; class1.ErrorNo = -1; } finally { SqlDataSource1.DataBind(); } }
protected void BtnSave_Click(object sender, EventArgs e) { try { if (RadioButtonListAccountType.SelectedValue == "0") { Session["AccFrom"] = "B"; } else { Session["AccFrom"] = "CA"; } accountantCls.GetLevelChartIDLevel5(); _LedgerIdText.Text = Session["COAChartCode"].ToString(); Session["Cut"] = _BNKBankNameArabicText.Text + " : " + _BNKBankNameEnglishText.Text; accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.Parameters.Clear(); accountantCls.Cmd.CommandText = "USP_Bank_Save"; accountantCls.Cmd.Parameters.Add("@BankId", SqlDbType.Int).Value = 0; accountantCls.Cmd.Parameters.Add("@CompanyId", SqlDbType.Int).Value = Session["CompanyId"].ToString(); accountantCls.Cmd.Parameters.Add("@BNKBankNameArabic", SqlDbType.NVarChar).Value = _BNKBankNameArabicText.Text; accountantCls.Cmd.Parameters.Add("@BNKBankNameEnglish", SqlDbType.NVarChar).Value = _BNKBankNameEnglishText.Text; accountantCls.Cmd.Parameters.Add("@LedgerId", SqlDbType.NVarChar).Value = Session["COAChartCode"].ToString(); accountantCls.Cmd.Parameters.Add("@AccountType", SqlDbType.NVarChar).Value = RadioButtonListAccountType.SelectedValue; accountantCls.Cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = Session["UserCode"].ToString(); class1.ErrorNo = 0; accountantCls.beginTrans(); //accountantCls.Cmd.ExecuteNonQuery(); class1.RecordId = Convert.ToInt32(accountantCls.Cmd.ExecuteScalar()); ////update applications status - finance accountantCls.Cmd.Parameters.Clear(); if (class1.RecordId == 0) { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.CompanyAlreadyExists; } else if (class1.RecordId == -1) { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.UserAlreadyExists; } accountantCls.commitTrans(); } catch (Exception ex) { accountantCls.rollBackTrans(); class1.ErrorDesc = ex.Message; class1.ErrorNo = -1; } finally { SqlDataSource1.DataBind(); GvCompany.DataBind(); } }
protected void BtnUpdate_Click(object sender, EventArgs e) { try { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.CommandText = "USP_Customer_Edit"; accountantCls.Cmd.Parameters.Add("@CustomerId", SqlDbType.Int).Value = int.Parse(ViewState["EditId"].ToString()); accountantCls.Cmd.Parameters.Add("CustomerName", SqlDbType.NVarChar).Value = _CustomerNameText.Text; accountantCls.Cmd.Parameters.Add("CUSTypeOfBusiness", SqlDbType.Int).Value = 0; accountantCls.Cmd.Parameters.Add("CountryId", SqlDbType.Int).Value = 966; accountantCls.Cmd.Parameters.Add("CityId", SqlDbType.Int).Value = _CustCityInfo.SelectedValue; accountantCls.Cmd.Parameters.Add("CUSIDType", SqlDbType.Int).Value = _CUSIDType.SelectedValue; accountantCls.Cmd.Parameters.Add("CUSIdNumber", SqlDbType.NVarChar).Value = CUSIdNumber.Text; accountantCls.Cmd.Parameters.Add("CUSEmail", SqlDbType.NVarChar).Value = _EmailText.Text; accountantCls.Cmd.Parameters.Add("CUSContactNo", SqlDbType.NVarChar).Value = _MobileText.Text; accountantCls.Cmd.Parameters.Add("CUSFaxNo", SqlDbType.NVarChar).Value = "-"; accountantCls.Cmd.Parameters.Add("CUSAddress", SqlDbType.NVarChar).Value = _CUSAddress.Text; accountantCls.Cmd.Parameters.Add("Password", SqlDbType.NVarChar).Value = Midwest.Security.RijndaelEncryptionAlg.RijndaelEncryption.Encrypt(_PasswordText.Text); accountantCls.Cmd.Parameters.Add("CompanyId", SqlDbType.Int).Value = Session["CompanyId"].ToString(); accountantCls.Cmd.Parameters.Add("LedgerId", SqlDbType.Int).Value = 0; accountantCls.Cmd.Parameters.Add("@CreatedBy", SqlDbType.Int).Value = Session["UserCode"].ToString(); accountantCls.Cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = DateTime.Now; class1.ErrorNo = 0; accountantCls.beginTrans(); int t = 0; t = accountantCls.Cmd.ExecuteNonQuery(); accountantCls.Cmd.Parameters.Clear(); if (ViewState["EditId"].ToString() == "0") { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.CompanyAlreadyExists; SqlDataSource1.DataBind(); } else if (t == -1) { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.UserAlreadyExists; } accountantCls.commitTrans(); BtnUpdate.Visible = false; } catch (Exception ex) { accountantCls.rollBackTrans(); class1.ErrorDesc = ex.Message; class1.ErrorNo = -1; } finally { SqlDataSource1.DataBind(); } }
protected void BtnSave_Click(object sender, EventArgs e) { if (_VoucherNoText.Text == null) { _VoucherNoText.Text = ""; } try { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.CommandType = CommandType.StoredProcedure; //accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.beginTrans(); if (ViewState["EditId"].ToString() != "0") { accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.Parameters.Clear(); accountantCls.Cmd.CommandText = "USP_Voucher_Log"; accountantCls.Cmd.Parameters.Add("@VoucherId", SqlDbType.Int).Value = ViewState["EditId"]; accountantCls.Cmd.ExecuteNonQuery(); } //Voucher Master accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.Parameters.Clear(); accountantCls.Cmd.CommandText = "USP_VoucherMaster_Ins"; accountantCls.Cmd.Parameters.Add("@VoucherId", SqlDbType.Int).Value = ViewState["EditId"]; accountantCls.Cmd.Parameters.Add("@VoucherType", SqlDbType.VarChar).Value = "P"; accountantCls.Cmd.Parameters.Add("@CompanyID", SqlDbType.Int).Value = Session["CompanyId"].ToString(); accountantCls.Cmd.Parameters.Add("@FinYearID", SqlDbType.Int).Value = Session["FinYearID"].ToString(); accountantCls.Cmd.Parameters.Add("@ManualVoucherNo", SqlDbType.NVarChar).Value = _VoucherNoText.Text; accountantCls.Cmd.Parameters.Add("@VoucherDate", SqlDbType.VarChar).Value = _VoucherDateText.Text; accountantCls.Cmd.Parameters.Add("@PayedReceivedBy", SqlDbType.NVarChar).Value = _ReceiverNameText.Text; accountantCls.Cmd.Parameters.Add("@PaymentType", SqlDbType.Int).Value = _ddReceiptType.SelectedValue; accountantCls.Cmd.Parameters.Add("@BankType", SqlDbType.Int).Value = _ddPaymentType.SelectedValue; if (_TransferDateText.Text == null) { accountantCls.Cmd.Parameters.Add("@BankTransferDate", SqlDbType.VarChar).Value = DBNull.Value; } else { accountantCls.Cmd.Parameters.Add("@BankTransferDate", SqlDbType.VarChar).Value = _TransferDateText.Text; } accountantCls.Cmd.Parameters.Add("@ChequeNo", SqlDbType.NVarChar).Value = _TxtChequeNo.Text; accountantCls.Cmd.Parameters.Add("@ChequePayeeName", SqlDbType.NVarChar).Value = _TxtPayeeName.Text; if (_TransferDateText.Text == null) { accountantCls.Cmd.Parameters.Add("@ChequeDate", SqlDbType.VarChar).Value = DBNull.Value; } else { accountantCls.Cmd.Parameters.Add("@ChequeDate", SqlDbType.VarChar).Value = _TransferDateText.Text; } accountantCls.Cmd.Parameters.Add("@PlaceOfIssue", SqlDbType.NVarChar).Value = _TxtPlaceOfIssue.Text; accountantCls.Cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = _DescriptionText.Text; accountantCls.Cmd.Parameters.Add("@IsSingle", SqlDbType.Bit).Value = Convert.ToBoolean(0); accountantCls.Cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = Session["UserCode"].ToString(); int vouhcerId = Convert.ToInt32(accountantCls.Cmd.ExecuteScalar()); if (ViewState["EditId"].ToString() != "0") { vouhcerId = int.Parse(ViewState["EditId"].ToString()); } if (vouhcerId > 0)// To ledger { accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.Parameters.Clear(); accountantCls.Cmd.CommandText = "USP_VoucherDetail_Ins"; accountantCls.Cmd.Parameters.Add("@VoucherID", SqlDbType.Int).Value = vouhcerId; accountantCls.Cmd.Parameters.Add("@TransactionType", SqlDbType.VarChar).Value = "P";//to accountantCls.Cmd.Parameters.Add("@LedgerId", SqlDbType.Int).Value = _ddPayedTo.SelectedValue; accountantCls.Cmd.Parameters.Add("@FinYearId", SqlDbType.Int).Value = Session["FinYearID"].ToString(); //accountantCls.Cmd.Parameters.Add("@BranchId", SqlDbType.Int).Value = _ddBranchName.SelectedValue; //accountantCls.Cmd.Parameters.Add("@DepartmentId", SqlDbType.Int).Value = _ddDepartment.SelectedValue; //accountantCls.Cmd.Parameters.Add("@DivisionId", SqlDbType.Int).Value = _ddUnitName.SelectedValue; accountantCls.Cmd.Parameters.Add("@Debit", SqlDbType.Decimal).Value = 0; accountantCls.Cmd.Parameters.Add("@Credit", SqlDbType.Decimal).Value = _TxtAmount.Text; accountantCls.Cmd.Parameters.Add("@ForeignAmount", SqlDbType.Decimal).Value = _TxtCurrency.Text; accountantCls.Cmd.Parameters.Add("@ExchangeRate", SqlDbType.Decimal).Value = _TxtValue.Text; accountantCls.Cmd.Parameters.Add("@Description", SqlDbType.NVarChar).Value = _TxtDescription.Text; accountantCls.Cmd.Parameters.Add("@CostCenterApplicable", SqlDbType.Int).Value = 0; accountantCls.Cmd.Parameters.Add("@VoucherDate", SqlDbType.VarChar).Value = _VoucherDateText.Text; accountantCls.Cmd.Parameters.Add("@ManualVoucherNo", SqlDbType.NVarChar).Value = _VoucherNoText.Text; int vouhcerDetailId = Convert.ToInt32(accountantCls.Cmd.ExecuteScalar()); class1.ErrorNo = 0; class1.RecordId = vouhcerId; accountantCls.commitTrans(); } else { accountantCls.rollBackTrans(); class1.ErrorDesc = "Error while saving to voucher master"; class1.ErrorNo = -1; class1.ErrorFunction = " Finance.DAL.Voucher.Save"; } } catch (Exception ex) { accountantCls.rollBackTrans(); class1.ErrorDesc = ex.Message; class1.ErrorNo = -1; class1.ErrorFunction = " Finance.DAL.Voucher.Save"; } }
protected void BtnSave_Click(object sender, EventArgs e) { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.beginTrans(); //accountantCls.Cmd.Connection.Open(); accountantCls.Cmd.CommandText = "select * from tItems where ItemCode=N'" + TxtProductCode.Text + "'"; SqlDataReader Reader = accountantCls.Cmd.ExecuteReader(); if (Reader.Read()) { LblMessage.Text = "Already exists"; return; } Reader.Close(); string url = ""; Class_ImageResize ClsImage = new Class_ImageResize(); LblMessage.Text = ""; if (FileUpload1.HasFile) // CHECK IF ANY FILE HAS BEEN SELECTED. { HttpFileCollection hfc = Request.Files; if (hfc.Count <= 10) // 10 FILES RESTRICTION. { for (int i = 0; i <= hfc.Count - 1; i++) { HttpPostedFile hpf = hfc[i]; url = ClsImage.imageresize(hpf); } LblMessage.Text += "<br> Total <b>" + hfc.Count + "</b> file(s) "; } else { LblMessage.Text = "Max. 10 files allowed."; } } else { url = "UploadedImages/no-image-available.png"; } try { accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.CommandText = "USP_Item_Save"; accountantCls.Cmd.Parameters.Add("@ItemId", SqlDbType.Int).Value = 0; accountantCls.Cmd.Parameters.Add("@CompanyId", SqlDbType.Int).Value = int.Parse(Session["CompanyId"].ToString()); // accountantCls.Cmd.Parameters.Add("@BranchId", SqlDbType.Int).Value = Session["BranchId"].ToString(); accountantCls.Cmd.Parameters.Add("@ItemGroupId", SqlDbType.Int).Value = TreeView1.SelectedNode.Value; accountantCls.Cmd.Parameters.Add("@Level", SqlDbType.Int).Value = Level; accountantCls.Cmd.Parameters.Add("@ItemCode", SqlDbType.NVarChar).Value = TxtProductCode.Text; accountantCls.Cmd.Parameters.Add("@ItemName", SqlDbType.NVarChar).Value = TxtProductName.Text; accountantCls.Cmd.Parameters.Add("@ProductNameEng", SqlDbType.NVarChar).Value = TxtProductNameEng.Text; accountantCls.Cmd.Parameters.Add("@ItemLocation", SqlDbType.NVarChar).Value = TxtLocation.Text; accountantCls.Cmd.Parameters.Add("@BasicUnit", SqlDbType.Int).Value = DropDownListUnitName.SelectedValue; accountantCls.Cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = Session["UserCode"].ToString(); accountantCls.Cmd.Parameters.Add("@IsActive", SqlDbType.NChar).Value = RadioButtonListActive.SelectedValue; accountantCls.Cmd.Parameters.Add("@VAT_Id", SqlDbType.NChar).Value = DropDownListVATvalue.SelectedValue; accountantCls.Cmd.Parameters.Add("@ItemType", SqlDbType.Int).Value = DropDownListWeight.SelectedValue; accountantCls.Cmd.Parameters.Add("@AgentCode", SqlDbType.Int).Value = DropDownList2.SelectedValue; accountantCls.Cmd.Parameters.Add("@ImageURL", SqlDbType.NVarChar).Value = url; accountantCls.Cmd.Parameters.Add("@IsDisplayed", SqlDbType.NVarChar).Value = RadioButtonListIsDisplayed.SelectedValue; accountantCls.Cmd.Parameters.Add("@Details", SqlDbType.NVarChar).Value = TxtDetails.Text; accountantCls.Cmd.Parameters.Add("@OrderQuantity", SqlDbType.Int).Value = TxtOrderQuantity.Text; accountantCls.Cmd.Parameters.Add("@LeastQuantity", SqlDbType.Int).Value = TxtLeastQuantity.Text; int RecordId = Convert.ToInt32(accountantCls.Cmd.ExecuteScalar()); accountantCls.Cmd.Parameters.Clear(); accountantCls.Cmd.CommandText = "USP_Item_Pricing"; accountantCls.Cmd.Parameters.Add("@ItemId", SqlDbType.Int).Value = RecordId; accountantCls.Cmd.Parameters.Add("@FillQuantity", SqlDbType.Int).Value = TxtAvaiableQuantity.Text; accountantCls.Cmd.Parameters.Add("@CostPrice", SqlDbType.Decimal).Value = TxtPrice.Text; accountantCls.Cmd.Parameters.Add("@AveragePrice", SqlDbType.Decimal).Value = TxtAveragePrice.Text; accountantCls.Cmd.Parameters.Add("@SalePrice", SqlDbType.Decimal).Value = TxtSalePrice.Text; accountantCls.Cmd.Parameters.Add("@MinSalePrice", SqlDbType.Decimal).Value = TxtMinSalePrice.Text; accountantCls.Cmd.Parameters.Add("@WholeSalePrice", SqlDbType.Decimal).Value = TxtWholeSalePrice.Text; accountantCls.Cmd.Parameters.Add("@OutSidePrice", SqlDbType.Int).Value = TxtOutSidePrice.Text; accountantCls.Cmd.Parameters.Add("@BarCode", SqlDbType.NVarChar).Value = TxtBarcode.Text; accountantCls.Cmd.Parameters.Add("@OfferPrice", SqlDbType.NVarChar).Value = TxtOfferPrice.Text; accountantCls.Cmd.ExecuteNonQuery(); accountantCls.commitTrans(); } catch (Exception ex) { accountantCls.rollBackTrans(); LblMessage.Text = ex.Message.ToString(); } }
protected void BtnEdit_Click(object sender, EventArgs e) { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); int RecordId = 0; try { accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.CommandText = "USP_Item_Pricing_Select_Summ"; accountantCls.Cmd.Parameters.Add("@ItemId", SqlDbType.Int).Value = Session["ProductId"].ToString(); accountantCls.beginTrans(); RecordId = Convert.ToInt32(accountantCls.Cmd.ExecuteScalar()); } catch (Exception ex) { } string url = ""; Class_ImageResize ClsImage = new Class_ImageResize(); LblMessage.Text = ""; if (FileUpload1.HasFile) // CHECK IF ANY FILE HAS BEEN SELECTED. { HttpFileCollection hfc = Request.Files; if (hfc.Count <= 10) // 10 FILES RESTRICTION. { for (int i = 0; i <= hfc.Count - 1; i++) { HttpPostedFile hpf = hfc[i]; url = ClsImage.imageresize(hpf); } LblMessage.Text += "<br> Total <b>" + hfc.Count + "</b> file(s) "; } else { LblMessage.Text = "Max. 10 files allowed."; } } else { url = H1.NavigateUrl; } try { accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.CommandText = "USP_Item_Edit_Summ"; accountantCls.Cmd.Parameters.Clear(); accountantCls.Cmd.Parameters.Add("@ItemId", SqlDbType.Int).Value = Session["ProductId"].ToString(); accountantCls.Cmd.Parameters.Add("@ItemCode", SqlDbType.NVarChar).Value = TxtProductCode.Text; accountantCls.Cmd.Parameters.Add("@ItemName", SqlDbType.NVarChar).Value = TxtProductName.Text; accountantCls.Cmd.Parameters.Add("@ProductNameEng", SqlDbType.NVarChar).Value = TxtProductNameEng.Text; accountantCls.Cmd.Parameters.Add("@BasicUnit", SqlDbType.Int).Value = DropDownListUnitName.SelectedValue; accountantCls.Cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = Session["UserCode"].ToString(); accountantCls.Cmd.Parameters.Add("@IsActive", SqlDbType.NChar).Value = RadioButtonListActive.SelectedValue; accountantCls.Cmd.Parameters.Add("@IsVAT", SqlDbType.NChar).Value = DropDownListVATvalue.SelectedValue; accountantCls.Cmd.Parameters.Add("@ImageURL", SqlDbType.NVarChar).Value = url; accountantCls.Cmd.Parameters.Add("@IsDisplayed", SqlDbType.NVarChar).Value = RadioButtonListIsDisplayed.SelectedValue; accountantCls.Cmd.Parameters.Add("@Details", SqlDbType.NVarChar).Value = TxtDetails.Text; accountantCls.Cmd.Parameters.Add("@OrderQuantity", SqlDbType.Int).Value = TxtOrderQuantity.Text; accountantCls.Cmd.Parameters.Add("@LeastQuantity", SqlDbType.Int).Value = TxtLeastQuantity.Text; accountantCls.Cmd.ExecuteNonQuery(); accountantCls.Cmd.Parameters.Clear(); if (RecordId > 0) { accountantCls.Cmd.CommandText = "USP_Item_Pricing_Edit_Summ"; accountantCls.Cmd.Parameters.Add("ItemId", SqlDbType.Int).Value = Session["ProductId"].ToString(); accountantCls.Cmd.Parameters.Add("FillQuantity", SqlDbType.Decimal).Value = TxtAvaiableQuantity.Text; accountantCls.Cmd.Parameters.Add("CostPrice", SqlDbType.Decimal).Value = TxtPrice.Text; accountantCls.Cmd.Parameters.Add("SalePrice", SqlDbType.Decimal).Value = TxtSalePrice.Text; accountantCls.Cmd.Parameters.Add("MinSalePrice", SqlDbType.Decimal).Value = TxtMinSalePrice.Text; accountantCls.Cmd.Parameters.Add("WholeSalePrice", SqlDbType.Decimal).Value = TxtWholeSalePrice.Text; accountantCls.Cmd.Parameters.Add("OutSidePrice", SqlDbType.Decimal).Value = TxtOutSidePrice.Text; accountantCls.Cmd.Parameters.Add("OfferPrice", SqlDbType.Decimal).Value = TxtOfferPrice.Text; } else { accountantCls.Cmd.Parameters.Clear(); accountantCls.Cmd.CommandText = "USP_Item_Pricing"; accountantCls.Cmd.Parameters.Add("@ItemId", SqlDbType.Int).Value = Session["ProductId"].ToString(); accountantCls.Cmd.Parameters.Add("@FillQuantity", SqlDbType.Int).Value = TxtAvaiableQuantity.Text; accountantCls.Cmd.Parameters.Add("@CostPrice", SqlDbType.Decimal).Value = TxtPrice.Text; accountantCls.Cmd.Parameters.Add("@AveragePrice", SqlDbType.Decimal).Value = 0; accountantCls.Cmd.Parameters.Add("@SalePrice", SqlDbType.Decimal).Value = TxtSalePrice.Text; accountantCls.Cmd.Parameters.Add("@MinSalePrice", SqlDbType.Decimal).Value = TxtMinSalePrice.Text; accountantCls.Cmd.Parameters.Add("@WholeSalePrice", SqlDbType.Decimal).Value = TxtWholeSalePrice.Text; accountantCls.Cmd.Parameters.Add("@OutSidePrice", SqlDbType.Int).Value = TxtOutSidePrice.Text; accountantCls.Cmd.Parameters.Add("@BarCode", SqlDbType.NVarChar).Value = 0; accountantCls.Cmd.Parameters.Add("@OfferPrice", SqlDbType.Decimal).Value = TxtOfferPrice.Text; } accountantCls.Cmd.ExecuteNonQuery(); accountantCls.commitTrans(); } catch (Exception ex) { accountantCls.rollBackTrans(); } BindProduct(); }
protected void BtnSave_Click(object sender, EventArgs e) { try { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.CommandText = "USP_Company_Save"; accountantCls.Cmd.Parameters.Add("@CompanyId", SqlDbType.Int).Value = 0; accountantCls.Cmd.Parameters.Add("@CMPCompanyName", SqlDbType.NVarChar).Value = _CMPCompanyNameText.Text; accountantCls.Cmd.Parameters.Add("@CMPShortName", SqlDbType.NVarChar).Value = _CMPCompanyNameText.Text; accountantCls.Cmd.Parameters.Add("@CMPAddress", SqlDbType.NText).Value = _CMPAddressText.Text; accountantCls.Cmd.Parameters.Add("@CMPEmail", SqlDbType.NVarChar).Value = _EmailText.Text; accountantCls.Cmd.Parameters.Add("@CMPPhone", SqlDbType.VarChar).Value = _MobileText.Text; accountantCls.Cmd.Parameters.Add("@CUSFaxNo", SqlDbType.VarChar).Value = ""; accountantCls.Cmd.Parameters.Add("@CCMPAccountingMonth", SqlDbType.Int).Value = 1; accountantCls.Cmd.Parameters.Add("@AdminUserName", SqlDbType.NVarChar).Value = Session["AdminUserName"].ToString(); accountantCls.Cmd.Parameters.Add("@DefaultPassword", SqlDbType.NVarChar).Value = Midwest.Security.RijndaelEncryptionAlg.RijndaelEncryption.Encrypt(_PasswordText.Text); accountantCls.Cmd.Parameters.Add("@CreatedBy", SqlDbType.Int).Value = Session["UserCode"].ToString(); accountantCls.Cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = DateTime.Now; class1.ErrorNo = 0; accountantCls.beginTrans(); //accountantCls.Cmd.ExecuteNonQuery(); class1.RecordId = Convert.ToInt32(accountantCls.Cmd.ExecuteScalar()); ////update applications status - finance accountantCls.Cmd.Parameters.Clear(); accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.CommandText = "USP_CompanyApplication_Save"; accountantCls.Cmd.Parameters.Add("@CompanyId", SqlDbType.Int).Value = class1.RecordId; accountantCls.Cmd.Parameters.Add("@ApplicationId", SqlDbType.Int).Value = 1; accountantCls.Cmd.Parameters.Add("@IsActive", SqlDbType.Bit).Value = 1; int t = accountantCls.Cmd.ExecuteNonQuery(); if (class1.RecordId == 0) { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.CompanyAlreadyExists; } else if (t == -1) { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.UserAlreadyExists; } accountantCls.commitTrans(); } catch (Exception ex) { accountantCls.rollBackTrans(); class1.ErrorDesc = ex.Message; class1.ErrorNo = -1; } finally { SqlDataSource1.DataBind(); GvCompany.DataBind(); } }
protected void BtnUpdate_Click(object sender, EventArgs e) { foreach (var control in Page.Controls) { if (control is TextBox) { if (((TextBox)control).ID.IndexOf("txtDynamic") != -1) { //string constr = ConfigurationManager.ConnectionStrings["constr"].ConnectionString; //using (SqlConnection con = new SqlConnection(constr)) //{ // using (SqlCommand cmd = new SqlCommand("INSERT INTO TI_Homes(CustomerID, Year, Make, Size, Owed, Offer, Wholesale) VALUES('1000', @name, @year, '80ft', '100,000', '80,000', 'Wholesale?')")) // { // cmd.Connection = con; // cmd.Parameters.AddWithValue("@name", ((TextBox)control).Text); // cmd.Parameters.AddWithValue("@year", (pnl.FindControl("txtDynamic2") as TextBox).Text); // con.Open(); // cmd.ExecuteNonQuery(); // con.Close(); // } // } } } } DataTable tbl = new DataTable(); tbl = (DataTable)Session["Tbl"]; int k = 0; TextBox TxtDynamic = new TextBox(); foreach (DataRow row in tbl.Rows) { //for (int k = 0; k < 4; k++) //{ TextBox txt = (TextBox)Page.FindControl(row[k + 1].ToString()); //} //foreach (Control contrl in Master.Controls) //{ // if (Master.FindControl("ContentPlaceHolder1") != null) // { // } //} //if (Master.FindControl("ContentPlaceHolder1") != null) //{ //if (Master.FindControl("ContentPlaceHolder1").FindControl("UpdatePanel1").FindControl("pnlTextBoxes").FindControl(row[k + 1]) != null) //{ // TextBox tb = (TextBox)Master.FindControl("pnlTextBoxes").FindControl("TxtDynamic" + (k + 1)); // ArrTextNames.Add(tb.Text); //} //} //if (Master.FindControl("UpdatePanel1").FindControl("pnlTextBoxes").FindControl("TxtDynamic" + (k + 1)) != null) //{ // TextBox tb = (TextBox)Master.FindControl("pnlTextBoxes").FindControl("TxtDynamic" + (k + 1)); // ArrTextNames.Add(tb.Text); //} } //foreach (Control ctrl in pnlTextBoxes.Controls) //{ // if (ctrl is Panel) // { // // Get each ID and Text from TextBox // var textBoxes = ctrl.Controls.OfType<TextBox>() // .Select(t => Tuple.Create(t.ID, t.Text)) // .ToList(); // foreach (var item in textBoxes) // { // ArrLengthOfEachLevels.Add(item.ToString()); // } // } //} //int i = 0; //foreach (Control contrl in this.pnlTextBoxes.Controls) //{ // if (contrl.ID == ("txt" + i.ToString())) // { // ArrLengthOfEachLevels.Add(contrl.ToString()); // //contrl.Text = "requiredtexttobeset"; // } // i = i + 1; //} try { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.CommandText = "USP_Company_CreateChartLength"; accountantCls.Cmd.Parameters.Add("@CompanyId", SqlDbType.Int).Value = int.Parse(ViewState["EditId"].ToString()); accountantCls.Cmd.Parameters.Add("@NoOfChartLevels", SqlDbType.Int).Value = int.Parse(_TextBoxCount.Text); accountantCls.Cmd.Parameters.Add("@ChartLastLevelLength", SqlDbType.NVarChar, 50).Value = TextBoxLength.Text; accountantCls.Cmd.Parameters.Add("@CreatedBy", SqlDbType.Int).Value = Session["UserCode"].ToString(); accountantCls.Cmd.Parameters.Add("@CreatedDate", SqlDbType.DateTime).Value = DateTime.Now; class1.ErrorNo = 0; accountantCls.beginTrans(); int t = accountantCls.Cmd.ExecuteNonQuery(); if (ViewState["EditId"].ToString() == "0") { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.CompanyAlreadyExists; SqlDataSource1.DataBind(); GvCompany.DataBind(); } else if (t == -1) { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.UserAlreadyExists; } accountantCls.commitTrans(); } catch (Exception ex) { accountantCls.rollBackTrans(); class1.ErrorDesc = ex.Message; class1.ErrorNo = -1; } finally { SqlDataSource1.DataBind(); GvCompany.DataBind(); BtnSave.Visible = true; BtnUpdate.Visible = false; } }
protected void btnUpdate_Click(object sender, EventArgs e) { LabelErrorMessage.Text = ""; foreach (GridViewRow rows in GridView1.Rows) { TextBox TxtTrans = (TextBox)rows.FindControl("TxtTransNo"); TextBox TxtReqAmount = (TextBox)rows.FindControl("txtInvoiceTotal"); TextBox TxtAmount = (TextBox)rows.FindControl("TxtAmount"); Session["Amount"] = TxtAmount.Text; double Amount = 0; double Req = 0; if (TxtAmount.Text.Trim() == "") { TxtAmount.Text = "0"; } if (TxtReqAmount.Text.Trim() == "") { TxtAmount.Text = "0"; } Amount = double.Parse(TxtAmount.Text.Trim()); Req = double.Parse(TxtReqAmount.Text.Trim()); CheckBox ck = (CheckBox)rows.FindControl("ck"); if (ck.Checked == true) { if (Amount != Req && Req != 0) { LabelErrorMessage.Text = "المبلغ المطلوب لا يساوي المدفوع "; return; } if (TxtTrans.Text.Trim() == "") { LabelErrorMessage.Text += " ادخل رقم عملية التحويل"; return; } //TextBox TxtTrans = (TextBox)rows.FindControl("TxtTransNo"); //TextBox TxtAmount = (TextBox)rows.FindControl("TxtAmount"); Session["TransactionNo"] = TxtTrans.Text; Session["Amount"] = TxtAmount.Text; Label lblInvoiceNo = (Label)rows.FindControl("lblInvoiceNo"); Session["InvoiceNo"] = lblInvoiceNo.Text.Trim(); //CheckBox ck = (CheckBox)rows.FindControl("ck"); if (ck.Checked == true) { Session["Note"] = "تم تحويل مبلغ : " + TxtAmount.Text + " بعملية رقم: " + TxtTrans.Text; //SqlDataSource1.Update(); try { accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr(); accountantCls.Cmd.CommandType = CommandType.StoredProcedure; accountantCls.Cmd.CommandText = "USP_Quotation_Edit_Invoice_Insert"; accountantCls.Cmd.Parameters.Add("@InvoiceNo", SqlDbType.NVarChar).Value = Session["InvoiceNo"].ToString(); accountantCls.Cmd.Parameters.Add("@Notes", SqlDbType.NVarChar).Value = Session["Note"]; //accountantCls.Cmd.Parameters.Add("@InvoiceStatusId", SqlDbType.Int).Value = "6"; class1.ErrorNo = 0; accountantCls.beginTrans(); int t = accountantCls.Cmd.ExecuteNonQuery(); if (class1.RecordId == 0) { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.CompanyAlreadyExists; } else if (t == -1) { class1.ErrorNo = -1; class1.ErrorDesc = Resources.ResourceMain.UserAlreadyExists; } accountantCls.commitTrans(); } catch (Exception ex) { accountantCls.rollBackTrans(); class1.ErrorDesc = ex.Message; class1.ErrorNo = -1; } finally { LabelErrorMessage.Text += "تمت العملية بنجاح "; } } } } Response.Redirect("DisplayMyOrderd.aspx"); }