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);
}
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)
{
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;
}
}
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)
{
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");
}
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 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 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)
{
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 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 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 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;
}
}
