public object SetPayment(string FlatNo, int PaymentID, string PaymentMode, string ChequeNo, decimal Amount, decimal Penalty) { var DC = new DataClassesDataContext(); tblTransaction TransactionObj = new tblTransaction(); TransactionObj.PaymentID = PaymentID; TransactionObj.PaymentMode = PaymentMode; TransactionObj.Penalty = Convert.ToDecimal(Penalty); TransactionObj.TransactionType = "Income"; TransactionObj.TransactionOn = DateTime.Now; TransactionObj.FlatNo = FlatNo; TransactionObj.Amount = Amount; if (ChequeNo != "") { TransactionObj.ChequeNo = ChequeNo; } DC.tblTransactions.InsertOnSubmit(TransactionObj); tblIncome IncomeObj = new tblIncome(); IncomeObj.Amount = Amount; IncomeObj.Description = "Maintenance from " + FlatNo + " with " + Penalty + " Penalty"; IncomeObj.IncomeName = "Maintenance from " + FlatNo; IncomeObj.PaymentMode = PaymentMode; IncomeObj.IncomeType = "Maintenance"; IncomeObj.IsDeleted = false; DC.tblIncomes.InsertOnSubmit(IncomeObj); DC.SubmitChanges(); return("True"); }
/* Complaints */ /* Payments & Transactions */ public object AddIncome(string IncomeName, string Type, string Description, decimal Amount, string PaymentMode) { var DC = new DataClassesDataContext(); tblIncome IncomeObj = new tblIncome(); IncomeObj.IncomeName = IncomeName; IncomeObj.IncomeType = Type; IncomeObj.Description = Description; IncomeObj.Amount = Amount; IncomeObj.PaymentMode = PaymentMode; IncomeObj.IsDeleted = false; DC.tblIncomes.InsertOnSubmit(IncomeObj); DC.SubmitChanges(); return(true); }