public Service Create(Service entity) { if (entity == null) { throw new ArgumentNullException(); } context.Services.Add(entity); context.SaveChanges(); return(entity); }
public Request Create(Request entity) { if (entity == null) { throw new ArgumentNullException(); } context.Requests.Add(entity); context.SaveChanges(); return(entity); }
public Client Create(Client entity) { if (entity == null) { throw new ArgumentNullException(); } context.Clients.Add(entity); context.SaveChanges(); return(entity); }
public RetType updatebilldetailsoperation(string TransactionId, string TransactionDate, string Amount, string Mode, string RequestId, string SchoolName, string EnrollmentNo) { SoapContext db = new SoapContext(); TBLFEECOLLECTIONNKVSFEDERAL objFEE = new TBLFEECOLLECTIONNKVSFEDERAL(); TBLRECEIPTTABLENEWFEDEREAL objREC = new TBLRECEIPTTABLENEWFEDEREAL(); TBLFEDERALREQUESTDETAIL objFED = db.TBLFEDERALREQUESTDETAILS.Where(r => r.REQUESTID == RequestId).FirstOrDefault(); RetType obj = new RetType(); string Status = "F"; try { string PaymentType = ""; if (Mode == "C") { PaymentType = "CASH"; } if (Mode == "T") { PaymentType = "TRANSFER"; } double AmountReceived = 0; if (Amount != "") { AmountReceived = Convert.ToDouble(Amount); } bool flag = false; var FeeSetting = db.View_GetFeeSettings.Where(r => r.ENROLLMENTNO == EnrollmentNo.Trim().ToUpper()).ToList(); var StudentData = db.View_GetSudentStandard.Where(r => r.ENROLLMENTNO == EnrollmentNo.Trim().ToUpper()).FirstOrDefault(); var ReceiptNo = db.View_GetReceiptNo.OrderByDescending(r => r.RECEIPTID).FirstOrDefault(); string StudReceiptNo = "", value = ""; if (ReceiptNo != null) { if (ReceiptNo.RECEIPTNO != "") { int NO = int.Parse(ReceiptNo.RECEIPTNO) + 1; value = String.Format("{0:D5}", NO); } } StudReceiptNo = "A-" + FeeSetting[0].ACADEMICYEAR + "/" + value; if (FeeSetting != null) { if (AmountReceived != 0) { for (int i = 0; i < FeeSetting.Count; i++) { double PaidAmount = 0, PendingAmount = 0; double InstAmount = 0, Due = 0; InstAmount = Convert.ToDouble(FeeSetting[i].AMOUNT); string Installment = FeeSetting[i].FEETYPE; DateTime DueDate = Convert.ToDateTime(FeeSetting[i].DUEDATE).Date; var FeesPaid = db.View_GetPaidFees.Where(r => r.ENROLLMENTNO == EnrollmentNo.Trim().ToUpper() && r.FEETYPE == Installment).ToList(); if (FeesPaid.Count > 0) { for (int j = 0; j < FeesPaid.Count; j++) { PaidAmount = PaidAmount + Convert.ToDouble(FeesPaid[j].AMOUNT); } //PaidAmount = Convert.ToDouble(Amount); } else { PendingAmount = InstAmount; } if (PaidAmount != InstAmount && PaidAmount < InstAmount && AmountReceived > 0) { flag = false; PendingAmount = InstAmount - PaidAmount; if (AmountReceived >= PendingAmount) { AmountReceived = AmountReceived - PendingAmount; DateTime paymentdate = Convert.ToDateTime(TransactionDate).Date; if (paymentdate > DueDate) { int LATEBYDAYS = (paymentdate - DueDate).Days; Due = LATEBYDAYS * Convert.ToDouble(FeeSetting[i].INSTALLMENTFINE); } AmountReceived = AmountReceived - Due; objFEE.ENROLLMENTNO = StudentData.ENROLLMENTNO; objFEE.STUDENTID = StudentData.STUDENTID; objFEE.STANDARDID = Convert.ToInt32(StudentData.STANDARDID); objFEE.FEETYPEID = FeeSetting[i].FEETYPEID; objFEE.AMOUNT = Convert.ToDecimal(PendingAmount); objFEE.FINE = Convert.ToDecimal(Due); objFEE.PAYMENTTYPE = PaymentType; objFEE.RECEIPTNO = StudReceiptNo; objFEE.CREATEDTIME = DateTime.Now.ToShortTimeString(); objFEE.CREATEDON = paymentdate; objFEE.REQUESTID = RequestId; objFEE.TRANSACTIONSTATUS = "Successful"; db.TBLFEECOLLECTIONNKVSFEDERALs.Add(objFEE); int status = db.SaveChanges(); if (status > 0) { flag = true; Status = "S"; } else { Status = "F"; } } } } if (flag == true) { objREC.STUDENTID = StudentData.STUDENTID.ToString(); objREC.RECEIPTNO = Convert.ToInt32(value); objREC.ACADEMICYEAR = FeeSetting[0].ACADEMICYEAR; db.TBLRECEIPTTABLENEWFEDEREALs.Add(objREC); db.SaveChanges(); objFED.TRANSACTIONSTATUS = Status; objFED.UPDATEDDATE = DateTime.Now; db.SaveChanges(); } } } } catch (Exception ex) { } RetType objRET = new RetType(); objRET.out1 = Status; objRET.out2 = TransactionId; objRET.out3 = TransactionDate; return(objRET); }
public RetType getbilldetailsoperation(string SchoolName, string StudentName, string EnrollmentNo) { string Paymentdate = DateTime.Now.ToString("dd/MM/yyyy"); SoapContext objSC = new SoapContext(); TBLFEDERALREQUESTDETAIL objFB = new TBLFEDERALREQUESTDETAIL(); RetType obj = new RetType(); string Install1 = "", Install2 = "", Install3 = "", Install4 = ""; try { var Concession = objSC.View_GetConcessionDetails.Where(r => r.ENROLLMENTNO == EnrollmentNo.Trim().ToUpper()).FirstOrDefault(); var FeeSetting = objSC.View_GetFeeSettings.Where(r => r.ENROLLMENTNO == EnrollmentNo.Trim().ToUpper()).ToList(); string Studentname = Concession.STUDENTNAME; double PendingAmount = 0, Due = 0, ConcessionAmount = 0; if (Concession != null) { if (Concession.CONCESSION == "YES") { ConcessionAmount = Convert.ToDouble(Concession.CONCESSIONPERCENTAGE); } } if (FeeSetting != null) { for (int i = 0; i < FeeSetting.Count; i++) { double Amount = 0, InstPendingAmount = 0, InstFine = 0; string Installment = FeeSetting[i].FEETYPE; var FeesPaid = objSC.View_GetPaidFees.Where(r => r.ENROLLMENTNO == EnrollmentNo.Trim().ToUpper() && r.FEETYPE == Installment).ToList(); if (FeesPaid.Count > 0) { for (int j = 0; j < FeesPaid.Count; j++) { Amount = Amount + Convert.ToDouble(FeesPaid[j].AMOUNT); } PendingAmount += Convert.ToDouble(FeeSetting[i].AMOUNT) - Amount; InstPendingAmount = Convert.ToDouble(FeeSetting[i].AMOUNT) - Amount; } else { Amount = Amount + Convert.ToDouble(FeeSetting[i].AMOUNT); PendingAmount += Amount; InstPendingAmount = Convert.ToDouble(FeeSetting[i].AMOUNT); } DateTime duedate = Convert.ToDateTime(FeeSetting[i].DUEDATE).Date; DateTime dt1 = Convert.ToDateTime(DateTime.Now.ToShortDateString()).Date; //string[] DATESPLIT = Paymentdate.Split('/'); //if (DATESPLIT.Length!=3) //{ // string[] DASHDATESPLIT = Paymentdate.Split('-'); // try // { // string actualdate = DASHDATESPLIT[1] + "/" + DASHDATESPLIT[0] + "/" + DASHDATESPLIT[2]; // dt1 = Convert.ToDateTime(actualdate).Date; // } // catch (Exception ex) // { // string actualdate = DASHDATESPLIT[1] + "-" + DASHDATESPLIT[0] + "-" + DASHDATESPLIT[2]; // dt1 = Convert.ToDateTime(actualdate).Date; // } //} //else //{ // string actualdate = DATESPLIT[1] + "/" + DATESPLIT[0] + "/" + DATESPLIT[2]; // dt1 = Convert.ToDateTime(actualdate).Date; //} if (PendingAmount != 0) { if (dt1 > duedate) { int LATEBYDAYS = (dt1 - duedate).Days; Due += LATEBYDAYS * Convert.ToDouble(FeeSetting[i].INSTALLMENTFINE); InstFine = LATEBYDAYS * Convert.ToDouble(FeeSetting[i].INSTALLMENTFINE); } } if (InstPendingAmount == 0) { if (Installment == "INSTALLMENT 1") { Install1 = "INSTALLMENT 1-PAID"; } if (Installment == "INSTALLMENT 2") { Install2 = "INSTALLMENT 2-PAID"; } if (Installment == "INSTALLMENT 3") { Install3 = "INSTALLMENT 3-PAID"; } if (Installment == "INSTALLMENT 4") { Install4 = "INSTALLMENT 4-PAID"; } } else { if (Installment == "INSTALLMENT 1") { Install1 = "INSTALLMENT 1 : " + InstPendingAmount + " - FINE : " + InstFine + ""; } if (Installment == "INSTALLMENT 2") { Install2 = "INSTALLMENT 2 : " + InstPendingAmount + " - FINE : " + InstFine + ""; } if (Installment == "INSTALLMENT 3") { Install3 = "INSTALLMENT 3 : " + InstPendingAmount + " - FINE : " + InstFine + ""; } if (Installment == "INSTALLMENT 4") { Install4 = "INSTALLMENT 4 : " + InstPendingAmount + " - FINE : " + InstFine + ""; } } } string REQID = "", REQUESTID = ""; var CurrentRequestId = objSC.View_GETFEDERALREQUESTID.OrderByDescending(r => r.BANKREQUESTID).FirstOrDefault(); if (CurrentRequestId != null) { REQID = CurrentRequestId.REQUESTID; } if (REQID == "" || REQID == null) { REQUESTID = "FB00000001"; } else { int NO = int.Parse(REQID) + 1; REQUESTID = "FB" + String.Format("{0:D8}", NO); } if (REQUESTID != null) { objFB.REQUESTID = REQUESTID; objFB.ENROLLMENTNO = EnrollmentNo.ToString().ToUpper(); objFB.REQUESTDATE = DateTime.Now; objSC.TBLFEDERALREQUESTDETAILS.Add(objFB); objSC.SaveChanges(); } double GrandPending = 0; if (PendingAmount != 0) { GrandPending = PendingAmount - ConcessionAmount; if (GrandPending != 0) { GrandPending = GrandPending + Due; } } obj.out1 = REQUESTID; obj.out2 = (GrandPending).ToString(); obj.out3 = Studentname.ToString(); obj.out4 = EnrollmentNo.Trim().ToUpper(); obj.out5 = Install1; obj.out6 = Install2; obj.out7 = Install3; obj.out8 = Install4; } } catch (Exception e) { obj.out1 = Paymentdate + "----" + e.StackTrace; } return(obj); }