//Midwest.Security.RijndaelEncryptionAlg.RijndaelEncryption RijndaelEncryption = new Midwest.Security.RijndaelEncryptionAlg.RijndaelEncryption();
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserCode"] == null)
{
Response.Redirect("default.aspx");
}
if (!IsPostBack)
{
if (Session["dir"].ToString() == "ltr")
{
//LabelCompanyName.Text = String.Format(global::Resources.ResourceMain.CompanyName);// GetLocalResourceObject("CompanyName").ToString();
}
else
{
//LabelCompanyName.Text = "اسم العميل";
/*LabelCompanyName.Text = String.Format(global::Resources.ResourceMain_Ar.CompanyName);*/// GetLocalResourceObject("CompanyName").ToString();
}
Session["CountryId"] = "966";
SqlDataSource1.DataBind();
GvCompany.DataBind();
//Session["CompanyId"] = "7";
;
ViewState["EditId"] = "0";
//Session["UserLog"] = "1";
//Session["AdminUserName"] = "******";
}
}
//Midwest.Security.RijndaelEncryptionAlg.RijndaelEncryption RijndaelEncryption = new Midwest.Security.RijndaelEncryptionAlg.RijndaelEncryption();
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserCode"] == null)
{
Response.Redirect("Signin.aspx");
}
if (!IsPostBack)
{
if (Session["dir"].ToString().Trim() == "ltr")
{
LabelCompanyName.Text = String.Format(global::Resources.ResourceMain.CompanyName);// GetLocalResourceObject("CompanyName").ToString().Trim();
LabelCompanyName.Text = "اسم العميل";
}
else
{
LabelCompanyName.Text = "اسم العميل";
/*LabelCompanyName.Text = String.Format(global::Resources.ResourceMain_Ar.CompanyName);*/// GetLocalResourceObject("CompanyName").ToString().Trim();
}
SqlDataSource1.DataBind();
GvCompany.DataBind();
SqlDataSource2.DataBind();
_CustCityInfo.DataBind();
_CustCityInfo.Items.Insert(0, new ListItem("الرجاء اختيار", "0"));
//Session["CompanyId"] = "7";
Session["CustomerId"] = "0";
ViewState["EditId"] = "0";
Session["AdminUserName"] = "******";
Bind();
}
}
protected void GvCompany_RowDeleting(object sender, GridViewDeleteEventArgs e)
{
Session["Id"] = e.Keys[0].ToString().Trim();
try
{
accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr();
accountantCls.beginTrans();
accountantCls.Cmd.CommandText = "delete from tUsers where UserId='" + Session["Id"].ToString().Trim() + "'";
accountantCls.Cmd.ExecuteNonQuery();
LabelErrorMessage.Text = "Successfully deleted";
accountantCls.Conn.Close();
accountantCls.commitTrans();
accountantCls.Cmd.Parameters.Clear();
SqlDataSource1.DataBind();
GvCompany.DataBind();
}
catch (Exception ex)
{
accountantCls.rollBackTrans();
LabelErrorMessage.Text = ex.Message.ToString().Trim();
}
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
try
{
accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr();
accountantCls.Cmd.CommandType = CommandType.StoredProcedure;
accountantCls.Cmd.CommandText = "USP_Department_Edit";
accountantCls.Cmd.Parameters.Add("@DepartmentId", SqlDbType.Int).Value = ViewState["EditId"];
accountantCls.Cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = Session["UserCode"].ToString();
accountantCls.Cmd.Parameters.Add("@BranchId", SqlDbType.Int).Value = _BranchList.SelectedValue;
//accountantCls.Cmd.Parameters.Add("@CompanyId", SqlDbType.Int).Value = _CMPlist.SelectedValue; ;
accountantCls.Cmd.Parameters.Add("@DepartmentName", SqlDbType.NVarChar).Value = _DepartmentNameText.Text;
accountantCls.Cmd.Parameters.Add("@DepartmentDescription", SqlDbType.NVarChar).Value = _DIVDescriptionText.Text;
class1.ErrorNo = 0;
accountantCls.beginTrans();
int t = accountantCls.Cmd.ExecuteNonQuery();
BtnSave.Visible = true;
BtnUpdate.Visible = false;
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_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 BtnUpdate_Click(object sender, EventArgs e)
{
try
{
accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr();
accountantCls.Cmd.CommandType = CommandType.StoredProcedure;
accountantCls.Cmd.CommandText = "USP_Currency_Update";
accountantCls.Cmd.Parameters.Add("@CurrencyId", SqlDbType.Int).Value = ViewState["EditId"];
accountantCls.Cmd.Parameters.Add("@CurrencyName", SqlDbType.NVarChar).Value = _CurrencyText.Text;
accountantCls.Cmd.Parameters.Add("@CurrencySymbol", SqlDbType.NVarChar).Value = _CurrencySymbolText.Text;
accountantCls.Cmd.Parameters.Add("@IsLocal", SqlDbType.NVarChar).Value = CheckBox1.Checked;
class1.ErrorNo = 0;
accountantCls.beginTrans();
int t = accountantCls.Cmd.ExecuteNonQuery();
BtnSave.Visible = true;
BtnUpdate.Visible = false;
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 BtnChangeStatus_Click(object sender, EventArgs e)
{
try
{
accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr();
accountantCls.Cmd.CommandType = CommandType.StoredProcedure;
accountantCls.Cmd.CommandText = "USP_Department_ChangeStatus";
accountantCls.Cmd.Parameters.Add("@DepartmentId", SqlDbType.Int).Value = int.Parse(ViewState["EditId"].ToString());
if (Session["Status"].ToString() == "True")
{
accountantCls.Cmd.Parameters.Add("@Status", SqlDbType.Bit).Value = false;
LblStatus.Text = "Not Active";
LblStatus.ForeColor = System.Drawing.Color.Red;
Session["Status"] = false;
}
else
{
accountantCls.Cmd.Parameters.Add("@Status", SqlDbType.Bit).Value = true;
LblStatus.Text = "Active";
LblStatus.ForeColor = System.Drawing.Color.Green;
Session["Status"] = true;
}
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();
}
}
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 BtnUpdate_Click(object sender, EventArgs e)
{
try
{
accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr();
accountantCls.Cmd.CommandType = CommandType.StoredProcedure;
accountantCls.Cmd.CommandText = "USP_City_Edit";
accountantCls.Cmd.Parameters.Add("@CityId", SqlDbType.Int).Value = int.Parse(ViewState["EditId"].ToString());
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 = 0;
t = accountantCls.Cmd.ExecuteNonQuery();
accountantCls.Cmd.Parameters.Clear();
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();
BtnSave.Visible = true;
BtnUpdate.Visible = false;
}
catch (Exception ex)
{
accountantCls.rollBackTrans();
class1.ErrorDesc = ex.Message;
class1.ErrorNo = -1;
}
finally
{
SqlDataSource1.DataBind();
GvCompany.DataBind();
}
}
protected void GvCompany_RowDeleted(object sender, GridViewDeletedEventArgs e)
{
try
{
SqlDataSource1.DataBind();
GvCompany.DataBind();
}
catch (Exception ex)
{
LabelErrorMessage.Text = ex.Message.ToString().Trim();
}
}
void GV_Bind()
{
DataView dv;
dv = (DataView)SqlDataSourceUsersType.Select(DataSourceSelectArguments.Empty);
if (dv.Count > 0)
{
//dv.RowFilter = "UserRoleId='" + RadioButtonList1.SelectedValue + "'";
GvCompany.DataSource = dv;
GvCompany.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserCode"] == null)
{
Response.Redirect("Signin.aspx");
}
if (!this.IsPostBack)
{
if (Session["dir"].ToString() == "ltr")
{
//LabelCompanyName.Text = String.Format(global::Resources.ResourceMain.CompanyName);// GetLocalResourceObject("CompanyName").ToString();
}
else
{
//LabelCompanyName.Text = String.Format(global::Resources.ResourceMain_Ar.CompanyName);// GetLocalResourceObject("CompanyName").ToString();
}
////Session["FinYearID"] = "8";
ViewState["EditId"] = "0";
Session["AdminUserName"] = "******";
_LevelDDL.DataBind();
_LevelDDL.Items.Insert(0, new ListItem("Select All", "-1"));
DataView dv;
dv = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
if (dv.Count > 0)
{
GvCompany.DataSource = dv;
GvCompany.DataBind();
}
// string constr = ConfigurationManager.ConnectionStrings["FinanceConnStr"].ConnectionString;
// using (SqlConnection con = new SqlConnection(constr))
// {
// using (SqlCommand cmd = new SqlCommand("SELECT top 20 ChartId, COAChartCode,COAChartName,ChartLevel FROM tChartOfAccounts", con))
// {
// using (SqlDataAdapter sda = new SqlDataAdapter(cmd))
// {
// cmd.CommandType = CommandType.Text;
// DataTable dt = new DataTable();
// sda.Fill(dt);
// GvCompany.DataSource = dt;
// GvCompany.DataBind();
// }
// }
// }
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr();
accountantCls.Cmd.CommandType = CommandType.StoredProcedure;
try
{
accountantCls.Cmd.CommandText = "USP_Customizations_Save";
accountantCls.Cmd.Parameters.Clear();
accountantCls.Cmd.Parameters.Add("@CustomizationId", SqlDbType.Int).Value = Session["CustomizationId"].ToString();
accountantCls.Cmd.Parameters.Add("@CompanyId", SqlDbType.Int).Value = Session["CompanyID"].ToString();
accountantCls.Cmd.Parameters.Add("@BranchId", SqlDbType.Int).Value = Session["BranchId"].ToString();
accountantCls.Cmd.Parameters.Add("@DepartmentId", SqlDbType.Int).Value = Session["DepartmentId"].ToString();
accountantCls.Cmd.Parameters.Add("@DivisionId", SqlDbType.Int).Value = Session["DivisionId"].ToString();
accountantCls.Cmd.Parameters.Add("@CustomizationNameAr", SqlDbType.NVarChar).Value = TxtAccountNameGroupAr.Text;
accountantCls.Cmd.Parameters.Add("@CustomizationNameEn", SqlDbType.NVarChar).Value = TxtAccountNameGroupEn.Text;
accountantCls.Cmd.Parameters.Add("@COAChartCode", SqlDbType.NVarChar).Value = LabelAccountNumberGroup.Text.Trim();
accountantCls.Cmd.Parameters.Add("@OrderNo", SqlDbType.Int).Value = 0;
//accountantCls.Cmd.Parameters.Add("@CompanyId", SqlDbType.Int).Value = Session["CompanyID"].ToString();
//accountantCls.Cmd.Parameters.Add("@CompanyId", SqlDbType.Int).Value = Session["CompanyID"].ToString();
accountantCls.Cmd.Parameters.Add("@UserId", SqlDbType.Int).Value = Session["UserCode"].ToString();
class1.ErrorNo = 0;
accountantCls.beginTrans();
accountantCls.Cmd.ExecuteNonQuery();
//class1.RecordId = Convert.ToInt32(
if (class1.RecordId == 0)
{
class1.ErrorNo = -1;
//class1.ErrorDesc = BOL.Resources.Messages.BranchAlreadyExists;
//class1.ErrorFunction = " Finance.DAL.Customization.Save";
}
accountantCls.commitTrans();
LabelErrorMessage.Text = "Succeeded";
}
catch (Exception ex)
{
accountantCls.rollBackTrans();
LabelErrorMessage.Text = ex.Message.ToString();
class1.ErrorNo = -1;
//class1.ErrorFunction = " Finance.DAL.Customization.Save";
}
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_Bank_Edit";
accountantCls.Cmd.Parameters.Add("@BankId", SqlDbType.Int).Value = ViewState["EditId"];
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 = _LedgerIdText.Text;
accountantCls.Cmd.Parameters.Add("@AccountType", SqlDbType.NVarChar).Value = RadioButtonListAccountType.SelectedValue;
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();
}
}
//Midwest.Security.RijndaelEncryptionAlg.RijndaelEncryption RijndaelEncryption = new Midwest.Security.RijndaelEncryptionAlg.RijndaelEncryption();
protected void Page_Load(object sender, EventArgs e)
{
if (Session["UserCode"] == null)
{
Response.Redirect("Signin.aspx");
}
if (!IsPostBack)
{
if (Session["dir"].ToString().Trim() == "ltr")
{
LabelCompanyName.Text = String.Format(global::Resources.ResourceMain.CompanyName);// GetLocalResourceObject("CompanyName").ToString().Trim();
LabelCompanyName.Text = "Employee Name";
}
else
{
LabelCompanyName.Text = "اسم الموظف";
/*LabelCompanyName.Text = String.Format(global::Resources.ResourceMain_Ar.CompanyName);*/// GetLocalResourceObject("CompanyName").ToString().Trim();
}
try
{
SqlDataSource1.DataBind();
GvCompany.DataBind();
SqlDataSource2.DataBind();
_CustCityInfo.DataBind();
_CustCityInfo.Items.Insert(0, new ListItem("الرجاء اختيار", "0"));
//Session["CompanyId"] = "7";
Session["CustomerId"] = "0";
ViewState["EditId"] = "0";
Session["AccFrom"] = "E";
//Session["AdminUserName"] = "******";
//Bind();
}
catch (Exception ex)
{
accountantCls.rollBackTrans();
class1.ErrorDesc = ex.Message;
class1.ErrorNo = -1;
}
finally
{
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_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 _LevelDDL_SelectedIndexChanged(object sender, EventArgs e)
{
DataView dv;
dv = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
dv.RowFilter = "ChartLevel <='" + _LevelDDL.SelectedValue + "'";
if (dv.Count > 0)
{
GvCompany.DataSource = dv;
GvCompany.DataBind();
}
else
{
dv = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
GvCompany.DataSource = dv;
GvCompany.DataBind();
}
}
protected void BtnSearch_Click(object sender, EventArgs e)
{
DataView dv;
dv = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
dv.RowFilter = "COAChartCode ='" + _SearchText.Text + "' or COAChartName like '%" + _SearchText.Text + "%'";
if (dv.Count > 0)
{
GvCompany.DataSource = dv;
GvCompany.DataBind();
}
else
{
dv = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
GvCompany.DataSource = dv;
GvCompany.DataBind();
}
}
protected void GvCompany_PageIndexChanging(object sender, GridViewPageEventArgs e)
{
GvCompany.PageIndex = e.NewPageIndex;
DataView dv;
dv = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
dv.RowFilter = "ChartLevel <='" + _LevelDDL.SelectedValue + "'";
if (dv.Count > 0)
{
GvCompany.DataSource = dv;
GvCompany.DataBind();
}
else
{
dv = (DataView)SqlDataSource1.Select(DataSourceSelectArguments.Empty);
GvCompany.DataSource = dv;
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();
}
}
protected void BtnUpdate_Click(object sender, EventArgs e)
{
try
{
accountantCls.Cmd.Connection.ConnectionString = accountantCls.GetConnStr();
accountantCls.Cmd.CommandType = CommandType.StoredProcedure;
class1.ErrorNo = 0;
}
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)
{
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();
}
}
protected void BtnSave_Click(object sender, EventArgs e)
{
//Session["again"] = "1";
DataTable tbl = new DataTable();
TextBoxLength.Text = "";
//Session.Remove("again");
int g = 0;
g = int.Parse(_TextBoxCount.Text);
for (int i = 1; i <= g; i++)
{
int index = pnlTextBoxes.Controls.OfType <TextBox>().ToList().Count + 1;
this.CreateTextBox("LblDynamic" + index, "TxtDynamic" + index, index);
}
SqlDataSource1.DataBind();
GvCompany.DataBind();
BtnUpdate.Visible = true;
BtnSave.Visible = false;
int h = 0;
h = int.Parse(_TextBoxCount.Text);
DataColumn tc = new DataColumn("TextName");
tbl.Columns.Add(tc);
for (int p = 0; p < h; p++)
{
DataRow ro = tbl.NewRow();
//ro["TextName"] = Session["SID"].ToString();
////TableCell tc = new TableCell();
TextBox TxtDynamic = new TextBox();
TxtDynamic.ID = "TxtDynamic" + (p + 1);
//_checkbox.Text = "Checkbox" + i;
ro["TextName"] = TxtDynamic.ID;
tbl.Rows.Add(ro);
}
Session["Tbl"] = tbl;
}
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)
{
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 BtnAdd_Click(object sender, EventArgs e)
{
DataColumn c1 = new DataColumn("ManualVoucherNo");
DataColumn c2 = new DataColumn("VoucherDate");
DataColumn c3 = new DataColumn("Debit");
DataColumn c4 = new DataColumn("Credit");
DataColumn c5 = new DataColumn("ForeignAmount");
DataColumn c6 = new DataColumn("ExchangeRate");
DataColumn c7 = new DataColumn("Description");
DataColumn c8 = new DataColumn("Ledger");
//DataColumn c9 = new DataColumn("Credit");
//DataColumn c10 = new DataColumn("ForeignAmount");
tab.Columns.Add(c1);
tab.Columns.Add(c2);
tab.Columns.Add(c3);
tab.Columns.Add(c4);
tab.Columns.Add(c5);
tab.Columns.Add(c6);
tab.Columns.Add(c7);
tab.Columns.Add(c8);
if (Session["cart"] == null)
{
string d = "0";
string c = "0";
if (_ddReceiptType.SelectedValue == "0")
{
return;
}
else if (_ddReceiptType.SelectedValue == "1")
{
d = _TxtAmount.Text;
}
else if (_ddReceiptType.SelectedValue == "2")
{
c = _TxtAmount.Text;
}
DataRow row = tab.NewRow();
row["ManualVoucherNo"] = _VoucherNoText.Text;
row["VoucherDate"] = _VoucherDateText.Text;
row["Debit"] = d;
row["Credit"] = c;
row["ForeignAmount"] = _TxtCurrency.Text;
row["ExchangeRate"] = _TxtValue.Text;
row["Description"] = _TxtDescription.Text;
row["Ledger"] = _ddPayedTo.SelectedValue;
tab.Rows.Add(row);
}
else
{
tab = (DataTable)Session["cart"];
string d = "0";
string c = "0";
if (_ddReceiptType.SelectedValue == "0")
{
return;
}
else if (_ddReceiptType.SelectedValue == "1")
{
d = _TxtAmount.Text;
}
else if (_ddReceiptType.SelectedValue == "2")
{
c = _TxtAmount.Text;
}
DataRow row = tab.NewRow();
row["ManualVoucherNo"] = _VoucherNoText.Text;
row["VoucherDate"] = _VoucherDateText.Text;
row["Debit"] = d;
row["Credit"] = c;
row["ForeignAmount"] = _TxtCurrency.Text;
row["ExchangeRate"] = _TxtValue.Text;
row["Description"] = _TxtDescription.Text;
row["Ledger"] = _ddPayedTo.SelectedValue;
tab.Rows.Add(row);
}
Session["cart"] = tab;
GvCompany.DataSource = tab;
GvCompany.DataBind();
Bind();
}
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();
}
}
