public int SaveGeneral() { int Row = 0; DBCon con = new DBCon(); SqlCommand cmd = null; Accounts ACDetails = Accounts.GetAll().Where(w => (w.ACRLedgerId == CRLedgerId || w.ACRLedgerId == DRLedgerId) && w.EntryType == Entrytype).LastOrDefault(); if (ACDetails != null) { EntryNo = ACDetails.EntryNo + 1; } else { EntryNo = EntryNo + 1; } Ledger LedgerDetails = Ledger.GetAll().Where(w => w.ID == CRLedgerId || w.ID == DRLedgerId).FirstOrDefault(); if (CRAmount > 0) { CRLedgerId = CRLedgerId; DRLedgerId = 0; } else { DRLedgerId = CRLedgerId; CRLedgerId = 0; } if (this.Entrytype == "1") { this.Entrytype = "Payment"; } if (this.Entrytype == "2") { this.Entrytype = "Receipt"; } if (this.Entrytype == "3") { this.Entrytype = "Contra Entry"; } if (this.Entrytype == "4") { this.Entrytype = "Journal Entry"; } if (this.Entrytype == "5") { this.Entrytype = "Sale"; } if (this.Entrytype == "6") { this.Entrytype = "Purchase"; } try { string Quary = ""; if (this.AID == 0) { Quary = "Insert Into ACAccount Values (@Date,@DRAmount,@CRAmount,@Narration,@Balance,@CRGroupId,@OrgId,@DRGroupId,@CRLedgerId,@DRLedgerId,@EntryNo,@EntryType,@ReceiptID);SELECT SCOPE_IDENTITY();"; } else { Quary = "Update ACAccount Set Date=@Date,DRAmount=@DRAmount,CRAmount=@CRAmount,Narration=@Narration,Balance=@Balance,CRGroupId=@CRGroupId,OrgId=@OrgId,DRGroupId=@DRGroupId,CRLedgerId=@CRLedgerId,DRLedgerId=@DRLedgerId,EntryNo=@EntryNo,EntryType=@EntryType,ReceiptID=@ReceiptID where AID=@AID"; } cmd = new SqlCommand(Quary, con.Con); cmd.Parameters.AddWithValue("@AID", this.AID); cmd.Parameters.AddWithValue("@Date", this.Date); cmd.Parameters.AddWithValue("@DRAmount", this.DRAmount); cmd.Parameters.AddWithValue("@CRAmount", this.CRAmount); cmd.Parameters.AddWithValue("@Narration", this.Narration); cmd.Parameters.AddWithValue("@Balance", this.Balance); cmd.Parameters.AddWithValue("@CRGroupId", LedgerDetails.ParentGroup); cmd.Parameters.AddWithValue("@OrgId", LedgerDetails.OrgId); cmd.Parameters.AddWithValue("@DRGroupId", LedgerDetails.ParentGroup); cmd.Parameters.AddWithValue("@CRLedgerId", this.CRLedgerId); cmd.Parameters.AddWithValue("@DRLedgerId", this.DRLedgerId); cmd.Parameters.AddWithValue("@EntryNo", this.EntryNo); cmd.Parameters.AddWithValue("@EntryType", this.Entrytype); cmd.Parameters.AddWithValue("@ReceiptID", this.ReceiptID); if (this.AID == 0) { Row = Convert.ToInt32(cmd.ExecuteScalar()); this.AID = Row; } else { Row = cmd.ExecuteNonQuery(); //this.CategoryID = Row; } } catch (Exception e) { e.ToString(); } finally { cmd.Dispose(); con.Con.Close(); } return(Row); }
public static List <Accounts> GetLedgerWiseData(int ID, string Name) { DBCon con = new DBCon(); SqlCommand cmd = null; SqlDataReader SDR = null; Accounts OBJ = new Accounts(); List <Accounts> AccountList = new List <Accounts>(); try { if (Name == "Customer") { List <Receipt> GetAllReceipt = Receipt.GetAllList(0, 0).ToList(); for (int i = 0; i < GetAllReceipt.Count; i++) { OBJ = new Accounts(); if (GetAllReceipt[i].Particular == "Opening Balance") { OBJ.Date = GetAllReceipt[i].Date; OBJ.ReceiptType = ""; OBJ.Type = ""; OBJ.Narration = GetAllReceipt[i].Particular; OBJ.CRAmount = GetAllReceipt[i].Amount; OBJ.Balance = (GetAllReceipt[i].Balance + OBJ.CRAmount) - OBJ.DRAmount; AccountList.Add(OBJ); } else { OBJ.Date = GetAllReceipt[i].Date; OBJ.ReceiptType = "Receipt"; OBJ.Type = "R" + GetAllReceipt[i].EntryNo.ToString(); OBJ.Narration = GetAllReceipt[i].Particular; OBJ.CRAmount = GetAllReceipt[i].Amount; OBJ.Balance = (GetAllReceipt[i - 1].Balance + OBJ.CRAmount) - OBJ.DRAmount; AccountList.Add(OBJ); } } } else if (Name == "Paytm") { List <Receipt> GetAllReceipt = Receipt.GetAllList(0, 0).ToList(); for (int i = 0; i < GetAllReceipt.Count; i++) { OBJ = new Accounts(); if (GetAllReceipt[i].Particular == "Opening Balance") { OBJ.Date = GetAllReceipt[i].Date; OBJ.ReceiptType = ""; OBJ.Type = ""; OBJ.Narration = GetAllReceipt[i].Particular; OBJ.DRAmount = GetAllReceipt[i].Amount; OBJ.Balance = (GetAllReceipt[i].Balance - OBJ.DRAmount) + OBJ.CRAmount; AccountList.Add(OBJ); } else { OBJ.Date = GetAllReceipt[i].Date; OBJ.ReceiptType = "Receipt"; OBJ.Type = "R" + GetAllReceipt[i].EntryNo.ToString(); OBJ.Narration = GetAllReceipt[i].Particular; OBJ.DRAmount = GetAllReceipt[i].Amount; OBJ.Balance = (AccountList[i - 1].Balance - OBJ.DRAmount) + OBJ.CRAmount; AccountList.Add(OBJ); } } } else { List <Accounts> REList = Accounts.GetAll().Where(w => w.CRLedgerId == ID || w.DRLedgerId == ID).OrderBy(o => o.Date).ToList(); for (int i = 0; i < REList.Count; i++) { OBJ = new Accounts(); OBJ.Date = REList[i].Date; OBJ.ReceiptType = REList[i].EntryType; if (REList[i].EntryType == "Receipt") { OBJ.Type = "R" + REList[i].EntryNo.ToString(); } if (REList[i].EntryType == "Sale") { OBJ.Type = "S" + REList[i].EntryNo.ToString(); } if (REList[i].EntryType == "Journal") { OBJ.Type = "J" + REList[i].EntryNo.ToString(); } if (REList[i].EntryType == "Payment") { OBJ.Type = "P" + REList[i].EntryNo.ToString(); } OBJ.Narration = REList[i].Narration; OBJ.DRAmount = REList[i].CRAmount; OBJ.CRAmount = REList[i].DRAmount; if (OBJ.CRAmount > 0) { OBJ.Balance = REList[i].Balance + OBJ.CRAmount; } else { OBJ.Balance = REList[i].Balance - OBJ.CRAmount; } AccountList.Add(OBJ); } } } catch (Exception e) { e.ToString(); } return(AccountList); }