public List <BikeInformation> BikeHomeInfo(int PageNo, int PageSize)
{
var bikeInformation = new List <BikeInformation>();
using (var db = new ObickeEntities())
{
var totalRecord = db.BikeInformations.Count();
if (totalRecord <= PageSize)
{
bikeInformation = db.BikeInformations.Where(a => a.IsActive == true && a.IsDelete == false).OrderBy(a => a.BikePrice).ToList();
}
else
{
int recordCount = db.BikeInformations.Where(a => a.IsActive == true && a.IsDelete == false).OrderBy(a => a.BikePrice).Skip((PageNo - 1) * PageSize).Count();
if (recordCount < PageSize)
{
bikeInformation = db.BikeInformations.Where(a => a.IsActive == true && a.IsDelete == false).OrderBy(a => a.BikePrice).Skip((PageNo - 1) * PageSize).Take(recordCount).ToList();
}
else
{
bikeInformation = db.BikeInformations.Where(a => a.IsActive == true && a.IsDelete == false).OrderBy(a => a.BikePrice).Skip((PageNo - 1) * PageSize).Take(PageSize).ToList();
}
}
bikeInformation.ForEach(a => a.ImageDetails.Where(x => x.BikeId == a.BikeId));
}
return(bikeInformation);
}
public bool IsMobileNoVerified(string MobileNo, string Otp)
{
using (var db = new ObickeEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
var IsAlreadyExists = db.MobileOtps.Where(a => a.MobileNo == MobileNo && a.OTP == Otp).FirstOrDefault();
if (IsAlreadyExists != null)
{
return(true);
}
else
{
return(false);
}
}
catch (Exception ex)
{
return(false);
}
}
}
}
public bool UpdateSecretToken(string MobileNo, string Token)
{
using (var db = new ObickeEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
var IsAlreadyExists = db.MobileOtps.Where(a => a.MobileNo == MobileNo).FirstOrDefault();
if (IsAlreadyExists != null)
{
IsAlreadyExists.SecretToken = Token;
IsAlreadyExists.ModifiedDateTime = DateTime.Now;
db.SaveChanges();
}
transaction.Commit();
return(true);
}
catch (Exception Ex)
{
string msg = Ex.ToString();
transaction.Rollback();
return(false);
}
}
}
}
public List <BikeHomeModel> GetBikInfoCart(List <BikecartlistIds> Bikeids)
{
var bikeInformation = new List <BikeHomeModel>();
if (Bikeids != null)
{
using (var db = new ObickeEntities())
{
for (int i = 0; i < Bikeids.Count; i++)
{
var _Bikeobj = new BikeHomeModel();
int id = Bikeids[i].BikeId;
var Bikedetail = db.BikeInformations.Where(x => x.BikeId == id).FirstOrDefault();
if (Bikedetail != null)
{
_Bikeobj.BikeId = id;
_Bikeobj.Price = Bikedetail.BikePrice ?? 0;
_Bikeobj.BikeName = Bikedetail.BikeBrand;
_Bikeobj.Driven = Bikedetail.BikeKmDriven;
_Bikeobj.ModelYear = Convert.ToString(Bikedetail.BikeRegistrationYear);
_Bikeobj.IsActive = Bikedetail.IsActive;
_Bikeobj.ImageUrl = Bikedetail.ImageDetails.Where(x => x.BikeId == id).Select(k => k.ImgPath).FirstOrDefault() == null ? "" : Bikedetail.ImageDetails.Where(x => x.BikeId == id).Select(k => k.ImgPath).FirstOrDefault();
}
bikeInformation.Add(_Bikeobj);
}
}
}
return(bikeInformation);
}
public string RemoveCart(BikeInfoById bikeInfoById)
{
using (var db = new ObickeEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
var isExists = db.AddToCarts.Where(a => a.SecretToken == bikeInfoById.SecretToken && a.BikeId == bikeInfoById.BikeId).FirstOrDefault();
if (isExists != null)
{
db.AddToCarts.Remove(isExists);
db.SaveChanges();
transaction.Commit();
return("Success");
}
else
{
return("No record found");
}
}
catch (Exception Ex)
{
string msg = Ex.ToString();
transaction.Rollback();
return(Ex.Message);
}
}
}
}
public List <BikeInformation> BikeInfo()
{
var bikeInformation = new List <BikeInformation>();
using (var db = new ObickeEntities())
{
bikeInformation = db.BikeInformations.ToList();
}
return(bikeInformation);
}
public BikeInformation PostBikeInfoDetails(CoreBikeInformation BikeInformationsmodel)
{
using (var db = new ObickeEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
BikeInformation data = new BikeInformation()
{
BikeBrand = BikeInformationsmodel.BikeBrand,
BikeModel = Convert.ToDecimal(BikeInformationsmodel.BikeModel),
BikeRegistrationYear = BikeInformationsmodel.BikeRegistrationYear,
BikeKmDriven = BikeInformationsmodel.BikeKmDriven,
BikeDescription = BikeInformationsmodel.BikeDescription,
BikeOwnerName = BikeInformationsmodel.BikeOwnerName,
BikePrice = BikeInformationsmodel.BikePrice,
IsActive = true,
IsDelete = false
};
db.BikeInformations.Add(data);
db.SaveChanges();
foreach (var obj in BikeInformationsmodel.Imagepath)
{
ImageDetail imgdeatails = new ImageDetail()
{
BikeId = data.BikeId,
ImgPath = obj.Imagepath
};
db.ImageDetails.Add(imgdeatails);
}
db.SaveChanges();
transaction.Commit();
return(data);
}
catch (Exception Ex)
{
string msg = Ex.ToString();
transaction.Rollback();
return(null);
}
}
}
}
public bool SaveUpdateMobileNoWithOtp(MobileOtpDetails mobileOtpDetails)
{
using (var db = new ObickeEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
var IsAlreadyExists = db.MobileOtps.Where(a => a.MobileNo == mobileOtpDetails.MobileNo).FirstOrDefault();
if (IsAlreadyExists != null)
{
IsAlreadyExists.OTP = mobileOtpDetails.OTP;
IsAlreadyExists.OTPSendCount = IsAlreadyExists.OTPSendCount + 1;
IsAlreadyExists.ModifiedDateTime = DateTime.Now;
db.SaveChanges();
}
else
{
MobileOtp mobileOtp = new MobileOtp()
{
MobileNo = mobileOtpDetails.MobileNo,
OTP = mobileOtpDetails.OTP,
OTPSendCount = 1,
IsActive = true,
CreatedDateTime = DateTime.Now,
ModifiedDateTime = DateTime.Now
};
db.MobileOtps.Add(mobileOtp);
db.SaveChanges();
}
transaction.Commit();
//Send sms on mobile
SendSMS(mobileOtpDetails.MobileNo, mobileOtpDetails.OTP);
return(true);
}
catch (Exception Ex)
{
string msg = Ex.ToString();
transaction.Rollback();
return(false);
}
}
}
}
public string AddCart(BikeInfoById bikeInfoById)
{
using (var db = new ObickeEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
var alreadyExists = db.AddToCarts.Where(a => a.SecretToken == bikeInfoById.SecretToken && a.BikeId == bikeInfoById.BikeId).FirstOrDefault();
if (alreadyExists != null)
{
return("Already added in cart");
}
var count = db.AddToCarts.Where(a => a.SecretToken == bikeInfoById.SecretToken).Count();
if (count < 2)
{
AddToCart addToCart = new AddToCart()
{
BikeId = bikeInfoById.BikeId,
SecretToken = bikeInfoById.SecretToken,
InitiatedThrough = "Mobile",
CreatedDateTime = DateTime.Now,
ModifiedDateTime = DateTime.Now
};
db.AddToCarts.Add(addToCart);
db.SaveChanges();
transaction.Commit();
return("Success");
}
else
{
return("Sorry, you can't add more than 2 bikes");
}
}
catch (Exception Ex)
{
string msg = Ex.ToString();
transaction.Rollback();
return(Ex.Message);
}
}
}
}
public List <BikeInformation> BikeInfoByIds(List <BikeInfoByIds> bikeInfoByIds)
{
var bikeInformation = new List <BikeInformation>();
using (var db = new ObickeEntities())
{
foreach (var item in bikeInfoByIds)
{
int newBikeId = Convert.ToInt32(item.BikeId);
var bikeInfo = db.BikeInformations.Where(a => a.BikeId == newBikeId).FirstOrDefault();
if (bikeInfo != null)
{
bikeInformation.Add(bikeInfo);
bikeInformation.ForEach(a => a.ImageDetails.Where(x => x.BikeId == a.BikeId));
}
}
}
return(bikeInformation);
}
public bool UpdatePostPaymentDetails(PaymentModule transactionDetail)
{
using (var db = new ObickeEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
//if OrderId is already exists, update the other inputs
var existsModel = db.TransactionDetails.Where(a => a.OrderId == transactionDetail.OrderId).FirstOrDefault();
if (existsModel != null)
{
existsModel.BankName = transactionDetail.BankName;
existsModel.BankTxnId = transactionDetail.BankTxnId;
existsModel.Currency = transactionDetail.Currency;
existsModel.GatewayName = transactionDetail.GatewayName;
existsModel.IsCompleted = transactionDetail.IsCompleted;
existsModel.PaymentCompletedDateTime = DateTime.Now;
existsModel.PaymentMode = transactionDetail.PaymentMode;
existsModel.ResponseCode = transactionDetail.ResponseCode;
existsModel.ResponseMsg = transactionDetail.ResponseMsg;
existsModel.TxnAmount = transactionDetail.TxnAmount;
existsModel.TxnDate = DateTime.Now;
existsModel.TxnId = transactionDetail.TxnId;
existsModel.TxnStatus = transactionDetail.TxnStatus;
db.SaveChanges();
}
transaction.Commit();
return(true);
}
catch (Exception Ex)
{
string msg = Ex.ToString();
transaction.Rollback();
return(false);
}
}
}
}
public Pager BikeListPager(int pageNo, int pageSize)
{
var pager = new Pager();
var bikeInformation = new List <BikeInformation>();
using (var db = new ObickeEntities())
{
var totalRecord = db.BikeInformations.Count();
if (totalRecord > 0)
{
// calculate total, start and end pages
var totalPages = (int)Math.Ceiling((decimal)totalRecord / (decimal)pageSize);
var currentPage = pageNo != null ? (int)pageNo : 1;
var startPage = currentPage - 5;
var endPage = currentPage + 4;
if (startPage <= 0)
{
endPage -= (startPage - 1);
startPage = 1;
}
if (endPage > totalPages)
{
endPage = totalPages;
if (endPage > 10)
{
startPage = endPage - 9;
}
}
pager.TotalItems = totalRecord;
pager.CurrentPage = currentPage;
pager.PageSize = pageSize;
pager.TotalPages = totalPages;
pager.StartPage = startPage;
pager.EndPage = endPage;
}
return(pager);
}
}
public CoreBikeInformation GetBikInfo(int?id)
{
CoreBikeInformation BikeResult = new CoreBikeInformation();
List <CoreImagedetails> imagedetails = new List <CoreImagedetails>();
using (var db = new ObickeEntities())
{
var Bikeinfo = db.stpGetBikedetailsInfo(id).ToList();
if (Bikeinfo != null && Bikeinfo.Count > 0)
{
var BikeInformation = Bikeinfo.FirstOrDefault();
BikeResult = new CoreBikeInformation()
{
BikeId = BikeInformation.BikeId,
BikeBrand = BikeInformation.BikeBrand,
BikeDescription = BikeInformation.BikeDescription,
BikeKmDriven = BikeInformation.BikeKmDriven,
BikeModel = Convert.ToString(BikeInformation.BikeModel),
BikeRegistrationYear = BikeInformation.BikeRegistrationYear,
BikePrice = BikeInformation.BikePrice
};
foreach (var item in Bikeinfo)
{
CoreImagedetails imgRes = new CoreImagedetails()
{
Bikeid = BikeInformation.BikeId,
Imagepath = baseUrl + item.ImgPath.Remove(0, 1)
};
imagedetails.Add(imgRes);
}
BikeResult.Imagepath = imagedetails;
}
}
return(BikeResult);
}
public string SaveUserDetails(UserDetails userDetails)
{
using (var db = new ObickeEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
var IsAlreadyExists = db.UserDetails.Where(a => a.SecretToken == userDetails.SecretToken).FirstOrDefault();
if (IsAlreadyExists != null)
{
IsAlreadyExists.Fullname = userDetails.FullName;
IsAlreadyExists.UserEmailId = userDetails.UserEmailId;
IsAlreadyExists.MobileNo = userDetails.MobileNo;
IsAlreadyExists.CurrentLocation = userDetails.Address;
IsAlreadyExists.AddressType = userDetails.AddressType;
IsAlreadyExists.LandMark = userDetails.LandMark;
IsAlreadyExists.TimeFrom = Convert.ToInt32(userDetails.TimeFrom);
IsAlreadyExists.TimeTo = Convert.ToInt32(userDetails.TimeTo);
IsAlreadyExists.AMPM = userDetails.AMPM;
IsAlreadyExists.City = userDetails.City;
IsAlreadyExists.Pincode = userDetails.Pincode;
IsAlreadyExists.ModifiedDateTime = DateTime.Now;
db.SaveChanges();
}
else
{
UserDetail userD = new UserDetail()
{
Fullname = userDetails.FullName,
UserEmailId = userDetails.UserEmailId,
MobileNo = userDetails.MobileNo,
SecretToken = userDetails.SecretToken,
CurrentLocation = userDetails.Address,
AddressType = userDetails.AddressType,
LandMark = userDetails.LandMark,
IsVerified = true,
IsActive = true,
TimeFrom = Convert.ToInt32(userDetails.TimeFrom),
TimeTo = Convert.ToInt32(userDetails.TimeTo),
AMPM = userDetails.AMPM,
City = userDetails.City,
Pincode = userDetails.Pincode,
CreatedDateTime = DateTime.Now,
ModifiedDateTime = DateTime.Now
};
db.UserDetails.Add(userD);
db.SaveChanges();
}
var userCartDetailsCount = db.CartDetails.Where(a => a.SecretToken == userDetails.SecretToken).Count();
if (userCartDetailsCount != 0)
{
var alreadyExists = db.CartDetails.Where(a => a.SecretToken == userDetails.SecretToken).ToList();
db.CartDetails.RemoveRange(alreadyExists);
db.SaveChanges();
}
foreach (var bikeId in userDetails.BikecartlistIds)
{
var cartD = new CartDetail()
{
BikeId = bikeId.BikeId,
SecretToken = userDetails.SecretToken,
RequestGeneratedBy = "mobile",
CreatedDateTime = DateTime.Now,
ModifiedDateTime = DateTime.Now
};
db.CartDetails.Add(cartD);
db.SaveChanges();
}
transaction.Commit();
return("Success");
}
catch (Exception Ex)
{
string msg = Ex.ToString();
transaction.Rollback();
return(msg);
}
}
}
}
public bool SavePrePaymentDetails(PaymentModule transactionDetail)
{
using (var db = new ObickeEntities())
{
using (var transaction = db.Database.BeginTransaction())
{
try
{
//if OrderId is already exists, update the other inputs
var existsModel = db.TransactionDetails.Where(a => a.OrderId == transactionDetail.OrderId).FirstOrDefault();
if (existsModel != null)
{
existsModel.BankName = transactionDetail.BankName;
existsModel.BankTxnId = transactionDetail.BankTxnId;
existsModel.Currency = transactionDetail.Currency;
existsModel.CustomerId = transactionDetail.CustomerId;
existsModel.EmailId = transactionDetail.EmailId;
existsModel.GatewayName = transactionDetail.GatewayName;
existsModel.IsCompleted = transactionDetail.IsCompleted;
existsModel.MobileNo = transactionDetail.MobileNo;
existsModel.PaymentCompletedDateTime = DateTime.Now;
existsModel.PaymentInitiatedDateTime = DateTime.Now;
existsModel.PaymentMode = transactionDetail.PaymentMode;
existsModel.ResponseCode = transactionDetail.ResponseCode;
existsModel.ResponseMsg = transactionDetail.ResponseMsg;
existsModel.TxnAmount = transactionDetail.TxnAmount;
existsModel.TxnDate = DateTime.Now;
existsModel.TxnId = transactionDetail.TxnId;
existsModel.TxnStatus = transactionDetail.TxnStatus;
existsModel.UserName = transactionDetail.UserName;
db.SaveChanges();
}
else
{
//Save new entry
var transactionsModel = new TransactionDetail()
{
BankName = transactionDetail.BankName,
BankTxnId = transactionDetail.BankTxnId,
Currency = transactionDetail.Currency,
CustomerId = transactionDetail.CustomerId,
EmailId = transactionDetail.EmailId,
GatewayName = transactionDetail.GatewayName,
IsCompleted = transactionDetail.IsCompleted,
MobileNo = transactionDetail.MobileNo,
OrderId = transactionDetail.OrderId,
PaymentCompletedDateTime = DateTime.Now,
PaymentInitiatedDateTime = DateTime.Now,
PaymentMode = transactionDetail.PaymentMode,
ResponseCode = transactionDetail.ResponseCode,
ResponseMsg = transactionDetail.ResponseMsg,
TxnAmount = transactionDetail.TxnAmount,
TxnDate = DateTime.Now,
TxnId = transactionDetail.TxnId,
TxnStatus = transactionDetail.TxnStatus,
UserName = transactionDetail.UserName
};
db.TransactionDetails.Add(transactionsModel);
db.SaveChanges();
}
transaction.Commit();
return(true);
}
catch (Exception Ex)
{
string msg = Ex.ToString();
transaction.Rollback();
return(false);
}
}
}
}
