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