public Acc_ChartOfAccount GetAcc_ChartOfAccountBalance(long chartOfAccountID) { List <Acc_TransactionDetail> transactionDetailList = GetLedgerBalanceByChartOfAccountID(chartOfAccountID); Acc_ChartOfAccount chartOfAccount = GetAcc_ChartOfAccountByID(chartOfAccountID); Decimal balance = 0; foreach (Acc_TransactionDetail td in transactionDetailList) { if (chartOfAccount.Acc_Class.AccountNature == Convert.ToInt32(EnumCollection.TransactionNature.Debit)) { if (chartOfAccount.Acc_Class.AccountNature == td.TransactionNature) { balance -= td.Amount; } else { balance += td.Amount; } } else if (chartOfAccount.Acc_Class.AccountNature == Convert.ToInt32(EnumCollection.TransactionNature.Credit)) { if (chartOfAccount.Acc_Class.AccountNature == td.TransactionNature) { balance -= td.Amount; } else { balance += td.Amount; } } } chartOfAccount.Balance = balance; return(chartOfAccount); }
public Acc_ChartOfAccount GetAcc_ChartOfAccountByParentID(long parentid) { Acc_ChartOfAccount cacc = new Acc_ChartOfAccount(); cacc = Database.Acc_ChartOfAccounts.Where(c => c.ParentID == parentid && c.IsRemoved == 0).FirstOrDefault(); if (cacc != null) { cacc.Acc_Class = cacc.Acc_Class; } return(cacc); }
public Acc_ChartOfAccount GetAcc_ChartOfAccountByID(long id) { Acc_ChartOfAccount cacc = new Acc_ChartOfAccount(); try { cacc = Database.Acc_ChartOfAccounts.Single(c => c.IID == id && c.IsRemoved == 0); } catch (Exception ex) { } return(cacc); }
public Acc_ChartOfAccount GetChartOfAccountByName(string name) { Acc_ChartOfAccount cacc = new Acc_ChartOfAccount(); try { cacc = Database.Acc_ChartOfAccounts.Where(c => c.Name == name && c.IsRemoved == 0).FirstOrDefault(); cacc.Acc_Class = cacc.Acc_Class; } catch (Exception ex) { } return(cacc); }
public Acc_ChartOfAccount GetAcc_ChartOfAccountByAccountNo(string accountNo) { Acc_ChartOfAccount cacc = new Acc_ChartOfAccount(); try { cacc = Database.Acc_ChartOfAccounts.Single(c => c.AccountNo == accountNo && c.IsRemoved == 0); cacc.Acc_Class = cacc.Acc_Class; Acc_ChartOfAccount parentCOA = GetAcc_ChartOfAccountByID(cacc.ParentID); cacc.ParentChartOfAccount = parentCOA; } catch (Exception ex) { } return(cacc); }
protected void btnSave_Click(object sender, EventArgs e) { //if (Session["BranchID"] != null) //{ try { if (CurrentMemberID > 0) { using (TheFacade facade = new TheFacade()) { Member member = facade.MemberFacade.GetMemberById(CurrentMemberID); if (member != null && member.MemberVerificationStatus == (int)EnumCollection.VerificationStatus.Approved_for_Committee_Meeting) { member.MemberVerificationStatus = (int)EnumCollection.VerificationStatus.Completed; member.MembershipStatus = (int)EnumCollection.MembershipStatus.Approved; DateTime expireDate = new DateTime(DateTime.Now.Year, 6, 30); if (DateTime.Now.Date > expireDate) { expireDate = expireDate.AddYears(1); } try { expireDate = Convert.ToDateTime(txtExpireDate.Text); } catch (Exception ex) { } member.MembershipCode = txtMembershipCode.Text; facade.Update <Member>(member); Ins_MembershipExpireInfo info = new Ins_MembershipExpireInfo(); info.MemberID = member.ID; info.ExpireDate = expireDate.Date; info.CreateBy = 1; info.CreateDate = DateTime.Now; info.UpdateBy = 1; info.UpdateDate = DateTime.Now; info.IsRemoved = 0; facade.Insert <Ins_MembershipExpireInfo>(info); Ins_MemberVerification memberVerification = facade.MemberFacade.GetMemberVerificationByMemberID(member.ID); if (memberVerification != null) { memberVerification.Status = (int)EnumCollection.VerificationStatus.Completed; facade.Update <Ins_MemberVerification>(memberVerification); } Acc_ChartOfAccount chartofAcc = facade.AccountsFacade.GetAcc_ChartOfAccountByName("Account Receivable"); Acc_ChartOfAccountMember customerAccount = new Acc_ChartOfAccountMember(); #region acc Acc_ChartOfAccount newAccount = new Acc_ChartOfAccount(); newAccount.AccountNo = GenerateAccountNo(chartofAcc.Gparent.ToString()); newAccount.Name = member.Name; newAccount.IsActive = 1; newAccount.AccountTypeID = Convert.ToInt32(EnumCollection.AccountType.Transactable); newAccount.ParentID = chartofAcc.IID; newAccount.Gparent = chartofAcc.Gparent; newAccount.OpeningBalance = Convert.ToDecimal(txtOpeningBalance.Text); newAccount.CreateBy = 1; newAccount.UpdateBy = 1; newAccount.CreateDate = DateTime.Now; newAccount.UpdateDate = DateTime.Now; newAccount.IsRemoved = 0; facade.Insert <Acc_ChartOfAccount>(newAccount); #endregion customerAccount.ChartofAccountID = newAccount.IID; customerAccount.MemberID = member.ID; customerAccount.UpdateDate = DateTime.Now; customerAccount.UpdateBy = 1; customerAccount.CreateDate = DateTime.Now; customerAccount.CreateBy = 1; customerAccount.IsRemoved = 0; facade.Insert <Acc_ChartOfAccountMember>(customerAccount); } else { Session["duplicate"] = true; } } } else { using (TheFacade facade = new TheFacade()) { } } Session["IsSaved"] = true; } catch { Session["IsSaved"] = false; } finally { Response.Redirect(Request.Url.ToString()); } //} //else //{ // FormsAuthentication.SignOut(); // Roles.DeleteCookie(); // Session.Abandon(); // Response.Redirect("~/login.aspx"); //} }
//Account Number Generate public long GetMemberForAccount(long CurrentMemberID) { try { if (CurrentMemberID > 0) { using (TheFacade facade = new TheFacade()) { Member member = facade.MemberFacade.GetMemberById(CurrentMemberID); if (member != null) { member.MemberVerificationStatus = (int)EnumCollection.VerificationStatus.Completed; member.MembershipStatus = (int)EnumCollection.MembershipStatus.Approved; DateTime expireDate = new DateTime(DateTime.Now.Year, 6, 30); if (DateTime.Now.Date > expireDate) { expireDate = expireDate.AddYears(1); } try { expireDate = Convert.ToDateTime(txtExpireDate.Text); } catch (Exception ex) { } member.MembershipCode = txtMembershipCode.Text; facade.Update <Member>(member); Ins_MembershipExpireInfo info = new Ins_MembershipExpireInfo(); info.MemberID = member.ID; info.ExpireDate = expireDate.Date; info.CreateBy = 1; info.CreateDate = DateTime.Now; info.UpdateBy = 1; info.UpdateDate = DateTime.Now; info.IsRemoved = 0; facade.Insert <Ins_MembershipExpireInfo>(info); Ins_MemberVerification memberVerification = facade.MemberFacade.GetMemberVerificationByMemberID(member.ID); if (memberVerification != null) { memberVerification.Status = (int)EnumCollection.VerificationStatus.Completed; facade.Update <Ins_MemberVerification>(memberVerification); } Acc_ChartOfAccount chartofAcc = facade.AccountsFacade.GetAcc_ChartOfAccountByName("Account Receivable"); Acc_ChartOfAccountMember customerAccount = new Acc_ChartOfAccountMember(); #region acc Acc_ChartOfAccount newAccount = new Acc_ChartOfAccount(); newAccount.AccountNo = GenerateAccountNo(chartofAcc.Gparent.ToString()); newAccount.Name = member.Name; newAccount.IsActive = 1; newAccount.AccountTypeID = Convert.ToInt32(EnumCollection.AccountType.Transactable); newAccount.ParentID = chartofAcc.IID; newAccount.Gparent = chartofAcc.Gparent; newAccount.OpeningBalance = Convert.ToDecimal(txtOpeningBalance.Text); newAccount.CreateBy = 1; newAccount.UpdateBy = 1; newAccount.CreateDate = DateTime.Now; newAccount.UpdateDate = DateTime.Now; newAccount.IsRemoved = 0; facade.Insert <Acc_ChartOfAccount>(newAccount); #endregion customerAccount.ChartofAccountID = newAccount.IID; customerAccount.MemberID = member.ID; customerAccount.UpdateDate = DateTime.Now; customerAccount.UpdateBy = 1; customerAccount.CreateDate = DateTime.Now; customerAccount.CreateBy = 1; customerAccount.IsRemoved = 0; facade.Insert <Acc_ChartOfAccountMember>(customerAccount); } else { Session["duplicate"] = true; } } } else { using (TheFacade facade = new TheFacade()) { } } Session["IsSaved"] = true; } catch { Session["IsSaved"] = false; } finally { Response.Redirect(Request.Url.ToString()); } lablmessage.Text = " Registration & Account Create Succesfully"; return(CurrentMemberID); }