public void Save(string connectionString, CoaHead objCoaHead)
{
try
{
var myConnection = new SqlConnection(connectionString);
var myCommand = myConnection.CreateCommand();
myConnection.Open();
myCommand.CommandText = "exec [ACT_accCOAHeadSetup] " +
+objCoaHead.AccountNo + "," +
+objCoaHead.ParentAccNo + "," +
+objCoaHead.AccountTypeId + "," +
"'" + objCoaHead.AccountName + "'," +
+objCoaHead.SeqNo + "," +
+objCoaHead.TierNo + "," +
"'" + objCoaHead.AccountDescription + "'," +
+objCoaHead.SerialNo + "," +
+objCoaHead.CompanyID + "," +
+objCoaHead.BranchID + "," +
+objCoaHead.IsBudgetRelated + ",'" +
objCoaHead.AnalysisRequired + "'," +
"'" + objCoaHead.EntryUserId + "'";
myCommand.CommandTimeout = 600;
myCommand.ExecuteNonQuery();
myConnection.Close();
if (objCoaHead.AnalysisRequired == "Y")
{
foreach (DataRow rowNo in objCoaHead.DtSubledgerInformation.Rows)
{
objCoaHead.SubledgerTypeID = rowNo.ItemArray[0].ToString();
objCoaHead.SubLedgerID = rowNo.ItemArray[1].ToString();
var storedProcedureComandTest = "exec [ACT_accAccNoWiseSubHeadSetup] " +
objCoaHead.CompanyID + "," +
objCoaHead.BranchID + "," +
objCoaHead.AccountNo + ",'" +
objCoaHead.SubledgerTypeID + "','" +
objCoaHead.SubLedgerID + "','" +
objCoaHead.EntryUserId + "'";
clsDataManipulation.StoredProcedureExecuteNonQuery(connectionString, storedProcedureComandTest);
}
}
}
catch (Exception msgException)
{
throw msgException;
}
}
private void UpdateCoaHead()
{
try
{
int parentAccountNumber = Convert.ToInt32(ddlParentAccountNo.SelectedValue == "-1" ? null : ddlParentAccountNo.SelectedValue);
var objCoaHead = new CoaHead
{
AccountName = txtAccountHead.Text,
AccountTypeId = Convert.ToInt32(ddlAccountType.SelectedValue),
AccountDescription = txtAccountDescription.Text,
AccountNo = parentAccountNumber,
EntryUserId = Session["entryUserCode"].ToString(),
CompanyID = Convert.ToInt32(Session["company"].ToString()),
BranchID = Convert.ToInt32(Session["branch"].ToString()),
IsBudgetRelated = CheckBoxIsBudgetRelated.Checked == true ? 1 : 0,
AnalysisRequired = CheckBoxAnalysisRequired.Checked == true ? "Y" : "N"
};
objCoaHead.DtSubledgerInformation = new DataTable();
DataRow dr;
objCoaHead.DtSubledgerInformation.Columns.Add(new DataColumn("SubledgerTypeID", typeof(String)));
objCoaHead.DtSubledgerInformation.Columns.Add(new DataColumn("SubLedgerID", typeof(String)));
var objCoaHeadController = new CoaHeadController();
for (int subLedgerCount = 1; subLedgerCount < 6; subLedgerCount++)
{
string subLedger = null;
if (subLedgerCount == 1)
{
subLedger = txtSubledgerTypeID.Text == string.Empty ? null : txtSubledgerTypeID.Text;
}
else if (subLedgerCount == 2)
{
subLedger = txtSubledgerTypeID0.Text == string.Empty ? null : txtSubledgerTypeID0.Text;
}
else if (subLedgerCount == 3)
{
subLedger = txtSubledgerTypeID1.Text == string.Empty ? null : txtSubledgerTypeID1.Text;
}
else if (subLedgerCount == 4)
{
subLedger = txtSubledgerTypeID2.Text == string.Empty ? null : txtSubledgerTypeID2.Text;
}
else
{
subLedger = txtSubledgerTypeID3.Text == string.Empty ? null : txtSubledgerTypeID3.Text;
}
if (subLedger != null)
{
var dtCheckSubLedgerInfo = objCoaHeadController.GetSubLedgerInformation(_connectionString, subLedger);
foreach (DataRow rowNo in dtCheckSubLedgerInfo.Rows)
{
dr = objCoaHead.DtSubledgerInformation.NewRow();
dr[0] = rowNo.ItemArray[0].ToString();
dr[1] = rowNo.ItemArray[1].ToString();
objCoaHead.DtSubledgerInformation.Rows.Add(dr);
}
}
}
objCoaHeadController.Update(_connectionString, objCoaHead);
}
catch (Exception msgException)
{
throw msgException;
}
}
