public int?ForgotPasswordRegister(RegisterModel modelobj)
{
try
{
using (var paymentEntities = new BillPaymentEntities())
{
var forgotPassword = paymentEntities.table_Registration.FirstOrDefault(obj => obj.MobileNumber == modelobj.MobileNumber &&
obj.SecurityAnswer == modelobj.SecurityAnswer &&
obj.SecurityQuestion == modelobj.SecurityQuestion);
if (forgotPassword != null)
{
forgotPassword.NewPassword = modelobj.NewPassword;
forgotPassword.ConfirmPassword = modelobj.ConfirmPassword;
var login = paymentEntities.table_Login.FirstOrDefault(obj => obj.MobileNumber == modelobj.MobileNumber);
login.ConfirmPassword = modelobj.ConfirmPassword;
paymentEntities.SaveChanges();
}
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
return(null);
}
return(1);
}
public List <PaymentTrasaction> GetStatemnent(PaymentTrasaction objtrasact)
{
try
{
using (var paymenttrasaction = new BillPaymentEntities())
{
//We didn't add coloum in table thatwhy comming error higligh in red please check the implementation only.
return((from trasactiondetails in paymenttrasaction.debit_creditcard_table
where trasactiondetails.AccountHolderName == objtrasact.AccountHolderName && trasactiondetails.IFSCcode == objtrasact.BankIFSCCode && trasactiondetails.CustomerID = objtrasact.CustomerIdCode
select new PaymentTrasaction
{
AccountHolderName = trasactiondetails.AccountHolderName,
Amount = Convert.ToDouble(trasactiondetails.MRP),
Trasactiontype = trasactiondetails.trasactiontype,
Creditdebitstatus = trasactiondetails.Creditdebitstatus,
DateTime = trasactiondetails.DateTime,
}).ToList());
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
return(null);
}
}
public List <PrePaidModel> Display(string MobileOperator)
{
try
{
using (var paymentEntities = new BillPaymentEntities())
{
return((from prepaid in paymentEntities.Operator_Table1
where prepaid.Operator == MobileOperator
select new PrePaidModel
{
Operator = prepaid.Operator,
MRP = Convert.ToDouble(prepaid.MRP),
ValidateDays = prepaid.ValidateDays,
Descriptions = prepaid.Descriptions,
Roaming = prepaid.Roaming,
SMS = prepaid.SMS,
DataSpeed = prepaid.DataSpeed
}).ToList());
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
return(null);
}
}
public int?RegisterCustomerData(RegisterModel registerObj)
{
try
{
using (var paymentEntities = new BillPaymentEntities())
{
var tabReg = new table_Registration();
tabReg.CustomerName = registerObj.CustomerName;
tabReg.MobileNumber = registerObj.MobileNumber;
tabReg.EmailID = registerObj.EmailId;
tabReg.Plantype = registerObj.Plantype;
tabReg.SecurityQuestion = registerObj.SecurityQuestion;
tabReg.SecurityAnswer = registerObj.SecurityAnswer;
tabReg.NewPassword = registerObj.NewPassword;
tabReg.ConfirmPassword = registerObj.ConfirmPassword;
tabReg.Operator = registerObj.Operator;
paymentEntities.table_Registration.Add(tabReg);
var tabLogin = new table_Login();
tabLogin.MobileNumber = registerObj.MobileNumber;
tabLogin.ConfirmPassword = registerObj.ConfirmPassword;
paymentEntities.table_Login.Add(tabLogin);
if (registerObj.Plantype == "Prepaid")
{
var prePaid = new PrePaid();
prePaid.MobileNumber = registerObj.MobileNumber;
prePaid.Operator = registerObj.Operator;
paymentEntities.PrePaids.Add(prePaid);
}
else if (registerObj.Plantype == "Postpaid")
{
var postPaid = new PostPaid();
postPaid.MobileNumber = registerObj.MobileNumber;
postPaid.Operator = registerObj.Operator;
paymentEntities.PostPaids.Add(postPaid);
}
paymentEntities.SaveChanges();
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
return(null);
}
return(1);
}
public int?LoginVerify(long MobileNumber)
{
try
{
using (var paymentEntities = new BillPaymentEntities())
{
return((from postPaid in paymentEntities.PostPaids
where postPaid.MobileNumber == MobileNumber
select postPaid).ToList().Count() > 0 ? 1 : 0);
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
return(null);
}
}
public int?LoginCustomer(LoginModel loginobj)
{
try
{
using (var paymentEntities = new BillPaymentEntities())
{
return((from cust in paymentEntities.table_Login
where cust.MobileNumber == loginobj.MobileNumber && cust.ConfirmPassword == loginobj.ConfirmPassword
select cust).ToList().Count() > 0 ? 1 : 0);
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
return(null);
}
}
public int?CheckNumber(long MobileNumber, string Operator)
{
try
{
using (var paymentEntities = new BillPaymentEntities())
{
return((from prePaid in paymentEntities.PrePaids
where prePaid.MobileNumber == MobileNumber &&
prePaid.Operator == Operator
select prePaid).ToList().Count() > 0 ? 1 : 0);
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
return(null);
}
}
public int?DTHPayment(DthModel DTHobj)
{
try
{
using (var paymentEntities = new BillPaymentEntities())
{
return((from Dth in paymentEntities.DthService
where Dth.SubsID == DTHobj.SubscriberNumber &&
Dth.Operator == DTHobj.Operator
select Dth).ToList().Count() > 0 ? 1 : 0);
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
return(null);
}
}
public int?PostPaid(PostPaidModel postobj)
{
try
{
using (var paymentEntities = new BillPaymentEntities())
{
return((from postPaid in paymentEntities.PostPaids
where postPaid.MobileNumber == postobj.MobileNumber &&
postPaid.Operator == postobj.Operator
select postPaid).ToList().Count() > 0 ? 1 : 0);
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
return(null);
}
}
public int?CheckCustomerIdentity(int?CustomerId, string IFSCcode, string BankName, int accountnumber)
{
try
{
//We didn't add coloum in table thatwhy comming error higligh in red please check the implementation only.
using (var paymenttrasaction = new BillPaymentEntities())
{
return((from Chkcust in paymenttrasaction.debit_creditcard_table
where CustomerId == Chkcust.CustomerId &&
IFSCcode == Chkcust.IFSCcode && BankName = Chkcust.BankName && accountnumber = Chkcust.acccountNumber
select prePaid).ToList().Count() > 0 ? 1 : 0);
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
return(null);
}
}
public int?NetBanking(PaymentModel modelobj)
{
try
{
using (var paymentEntities = new BillPaymentEntities())
{
var debitandcredit = paymentEntities.debit_creditcard_table.FirstOrDefault(obj => obj.UserID == modelobj.UserID &&
obj.UserPassword == modelobj.UserPassword && obj.BankName == modelobj.BankName &&
obj.Balance > Convert.ToDecimal(modelobj.Balance));
debitandcredit.Balance -= Convert.ToDecimal(modelobj.Amount);
paymentEntities.SaveChanges();
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
return(null);
}
return(1);
}
public int?PaymentCreditCard(PaymentModel modelobj)
{
try
{
using (var paymentEntities = new BillPaymentEntities())
{
var debitandcredit = paymentEntities.debit_creditcard_table.FirstOrDefault(obj => obj.CardNumber == modelobj.CardNumber &&
obj.CVVNumber == modelobj.CVVNumber && obj.ExpiryDate == modelobj.ExpiryDate &&
obj.Balance > Convert.ToDecimal(modelobj.Balance));
debitandcredit.Balance -= Convert.ToDecimal(modelobj.Amount);
paymentEntities.SaveChanges();
}
}
catch (Exception ex)
{
logger.Error(ex.Message);
return(null);
}
return(1);
}
