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