internal DataTable LoadExportCategory(AccountHeadModel objAHModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPMasters";
ClsCon.cmd.Parameters.AddWithValue("@DataInd", objAHModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objAHModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objAHModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objAHModel.YrCD);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtAccountHead = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtAccountHead);
dtAccountHead.TableName = "success";
}
catch (Exception)
{
dtAccountHead = new DataTable();
dtAccountHead.TableName = "error";
return(dtAccountHead);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtAccountHead);
}
private DataTable GetAll()
{
DataTable dt = new DataTable();
dt.Columns.Add("AccountHeadId", typeof(string));
dt.Columns.Add("AccountGroupName", typeof(string));
dt.Columns.Add("BankName", typeof(string));
dt.Columns.Add("BankIFSCCode", typeof(string));
dt.Columns.Add("BankAccountNo", typeof(string));
dt.Columns.Add("BankBranchName", typeof(string));
dt.Columns.Add("BankAccountHolderName", typeof(string));
AccountHeadModel bankDetailsModel = new AccountHeadModel();
bankDetailsModel.Action = "fetch_bankaccounts_bankcc_bankod";
DataSet ds = bankDetailsModel.AccountHeadOperation();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
dt.Rows.Add(
ds.Tables[0].Rows[i]["AccountHeadId"].ToString(),
ds.Tables[0].Rows[i]["AccountGroupName"].ToString(),
ds.Tables[0].Rows[i]["BankName"].ToString(),
ds.Tables[0].Rows[i]["BankIFSCCode"].ToString(),
ds.Tables[0].Rows[i]["BankAccountNo"].ToString(),
ds.Tables[0].Rows[i]["BankBranchName"].ToString(),
ds.Tables[0].Rows[i]["BankAccountHolderName"].ToString()
);
}
return(dt);
}
public ActionResult AddEditSubGroupAccountHead(AccountHeadModel accountHeadModel, FormCollection form)
{
ResultDto result = new ResultDto();
//if (ModelState.IsValid)
//{
accountHeadModel.UserID = 1;
accountHeadModel.StatusID = 1;
accountHeadModel.IsFederation = false;
accountHeadModel.AHID = accountHeadModel.EditAHID > 0 ? accountHeadModel.EditAHID : accountHeadModel.AHID;
accountHeadModel.AHCode = !string.IsNullOrEmpty(accountHeadModel.SubGroupAHCode)
? accountHeadModel.SubGroupAHCode
: accountHeadModel.AHCode;
accountHeadModel.AHName = !string.IsNullOrEmpty(accountHeadModel.SubGroupAHName)
? accountHeadModel.SubGroupAHName
: accountHeadModel.AHName;
AccountHeadDto accountHeadDto = AutoMapperEntityConfiguration.Cast <AccountHeadDto>(accountHeadModel);
if (accountHeadModel.AHID > 0)
{
result = _accountHeadService.Update(accountHeadDto);
}
else
{
result = _accountHeadService.Insert(accountHeadDto);
}
//}
TempData["SuccessMsg"] = result;
return(RedirectToAction("AccountTree"));
}
//
// GET: /Federation/AccountTree/
public ActionResult AccountTree()
{
List <AccountHeadDto> lstAccountHeadDtos = _accountHeadService.GetAll(false);
lstAccountHeadDtos = lstAccountHeadDtos.FindAll(l => l.StatusID != 3);
var lstBankMasterDto = new AccountHeadService().GetOrganizationBanks();
var ahlevel1 = lstAccountHeadDtos.FindAll(l => l.ParentAHID == 0);
var assetparent = ahlevel1.Find(l => l.AHCode.ToUpper() == "ASSETS");
var ahlevl2 = lstAccountHeadDtos.Find(l => l.ParentAHID == assetparent.AHID && l.AHCode.ToUpper() == "CLOSING BALANCES");
var ahlevl3 = lstAccountHeadDtos.Find(l => l.ParentAHID == ahlevl2.AHID && l.AHCode.ToUpper() == "CASH AND BANK");
var ahlevel4 = lstAccountHeadDtos.Find(l => l.ParentAHID == ahlevl3.AHID && l.AHCode.ToUpper() == "BANK ACCOUNTS");
var lstBankAccountHeads = lstAccountHeadDtos.FindAll(l => l.ParentAHID == ahlevel4.AHID);
foreach (var bank in lstBankAccountHeads)
{
if (!lstBankMasterDto.Exists(l => l == bank.AHID))
{
lstAccountHeadDtos.Remove(bank);
}
}
ViewBag.AccountHeads = lstAccountHeadDtos;
AccountHeadDtos = lstAccountHeadDtos;
AccountHeadModel accountHeadModel = new AccountHeadModel();
return(View(accountHeadModel));
}
public void Auto()
{
AccountHeadModel accountHeadModel = new AccountHeadModel();
accountHeadModel.Action = "Search";
accountHeadModel.AccountHeadName = txt_fromAccnt.Text;
accountHeadModel.AccountHeadName = txt_toAccnt.Text;
DataSet dt = accountHeadModel.AccountHeadOperation();
if (dt.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dt.Tables[0].Rows.Count; i++)
{
col.Add(dt.Tables[0].Rows[i]["AccountHeadName"].ToString());
}
}
txt_fromAccnt.AutoCompleteMode = AutoCompleteMode.Suggest;
txt_fromAccnt.AutoCompleteSource = AutoCompleteSource.CustomSource;
txt_fromAccnt.AutoCompleteCustomSource = col;
txt_toAccnt.AutoCompleteMode = AutoCompleteMode.Suggest;
txt_toAccnt.AutoCompleteSource = AutoCompleteSource.CustomSource;
txt_toAccnt.AutoCompleteCustomSource = col;
}
public DataSet ClientInformation(AccountHeadModel objAHModel)
{
DataSet dsAccountHead = new DataSet();
objAHModel.Ind = 15;
DataTable dtClientState = objAHDA.LoadState(objAHModel);
dtClientState.TableName = "State";
dsAccountHead.Tables.Add(dtClientState);
objAHModel.Ind = 16;
DataTable dtGroupName = objAHDA.LoadGroupName(objAHModel);
dtGroupName.TableName = "GroupName";
dsAccountHead.Tables.Add(dtGroupName);
objAHModel.Ind = 19;
DataTable dtExportCat = objAHDA.LoadExportCategory(objAHModel);
dtExportCat.TableName = "ExportCategory";
dsAccountHead.Tables.Add(dtExportCat);
objAHModel.Ind = 2;
DataTable dtUpdAccountHead = objAHDA.LoadAccountHead(objAHModel);
dtUpdAccountHead.TableName = "AccountHead";
dsAccountHead.Tables.Add(dtUpdAccountHead);
return(dsAccountHead);
}
public PartyEntry(int AccountHeadId)
{
InitializeComponent();
Partyid = AccountHeadId;
AccountHeadModel table = new AccountHeadModel();
table.Action = "fetchbyid";
table.AccountHeadId = Partyid;
DataSet ds = table.AccountHeadOperation();
if (ds.Tables[0].Rows.Count > 0)
{
txt_PartyName.Text = ds.Tables[0].Rows[0]["Name"].ToString();
txt_Address.Text = ds.Tables[0].Rows[0]["Address"].ToString();
txt_PhoneNo.Text = ds.Tables[0].Rows[0]["ContactNo1"].ToString();
txt_EmailId.Text = ds.Tables[0].Rows[0]["Emailid"].ToString();
txt_Gstinno.Text = ds.Tables[0].Rows[0]["GstInNo"].ToString();
if (ds.Tables[0].Rows[0]["AccountGroupId"].ToString() == "21")
{
rb_PurchaseParty.Checked = true;
}
else
{
rb_SaleParty.Checked = true;
}
btn_Save.Text = "Update";
btn_SaveAddNew.Enabled = false;
lbl_AddParty.Text = "Update Party";
LoadDetails();
}
}
//public ActionResult BindDropDowns(int parentAhid, int accountHeadLevel, string Id,bool isFederation)
//{
// StringBuilder sbDropdownOptions = new StringBuilder();
// #region ddlEditSubGroup
// if (Id == "SubGroup")
// {
// StringBuilder sbAccountHeadOptions = new StringBuilder();
// StringBuilder sbSubGroupOptions = new StringBuilder();
// if (accountHeadLevel == 4)
// {
// var dropDownAccountHeadOptions = (from item in AccountHeadDtos
// where item.ParentAHID == parentAhid && item.IsFederation && item.AHLevel == 4
// select new { AHCode = item.AHID + "_" + item.AHCode, AhName = item.AHName }
// );
// foreach (var dropDownOption in dropDownAccountHeadOptions)
// {
// sbSubGroupOptions.Append("<option value='" + dropDownOption.AHCode + "'>" + dropDownOption.AhName + "</option>");
// }
// }
// else
// {
// var dropDownSubGroupOptions = (from item in AccountHeadDtos
// where item.ParentAHID == parentAhid && item.IsFederation && item.AHLevel == 4
// select new { ParentAhid = item.AHID, AhName = item.AHName }
// );
// foreach (var dropDownOption in dropDownSubGroupOptions)
// {
// sbSubGroupOptions.Append("<option value='" + dropDownOption.ParentAhid + "'>" + dropDownOption.AhName + "</option>");
// }
// }
// if (accountHeadLevel == 5)
// {
// var dropDownAccountHeadOptions = (from item in AccountHeadDtos
// where item.ParentAHID == parentAhid && item.IsFederation && item.AHLevel == 5
// select new { AHCode = item.AHID + "_" + item.AHCode, AhName = item.AHName }
// );
// foreach (var dropDownOption in dropDownAccountHeadOptions)
// {
// sbAccountHeadOptions.Append("<option value='" + dropDownOption.AHCode + "'>" + dropDownOption.AhName + "</option>");
// }
// }
// return Json(new { AccountHeadOptions = sbAccountHeadOptions != null ? sbAccountHeadOptions.ToString() : "", SubGroupOptions = sbSubGroupOptions != null ? sbSubGroupOptions.ToString() : "" });
// }
// #endregion ddlEditSubGroup
// else if (Id == "SearchAccountHead")
// {
// var dropDownAccountHeadOptions = (from item in AccountHeadDtos
// where item.ParentAHID == parentAhid && item.IsFederation && item.AHLevel == 5
// select new { AHCode = item.AHID + "_" + item.AHCode, AhName = item.AHName }
// );
// foreach (var dropDownOption in dropDownAccountHeadOptions)
// {
// sbDropdownOptions.Append("<option value='" + dropDownOption.AHCode + "'>" + dropDownOption.AhName + "</option>");
// }
// return Json(new { DropDownOptions = sbDropdownOptions.ToString() });
// }
// else if (Id == "MoveSubGroupAccountHead")
// {
// var subGroupFields = (from item in AccountHeadDtos
// where item.ParentAHID == parentAhid && item.IsFederation && item.AHLevel == 4
// select new { ParentAhid = item.AHID, AhName = item.AHName }
// );
// var accountHeadFields = (from item in AccountHeadDtos
// where item.ParentAHID == parentAhid && item.IsFederation && item.AHLevel == 5
// select new { ParentAhid = item.AHID, AhName = item.AHName }
// );
// return Json(new { SubGroupFields = subGroupFields, AccountHeadFields = accountHeadFields });
// }
// else if (Id == "ViewBalanceAccountHead")
// {
// var dropDownOptions = (from item in AccountHeadDtos
// where item.IsFederation && item.AHLevel == accountHeadLevel
// select new { ParentAhid = item.AHID, AhName = item.AHName }
// );
// foreach (var dropDownOption in dropDownOptions)
// {
// sbDropdownOptions.Append("<option value='" + dropDownOption.ParentAhid + "'>" + dropDownOption.AhName + "</option>");
// }
// return Json(new { DropDownOptions = sbDropdownOptions.ToString() });
// }
// else
// {
// var dropDownOptions = (from item in AccountHeadDtos
// where item.ParentAHID == parentAhid && item.IsFederation
// select new { ParentAhid = item.AHID, AhName = item.AHName }
// );
// foreach (var dropDownOption in dropDownOptions)
// {
// sbDropdownOptions.Append("<option value='" + dropDownOption.ParentAhid + "'>" + dropDownOption.AhName + "</option>");
// }
// return Json(new { DropDownOptions = sbDropdownOptions.ToString() });
// }
//}
public ActionResult MoveSubGroupOrAccountHead(AccountHeadModel accountHeadModel)
{
accountHeadModel.UserID = 1;
accountHeadModel.StatusID = 1;
accountHeadModel.ParentAHID = accountHeadModel.ParentMoveAHID;
AccountHeadDto accountHeadDto = AutoMapperEntityConfiguration.Cast <AccountHeadDto>(accountHeadModel);
_accountHeadService.MoveAccountHead(accountHeadDto);
return(RedirectToAction("GroupAccountTree"));
}
private bool Save()
{
AccountHeadModel bankDetailsModel = new AccountHeadModel();
if (btn_Save.Text == "Update")
{
bankDetailsModel.Action = "update";
bankDetailsModel.AccountHeadId = PAccountHeadId;
}
else
{
bankDetailsModel.Action = "insert";
}
bankDetailsModel.BankName = txt_BankName.Text;
if (ddl_accountGrpId.SelectedItem.ToString() == "Bank Account")
{
bankDetailsModel.AccountGroupId = 1;
}
else if (ddl_accountGrpId.SelectedItem.ToString() == "Bank CC A/C")
{
bankDetailsModel.AccountGroupId = 2;
}
else if (ddl_accountGrpId.SelectedItem.ToString() == "Bank OD A/C")
{
bankDetailsModel.AccountGroupId = 3;
}
bankDetailsModel.AccountHeadName = txt_accountHeadName.Text;
bankDetailsModel.BankName = txt_BankName.Text;
bankDetailsModel.BankIFSCCode = txt_bankIFSCcode.Text;
bankDetailsModel.BankBranchName = txt_bankBranchName.Text;
bankDetailsModel.BankAccountNo = txt_bankAccountNo.Text;
bankDetailsModel.BankAccountHolderName = txt_accountHolderName.Text;
DataSet ds = bankDetailsModel.AccountHeadOperation();
if (ds.Tables[0].Rows[0].ItemArray[0].ToString() == "Record Submitted Successfully")
{
MessageBox.Show("Record Submitted Successfully", "MINIFY", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(true);
}
else if (ds.Tables[0].Rows[0].ItemArray[0].ToString() == "Updated Successfully")
{
MessageBox.Show("Updated Successfully", "MINIFY", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(true);
}
else
{
MessageBox.Show("Please try again Later", "MINIFY", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
public ActionResult MoveSubGroupOrAccountHead(AccountHeadModel accountHeadModel)
{
ResultDto result = new ResultDto();
accountHeadModel.UserID = 1;
accountHeadModel.StatusID = 1;
accountHeadModel.ParentAHID = accountHeadModel.ParentMoveAHID;
AccountHeadDto accountHeadDto = AutoMapperEntityConfiguration.Cast <AccountHeadDto>(accountHeadModel);
result = _accountHeadService.MoveAccountHead(accountHeadDto);
TempData["SuccessMsg"] = result;
return(RedirectToAction("AccountTree"));
}
internal DataTable SaveAccountHead(AccountHeadModel objAHModel)
{
try
{
ClsCon.cmd = new SqlCommand();
ClsCon.cmd.CommandType = CommandType.StoredProcedure;
ClsCon.cmd.CommandText = "SPAccountHead";
ClsCon.cmd.Parameters.AddWithValue("@Ind", objAHModel.Ind);
ClsCon.cmd.Parameters.AddWithValue("@OrgID", objAHModel.OrgID);
ClsCon.cmd.Parameters.AddWithValue("@BrID", objAHModel.BrID);
ClsCon.cmd.Parameters.AddWithValue("@YrCD", objAHModel.YrCD);
ClsCon.cmd.Parameters.AddWithValue("@User", objAHModel.User);
ClsCon.cmd.Parameters.AddWithValue("@EntryType", objAHModel.EntryType);
ClsCon.cmd.Parameters.AddWithValue("@IP", objAHModel.IP);
ClsCon.cmd.Parameters.AddWithValue("@CompositionOpted", objAHModel.CompositionOpted);
ClsCon.cmd.Parameters.AddWithValue("@ReffPartyCode", objAHModel.ReffPartyCode);
ClsCon.cmd.Parameters.AddWithValue("@IsSubDealer", objAHModel.IsSubDealer);
ClsCon.cmd.Parameters.AddWithValue("@DiscountRate", objAHModel.DiscountRate);
ClsCon.cmd.Parameters.AddWithValue("@BrokerageRate", objAHModel.BrokerageRate);
ClsCon.cmd.Parameters.AddWithValue("@TblAccount", objAHModel.DtAccount);
ClsCon.cmd.Parameters.AddWithValue("@TblAccGSTIN", objAHModel.DtAccGSTIN);
ClsCon.cmd.Parameters.AddWithValue("@TblAccPOS", objAHModel.DtAccPOS);
ClsCon.cmd.Parameters.AddWithValue("@TblAccTerms", objAHModel.TblAccTerms);
ClsCon.cmd.Parameters.AddWithValue("@TaxCalcForSEZParty", objAHModel.TaxCalcForSEZParty);
ClsCon.cmd.Parameters.AddWithValue("@AccountHeadHindi", objAHModel.AccountHeadHindi);
con = ClsCon.SqlConn();
ClsCon.cmd.Connection = con;
dtAccountHead = new DataTable();
ClsCon.da = new SqlDataAdapter(ClsCon.cmd);
ClsCon.da.Fill(dtAccountHead);
dtAccountHead.TableName = "success";
}
catch (Exception)
{
dtAccountHead = new DataTable();
dtAccountHead.TableName = "error";
return(dtAccountHead);
}
finally
{
con.Close();
con.Dispose();
ClsCon.da.Dispose();
ClsCon.cmd.Dispose();
}
return(dtAccountHead);
}
//
// GET: /Federation/AccountTree/
public ActionResult AccountTree()
{
List <AccountHeadDto> lstAccountHeadDtos = _accountHeadService.GetAll(true);
lstAccountHeadDtos = lstAccountHeadDtos.FindAll(l => l.StatusID != 3);
var lstBankMasterDto = new AccountHeadService().GetOrganizationBanks();
var ahlevel1 = lstAccountHeadDtos.FindAll(l => l.ParentAHID == 0);
var assetparent = ahlevel1.Find(l => l.AHCode.ToUpper() == "ASSETS");
var ahlevl2 = lstAccountHeadDtos.Find(l => l.ParentAHID == assetparent.AHID && l.AHCode.ToUpper() == "CLOSING BALANCES");
var ahlevl3 = lstAccountHeadDtos.Find(l => l.ParentAHID == ahlevl2.AHID && l.AHCode.ToUpper() == "CASH AND BANK");
var ahlevel4 = lstAccountHeadDtos.Find(l => l.ParentAHID == ahlevl3.AHID && l.AHCode.ToUpper() == "BANK ACCOUNTS");
var lstBankAccountHeads = lstAccountHeadDtos.FindAll(l => l.ParentAHID == ahlevel4.AHID);
foreach (var bank in lstBankAccountHeads)
{
if (!lstBankMasterDto.Exists(l => l == bank.AHID))
{
lstAccountHeadDtos.Remove(bank);
}
}
//var lstBankAHIDS = new AccountHeadService().GetBankAHIDs();
//foreach (int ahid in lstBankAHIDS)
//{
// lstAccountHeadDtos.Remove(lstAccountHeadDtos.Find(l => l.AHID == ahid));
//}
//ReferenceValueService _referenceValueService = new ReferenceValueService();
//var lstAHTypes = _referenceValueService.GetByRefMasterCode("AHTYPE");
//var assettype = lstAHTypes.Find(l => l.RefCode.ToUpper() == "ASSETS");
//var bankParentAH = lstAccountHeadDtos.Find(l => l.AHLevel == 4 && l.AHCode.ToUpper() == "BANK ACCOUNTS" && l.AHType == assettype.RefID && l.IsFederation);
// lstAccountHeadDtos.RemoveAll(l => l.ParentAHID == bankParentAH.AHID);
//end filtering the bankaccounts
//lstAccountHeadDtos.FindAll(l => l.AHLevel > 3).ForEach(l => l.AHName = l.AHName + " - " + l.AHCode);
ViewBag.AccountHeads = lstAccountHeadDtos;
AccountHeadDtos = lstAccountHeadDtos;
AccountHeadModel accountHeadModel = new AccountHeadModel();
ViewBag.IsFederation = true;
return(View(accountHeadModel));
}
public ActionResult GroupAccountTree()
{
//List<AccountHeadDto> lstAccountHeadDtos = _accountHeadService.GetAll(false);
//var lstBankAHIDS = new AccountHeadService().GetBankAHIDs();
//foreach (int ahid in lstBankAHIDS)
//{
// lstAccountHeadDtos.Remove(lstAccountHeadDtos.Find(l => l.AHID == ahid));
//}
List <AccountHeadDto> lstAccountHeadDtos = _accountHeadService.GetGroupAccountTree(GroupInfo.GroupID);
ViewBag.AccountHeads = lstAccountHeadDtos;
AccountHeadDtos = lstAccountHeadDtos;
ViewBag.IsFederation = false;
AccountHeadModel accountHeadModel = new AccountHeadModel();
return(View(accountHeadModel));
}
public void Auto()
{
AccountHeadModel accountHeadModel = new AccountHeadModel();
accountHeadModel.Action = "Search";
accountHeadModel.AccountHeadName = txt_accountHeadName.Text;
DataSet dt = accountHeadModel.AccountHeadOperation();
if (dt.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dt.Tables[0].Rows.Count; i++)
{
col.Add(dt.Tables[0].Rows[i]["AccountHeadName"].ToString());
}
}
//else
//{
// MessageBox.Show("Name not Found.");
//}
txt_accountHeadName.AutoCompleteMode = AutoCompleteMode.Suggest;
txt_accountHeadName.AutoCompleteSource = AutoCompleteSource.CustomSource;
txt_accountHeadName.AutoCompleteCustomSource = col;
//fetch item name
ItemMasterModel item = new ItemMasterModel();
item.Action = "Search";
item.ItemName = txt_itemName.Text;
DataSet dt1 = item.ItemOperation();
if (dt1.Tables[0].Rows.Count > 0)
{
for (int i = 0; i < dt1.Tables[0].Rows.Count; i++)
{
col1.Add(dt1.Tables[0].Rows[i]["ItemName"].ToString());
}
}
else
{
MessageBox.Show("Name not Found.");
}
txt_itemName.AutoCompleteMode = AutoCompleteMode.Suggest;
txt_itemName.AutoCompleteSource = AutoCompleteSource.CustomSource;
txt_itemName.AutoCompleteCustomSource = col1;
}
public ActionResult AddEditSubGroupAccountHead(AccountHeadModel accountHeadModel, FormCollection form)
{
ResultDto result = new ResultDto();
//if (ModelState.IsValid)
//{
bool isFederation = string.IsNullOrEmpty(form.Get("isFederation")) ? true : Convert.ToBoolean(form.Get("isFederation"));
accountHeadModel.UserID = 1;
accountHeadModel.StatusID = 1;
accountHeadModel.IsFederation = isFederation;
accountHeadModel.AHID = accountHeadModel.EditAHID > 0 ? accountHeadModel.EditAHID : accountHeadModel.AHID;
accountHeadModel.AHCode = !string.IsNullOrEmpty(accountHeadModel.SubGroupAHCode)
? accountHeadModel.SubGroupAHCode
: accountHeadModel.AHCode;
accountHeadModel.AHName = !string.IsNullOrEmpty(accountHeadModel.SubGroupAHName)
? accountHeadModel.SubGroupAHName
: accountHeadModel.AHName;
accountHeadModel.TE_AHName = !string.IsNullOrEmpty(accountHeadModel.SubGroupTEAHName)
? accountHeadModel.SubGroupTEAHName
: accountHeadModel.TE_AHName;
AccountHeadDto accountHeadDto = AutoMapperEntityConfiguration.Cast <AccountHeadDto>(accountHeadModel);
if (accountHeadModel.AHID > 0)
{
result = _accountHeadService.Update(accountHeadDto);
}
else
{
result = _accountHeadService.Insert(accountHeadDto);
}
//}
ViewBag.IsFederation = isFederation;
TempData["SuccessMsg"] = result;
if (isFederation)
{
return(RedirectToAction("AccountTree"));
}
else
{
return(RedirectToAction("GroupAccountTree"));
}
}
public ActionResult GroupAccountTree()
{
List <AccountHeadDto> lstAccountHeadDtos = _accountHeadService.GetAll(false);
var lstBankAHIDS = new AccountHeadService().GetBankAHIDs();
foreach (int ahid in lstBankAHIDS)
{
lstAccountHeadDtos.Remove(lstAccountHeadDtos.Find(l => l.AHID == ahid));
}
List <AccountHeadDto> lstExtraHeads = new List <AccountHeadDto>();
foreach (var obj in lstAccountHeadDtos)
{
if (obj.AHName.Trim() == "1" || obj.AHName.Trim() == "2")
{
lstExtraHeads.Add(obj);
}
}
foreach (var obj in lstExtraHeads)
{
lstAccountHeadDtos.Remove(obj);
}
//for(int i = 0; i < lstAccountHeadDtos.Count(); i++)
//{
// if (lstAccountHeadDtos[i].AHName == "1" || lstAccountHeadDtos[i].AHName == "2")
// lstAccountHeadDtos.RemoveAt(i);
//}
//lstAccountHeadDtos.FindAll(l => l.AHLevel > 3).ForEach(l => l.AHName = l.AHName + " - " + l.AHCode);
ViewBag.AccountHeads = lstAccountHeadDtos;
AccountHeadDtos = lstAccountHeadDtos;
AccountHeadModel accountHeadModel = new AccountHeadModel();
ViewBag.IsFederation = false;
return(View("AccountTree", accountHeadModel));
}
public ActionResult MoveSubGroupOrAccountHead(AccountHeadModel accountHeadModel)
{
bool isFederation = string.IsNullOrEmpty(Request.Form.Get("isFederation")) ? true : Convert.ToBoolean(Request.Form.Get("isFederation"));
ResultDto result = new ResultDto();
accountHeadModel.UserID = 1;
accountHeadModel.StatusID = 1;
accountHeadModel.ParentAHID = accountHeadModel.ParentMoveAHID;
AccountHeadDto accountHeadDto = AutoMapperEntityConfiguration.Cast <AccountHeadDto>(accountHeadModel);
result = _accountHeadService.MoveAccountHead(accountHeadDto);
ViewBag.IsFederation = isFederation;
TempData["SuccessMsg"] = result;
if (isFederation)
{
return(RedirectToAction("AccountTree"));
}
else
{
return(RedirectToAction("GroupAccountTree"));
}
}
private DataTable GetAll()
{
DataTable dt = new DataTable();
dt.Columns.Add("AccountHeadId", typeof(string));
dt.Columns.Add("accountheadname", typeof(string));
dt.Columns.Add("AccountGroup", typeof(string));
dt.Columns.Add("partyname", typeof(string));
dt.Columns.Add("gstinno", typeof(string));
dt.Columns.Add("state", typeof(string));
dt.Columns.Add("phoneno", typeof(string));
dt.Columns.Add("emilid", typeof(string));
dt.Columns.Add("address", typeof(string));
dt.Columns.Add("openingbalance", typeof(string));
dt.Columns.Add("openingbalancetype", typeof(string));
AccountHeadModel account = new AccountHeadModel();
account.Action = "fetch";
DataSet ds = account.AccountHeadOperation();
for (int i = 0; i < ds.Tables[0].Rows.Count; i++)
{
dt.Rows.Add(
ds.Tables[0].Rows[i]["AccountHeadId"].ToString(),
ds.Tables[0].Rows[i]["AccountHeadName"].ToString(),
ds.Tables[0].Rows[i]["AccountGroupName"].ToString(),
ds.Tables[0].Rows[i]["Name"].ToString(),
ds.Tables[0].Rows[i]["GstinNo"].ToString(),
ds.Tables[0].Rows[i]["State"].ToString(),
ds.Tables[0].Rows[i]["ContactNo1"].ToString(),
ds.Tables[0].Rows[i]["EmailId"].ToString(),
ds.Tables[0].Rows[i]["Address"].ToString(),
ds.Tables[0].Rows[i]["OpeningBalance"].ToString(),
ds.Tables[0].Rows[i]["OpeningBalanceType"].ToString()
);
}
return(dt);
}
public BankDetailsEntry(int AccountHeadId)
{
InitializeComponent();
PAccountHeadId = AccountHeadId;
AccountHeadModel bankDetailsModel = new AccountHeadModel();
bankDetailsModel.Action = "fetchbyid";
bankDetailsModel.AccountHeadId = PAccountHeadId;
DataSet ds = bankDetailsModel.AccountHeadOperation();
if (ds.Tables[0].Rows.Count > 0)
{
txt_accountHeadName.Text = ds.Tables[0].Rows[0]["AccountHeadName"].ToString();
txt_BankName.Text = ds.Tables[0].Rows[0]["BankName"].ToString();
txt_bankIFSCcode.Text = ds.Tables[0].Rows[0]["BankIFSCCode"].ToString();
txt_bankBranchName.Text = ds.Tables[0].Rows[0]["BankBranchName"].ToString();
txt_bankAccountNo.Text = ds.Tables[0].Rows[0]["BankAccountNo"].ToString();
txt_accountHolderName.Text = ds.Tables[0].Rows[0]["BankAccountHolderName"].ToString();
ddl_accountGrpId.SelectedItem = ds.Tables[0].Rows[0]["AccountGroupId"].ToString();
btn_AddSaveNew.Enabled = false;
btn_Save.Text = "Update";
}
}
public DataTable LoadBranchState(AccountHeadModel objAHModel)
{
DataTable dtBranchState = objAHDA.LoadBranchState(objAHModel);
return(dtBranchState);
}
public DataTable SaveAccountHead(AccountHeadModel objAHModel)
{
DataTable dtAccountHead = objAHDA.SaveAccountHead(objAHModel);
return(dtAccountHead);
}
private bool Save()
{
if (txt_PartyName.Text != "")
{
double amount = 0;
try
{
amount = double.Parse(txt_CurrentBalance.Text);
}
catch
{
}
if (rb_PurchaseParty.Checked == true)
{
AccountHeadModel account = new AccountHeadModel();
if (btn_Save.Text == "Update")
{
account.Action = "update";
account.AccountHeadId = Partyid;
}
else
{
account.Action = "insert";
}
account.AccountHeadName = txt_PartyName.Text;
account.AccountGroupId = 21;
account.Name = txt_PartyName.Text;
account.GstInNo = txt_Gstinno.Text;
account.State = ddl_State.SelectedItem.ToString();
account.ContactNo1 = txt_PhoneNo.Text;
account.EmailId = txt_EmailId.Text;
account.Address = txt_Address.Text;
account.OpeningBalance = amount;
account.OpeningBalanceType = ddl_OpeningBalanceType.SelectedItem.ToString();
DataSet ds = account.AccountHeadOperation();
if (ds.Tables[0].Rows[0].ItemArray[0].ToString() == "Record Submitted Successfully")
{
MessageBox.Show("Record Submitted successfully", "MINIFY", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(true);
}
else if (ds.Tables[0].Rows[0].ItemArray[0].ToString() == "Updated Successfully")
{
MessageBox.Show("Record Updated Successfully", "MINIFY", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(true);
}
else if (ds.Tables[0].Rows[0].ItemArray[0].ToString() == "Duplicate Record")
{
MessageBox.Show("Record Already Exists!!!Please Try Again With Diffrent Account HeadName", "MINIFY", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
else
{
MessageBox.Show("Failed to Execute Command!!! Please Try Again Later", "MINIFY", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
else if (rb_SaleParty.Checked == true)
{
AccountHeadModel account = new AccountHeadModel();
if (btn_Save.Text == "Update")
{
account.Action = "update";
account.AccountHeadId = Partyid;
}
else
{
account.Action = "insert";
}
account.AccountHeadName = txt_PartyName.Text;
account.AccountGroupId = 22;
account.Name = txt_PartyName.Text;
account.GstInNo = txt_Gstinno.Text;
account.State = ddl_State.SelectedItem.ToString();
account.ContactNo1 = txt_PhoneNo.Text;
account.EmailId = txt_EmailId.Text;
account.Address = txt_Address.Text;
account.OpeningBalance = amount;
account.OpeningBalanceType = ddl_OpeningBalanceType.SelectedItem.ToString();
DataSet ds = account.AccountHeadOperation();
if (ds.Tables[0].Rows[0].ItemArray[0].ToString() == "Record Submitted Successfully")
{
MessageBox.Show("Record Submitted successfully", "MINIFY", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(true);
}
else if (ds.Tables[0].Rows[0].ItemArray[0].ToString() == "Updated Successfully")
{
MessageBox.Show("Record Updated Successfully", "MINIFY", MessageBoxButtons.OK, MessageBoxIcon.Information);
return(true);
}
else if (ds.Tables[0].Rows[0].ItemArray[0].ToString() == "Duplicate Record")
{
MessageBox.Show("Record Already Exists!!!Please Try Again With Diffrent Account HeadName", "MINIFY", MessageBoxButtons.OK, MessageBoxIcon.Warning);
return(false);
}
else
{
MessageBox.Show("Failed to Execute Command!!! Please Try Again Later", "MINIFY", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
else
{
MessageBox.Show("Please Select Party Type Purchase Party Or Sales Party", "MinifyERP", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}
else
{
MessageBox.Show("Please Enter Party Name", "Minify ERP", MessageBoxButtons.OK, MessageBoxIcon.Error);
return(false);
}
}