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