public int UpdateUserDefaultAddress(UserAddress objuser)
{
int id = 0;
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_UpdateUserDefaultAddress";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", objuser.Id < 0 ? 0 : objuser.Id);
cmd.Parameters.AddWithValue("@UserId", objuser.UserId);
id = cmd.ExecuteNonQuery();
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(id);
}
public int UpdateUserPassword(UserModel objuser)
{
int Result = 0;
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_UpdateUserPassword";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@OldPassword", objuser.OldPassword);
cmd.Parameters.AddWithValue("@NewPassword", objuser.Password);
cmd.Parameters.AddWithValue("@UserId", objuser.Id);
Result = cmd.ExecuteNonQuery();
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(Result);
}
public int AddUpdateUserKYCDetails(UserKYCDetails objuser)
{
int id = 0;
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_AddUpdateUserKYCDetails";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", objuser.Id < 0 ? 0 : objuser.Id);
cmd.Parameters.AddWithValue("@NameAsPerID", objuser.NameAsPerID);
cmd.Parameters.AddWithValue("@DocumentType", objuser.DocumentType);
cmd.Parameters.AddWithValue("@DocumentNumber", objuser.DocumentNumber);
cmd.Parameters.AddWithValue("@CreatedBy", objuser.CreatedBy);
id = cmd.ExecuteNonQuery();
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(id);
}
public int ChangePassword(LoginRequestModel objectentity)
{
int Result = 0;
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_UpdatePassword";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PhoneNo", objectentity.UserName);
cmd.Parameters.AddWithValue("@Password", objectentity.Password);
cmd.ExecuteNonQuery();
Result = 1;
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(Result);
}
public int DeleteCropList(CropDetailsModel model)
{
int id = 0;
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_DeleteCropList";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CropListId", model.Id);
cmd.Parameters.AddWithValue("@UserId", model.ModifiedBy);
cmd.ExecuteNonQuery();
id = 1;
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(id);
}
public int AddDairyLoanDetails(DairyLoanModel model)
{
int Id = 0;
try
{
using (SqlConnection conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_AddDairyLoanDetails";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@LoanAmount", model.LoanAmount);
cmd.Parameters.AddWithValue("@LoanTenure", model.LoanTenure);
cmd.Parameters.AddWithValue("@RateOfInterest", model.RateOfInterest);
cmd.Parameters.AddWithValue("@CreatedBy", model.CreatedBy);
cmd.Parameters.Add("@Result", SqlDbType.Int).Direction = ParameterDirection.Output;
int i = cmd.ExecuteNonQuery();
Id = Convert.ToInt32(cmd.Parameters["@Result"].Value);
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(Id);
}
public int CheckPhoneNoExists(string PhoneNo)
{
int Result = 0;
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_CheckPhoneNoExists";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PhoneNo", PhoneNo);
cmd.Parameters.Add("@Result", SqlDbType.Int).Direction = ParameterDirection.Output;
int i = cmd.ExecuteNonQuery();
Result = Convert.ToInt32(cmd.Parameters["@Result"].Value);
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(Result);
}
public int AddCropPerticular(CropPerticularModel model)
{
int id = 0;
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_AddCropPerticular";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CropId", model.CropId);
cmd.Parameters.AddWithValue("@Transportation", model.Transportation);
cmd.Parameters.AddWithValue("@LabourCharges", model.LabourCharges);
cmd.Parameters.AddWithValue("@Loading", model.Loading);
cmd.Parameters.AddWithValue("@Gunnies", model.Gunnies);
cmd.Parameters.AddWithValue("@OtherCharges", model.OtherCharges);
cmd.Parameters.AddWithValue("@UserId", model.CreatedBy);
cmd.ExecuteNonQuery();
id = 1;
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(id);
}
public int AddUpdateUserBankDetails(UserBankDetails objuser)
{
int id = 0;
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_AddUpdateUserBankDetails";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", objuser.Id < 0 ? 0 : objuser.Id);
cmd.Parameters.AddWithValue("@AccountHolderName", objuser.AccountHolderName);
cmd.Parameters.AddWithValue("@BankName", objuser.BankName);
cmd.Parameters.AddWithValue("@AccountNumber", objuser.AccountNumber);
cmd.Parameters.AddWithValue("@IFSCCode", objuser.IFSCCode);
cmd.Parameters.AddWithValue("@CreatedBy", objuser.CreatedBy);
id = cmd.ExecuteNonQuery();
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(id);
}
public IList <TractorLoanModel> GetTractorLoanList(int UserId)
{
IList <TractorLoanModel> listitems = new List <TractorLoanModel>();
try
{
using (SqlConnection conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (SqlCommand cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_GetTractorLoanRequested";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", UserId);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
TractorLoanModel model = new TractorLoanModel();
model.LoanAmount = Convert.ToString(reader["LoanAmount"]);
model.LoanTenure = Convert.ToString(reader["LoanTenure"]);
model.RateOfInterest = Convert.ToString(reader["RateOfInterest"]);
model.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]);
listitems.Add(model);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(listitems);
}
public string CancellOrder(OrderDetailsModel request)
{
string Message = "";
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_CancellOrder";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FarmerId", request.FarmerId);
cmd.Parameters.AddWithValue("@OrderId", request.OrderId);
cmd.ExecuteNonQuery();
Message = "Order Cancelled successfully";
}
}
}
catch (Exception ex)
{
throw ex;
}
return(Message);
}
public int AddUpdateTransportationDetails(TransportationDetails objuser)
{
int id = 0;
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_AddUpdateTransportationDetails";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", objuser.Id < 0 ? 0 : objuser.Id);
cmd.Parameters.AddWithValue("@OwnerName", objuser.OwnerName);
cmd.Parameters.AddWithValue("@TransportationType", objuser.TransportationType);
cmd.Parameters.AddWithValue("@VehicleNumber", objuser.VehicleNumber);
cmd.Parameters.AddWithValue("@CreatedBy", objuser.CreatedBy);
id = cmd.ExecuteNonQuery();
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(id);
}
public int VerifyOTPofNewUser(UserModel objuser)
{
int Result = 0;
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_UpdateOTPVerifiedforUser";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PhoneNo", objuser.PhoneNo);
cmd.Parameters.Add("@Status", SqlDbType.Int).Direction = ParameterDirection.Output;
int i = cmd.ExecuteNonQuery();
Result = Convert.ToInt32(cmd.Parameters["@Status"].Value);
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(Result);
}
public IList <BankMasterModel> GetBankLists()
{
IList <BankMasterModel> BankDetails = new List <BankMasterModel>();
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_GetBankLists";
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
BankMasterModel model = new BankMasterModel();
model.Id = Convert.ToInt32(reader["Id"]);
model.BankName = Convert.ToString(reader["BankName"]);
model.IsActive = Convert.ToBoolean(reader["IsActive"]);
BankDetails.Add(model);
}
}
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(BankDetails);
}
public int DeleteTransportationDetails(TransportationDetails objTransportation)
{
int id = 0;
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_DeleteTransportation";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", objTransportation.Id < 0 ? 0 : objTransportation.Id);
cmd.Parameters.AddWithValue("@UserId", objTransportation.CreatedBy);
cmd.ExecuteNonQuery();
id = 1;
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(id);
}
public UserModel ValidateRefferalCode(string RefferalCode)
{
UserModel model = new UserModel();
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_ValidateRefferalCode";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@RefferalCode", RefferalCode);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
model.IsReferValidated = Convert.ToBoolean(reader["IsReferValidated"]);
}
}
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(model);
}
public IList <OrderDetailsModel> GetAllOrders(OrderDetailsModel orderModel)
{
IList <OrderDetailsModel> Items = new List <OrderDetailsModel>();
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_GetAllOrdersByFarmer";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@FarmerId", orderModel.FarmerId);
cmd.Parameters.AddWithValue("@FromDate", (orderModel.FromDate == null || orderModel.FromDate == new DateTime()) ? SqlDateTime.MinValue.Value : orderModel.FromDate);
cmd.Parameters.AddWithValue("@ToDate", (orderModel.ToDate == null || orderModel.ToDate == new DateTime()) ? SqlDateTime.MaxValue.Value.AddDays(-1) : orderModel.ToDate);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
OrderDetailsModel model = new OrderDetailsModel();
model.OrderId = Convert.ToInt32(reader["Id"]);
model.CartItemId = Convert.ToInt32(reader["CartItemId"]);
model.CropListId = Convert.ToInt32(reader["CropListId"]);
model.FarmerId = Convert.ToInt32(reader["FarmerId"]);
model.UserId = Convert.ToInt32(reader["UserId"]);
model.Quantity = Convert.ToInt32(reader["Quantity"]);
model.Price = Convert.ToString(reader["Price"]);
model.CropIcon = Convert.ToString(reader["CropIcon"]);
model.CropName = Convert.ToString(reader["CropName"]);
model.Variety = Convert.ToString(reader["Variety"]);
model.UoM = Convert.ToString(reader["UoM"]);
model.CustomerName = Convert.ToString(reader["FullName"]);
model.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]);
model.IsAccepted = string.IsNullOrEmpty(Convert.ToString(reader["IsAccepted"])) ? false : Convert.ToBoolean(reader["IsAccepted"]);
model.IsCancelled = string.IsNullOrEmpty(Convert.ToString(reader["IsCancelled"])) ? false : Convert.ToBoolean(reader["IsCancelled"]);
model.CancelledBy = string.IsNullOrEmpty(Convert.ToString(reader["CancelledBy"])) ? "" : Convert.ToString(reader["CancelledBy"]);
model.IsDelivered = string.IsNullOrEmpty(Convert.ToString(reader["IsDelivered"])) ? false : Convert.ToBoolean(reader["IsDelivered"]);
Items.Add(model);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(Items);
}
public IList <UserAddress> GetAddressByUser(int UserId, string PickUpFrom = "")
{
IList <UserAddress> AddressDetails = new List <UserAddress>();
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_GetUserAddressByUser";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", UserId);
cmd.Parameters.AddWithValue("@PickUpFrom", PickUpFrom);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
UserAddress model = new UserAddress();
model.Id = Convert.ToInt32(reader["Id"]);
model.Name = Convert.ToString(reader["Name"]);
model.MobileNo = Convert.ToString(reader["mobileNo"]);
model.StreeAddress = Convert.ToString(reader["StreetAdress"]);
model.StreeAddress1 = Convert.ToString(reader["StreetAddress1"]);
model.City = Convert.ToString(reader["City"]);
model.LandMark = Convert.ToString(reader["LandMark"]);
model.State = Convert.ToString(reader["State"]);
model.District = Convert.ToString(reader["District"]);
model.Taluk = Convert.ToString(reader["Taluk"]);
model.Hoblie = Convert.ToString(reader["Hobli"]);
model.Village = Convert.ToString(reader["Village"]);
model.Pincode = Convert.ToString(reader["Pincode"]);
model.PickUpFrom = Convert.ToString(reader["PickUpLocation"]);
model.IsDefaultAddress = string.IsNullOrEmpty(Convert.ToString(reader["IsDefaultAddress"])) ? false : Convert.ToBoolean(reader["IsDefaultAddress"]);
AddressDetails.Add(model);
}
}
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(AddressDetails);
}
public IList <CropDetailsModel> GetCropDetails(CropDetailsModel request)
{
IList <CropDetailsModel> Crops = new List <CropDetailsModel>();
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_GetCropListDetails";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", request.CreatedBy);
cmd.Parameters.AddWithValue("@CropId", request.CropId);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
CropDetailsModel model = new CropDetailsModel();
model.Id = Convert.ToInt32(reader["Id"]);
model.CropId = Convert.ToInt32(reader["CropId"]);
model.Variety = Convert.ToString(reader["Variety"]);
model.Grade = Convert.ToString(reader["Grade"]);
model.UoM = Convert.ToString(reader["UoM"]);
model.Quantity = Convert.ToInt32(reader["Quantity"]);
model.SellType = Convert.ToInt32(reader["SellType"]);
model.FarmerId = Convert.ToInt32(reader["FarmerId"]);
model.Price = Convert.ToString(reader["Price"]);
model.PickupLocation = Convert.ToString(reader["PickupLocation"]);
model.Latitude = Convert.ToString(reader["Latitude"]);
model.Longitude = Convert.ToString(reader["Longitude"]);
model.Location = Convert.ToString(reader["Location"]);
Crops.Add(model);
}
}
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(Crops);
}
public int AddCropDetails(CropDetailsModel model)
{
int id = 0;
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_AddCropListDetails";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@CropId", model.CropId);
cmd.Parameters.AddWithValue("@Variety", model.Variety);
cmd.Parameters.AddWithValue("@Grade", model.Grade);
cmd.Parameters.AddWithValue("@UoM", model.UoM);
cmd.Parameters.AddWithValue("@Quantity", model.Quantity);
cmd.Parameters.AddWithValue("@SellType", model.SellType);
cmd.Parameters.AddWithValue("@Price", model.Price);
cmd.Parameters.AddWithValue("@CreatedBy", model.CreatedBy);
cmd.Parameters.AddWithValue("@PickupLocation", model.PickupLocation);
cmd.Parameters.AddWithValue("@Location", model.Location);
cmd.Parameters.AddWithValue("@Latitude", model.Latitude);
cmd.Parameters.AddWithValue("@Longitude", model.Longitude);
cmd.Parameters.AddWithValue("@StateId", model.StateId);
cmd.Parameters.AddWithValue("@DistID", model.DistId);
cmd.Parameters.AddWithValue("@TalukID", model.TalukId);
cmd.Parameters.AddWithValue("@HobliID", model.HobliId);
cmd.Parameters.AddWithValue("@VillageID", model.VillageId);
cmd.Parameters.AddWithValue("@AddressId", model.AddressId);
cmd.ExecuteNonQuery();
id = 1;
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(id);
}
public UserModel GetFarmerDetails(int UserId)
{
UserModel model = new UserModel();
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_GetFarmerDetails";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", UserId);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
model.Id = Convert.ToInt32(reader["Id"]);
model.FullName = Convert.ToString(reader["FullName"]);
model.EmailId = Convert.ToString(reader["EmailId"]);
model.PhoneNo = Convert.ToString(reader["PhoneNo"]);
model.MaskedPhoneNo = Utility.MaskData(Convert.ToString(reader["PhoneNo"]));
model.ProfilePic = Convert.ToString(reader["ProfilePic"]);
model.DeviceId = Convert.ToString(reader["DeviceId"]);
model.DeviceType = Convert.ToString(reader["DeviceType"]);
model.RefferalCode = Convert.ToString(reader["RefferalCode"]);
model.NotificationTypeId = Convert.ToString(reader["NotificationTypeId"]);
model.IsFarmer = Convert.ToBoolean(reader["IsFarmer"]);
}
}
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(model);
}
public int AddUserAddress(UserAddress objuser)
{
int id = 0;
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_AddUpdateUserAddress";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Id", objuser.Id < 0 ? 0 : objuser.Id);
cmd.Parameters.AddWithValue("@FullName", objuser.Name);
cmd.Parameters.AddWithValue("@MobileNo", objuser.MobileNo);
cmd.Parameters.AddWithValue("@StreetAddress", objuser.StreeAddress);
cmd.Parameters.AddWithValue("@StreetAddress1", objuser.StreeAddress1);
cmd.Parameters.AddWithValue("@City", objuser.City);
cmd.Parameters.AddWithValue("@LandMark", objuser.LandMark);
cmd.Parameters.AddWithValue("@StateId", objuser.StateId);
cmd.Parameters.AddWithValue("@Distict", objuser.DistrictId);
cmd.Parameters.AddWithValue("@TalukId", objuser.TalukId);
cmd.Parameters.AddWithValue("@HobliId", objuser.HobliId);
cmd.Parameters.AddWithValue("@VillageId", objuser.VillageId);
cmd.Parameters.AddWithValue("@PinCode", objuser.Pincode);
cmd.Parameters.AddWithValue("@UserId", objuser.UserId);
cmd.Parameters.AddWithValue("@PickUpLocation", objuser.PickUpFrom);
cmd.Parameters.Add("@Result", SqlDbType.Int).Direction = ParameterDirection.Output;
int i = cmd.ExecuteNonQuery();
id = Convert.ToInt32(cmd.Parameters["@Result"].Value);
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(id);
}
public IList <TransactionModel> GetTransactionsByUser(TransactionModel obj)
{
IList <TransactionModel> Items = new List <TransactionModel>();
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_GetTransactionsByUser";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", obj.CreatedBy);
cmd.Parameters.AddWithValue("@FromDate", (obj.FromDate == null || obj.FromDate == new DateTime()) ? SqlDateTime.MinValue.Value : obj.FromDate);
cmd.Parameters.AddWithValue("@ToDate", (obj.ToDate == null || obj.ToDate == new DateTime()) ? SqlDateTime.MaxValue.Value.AddDays(-1) : obj.ToDate);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
TransactionModel model = new TransactionModel();
model.Id = Convert.ToInt32(reader["Id"]);
model.Amount = Convert.ToDecimal(reader["Amount"]);
model.Description = Convert.ToString(reader["Description"]);
model.TransactionType = Convert.ToString(reader["TransactionType"]);
model.ReferenceId = Convert.ToInt32(reader["ReferenceId"]);
model.Status = Convert.ToBoolean(reader["Status"]);
model.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]);
model.CreatedBy = Convert.ToInt32(reader["CreatedBy"]);
Items.Add(model);
}
}
}
}
}
catch (Exception ex)
{
throw ex;
}
return(Items);
}
public CropPerticularModel GetCropPerticular(CropPerticularModel request)
{
CropPerticularModel model = new CropPerticularModel();
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_GetCropPerticularDetails";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", request.CreatedBy);
cmd.Parameters.AddWithValue("@CropId", request.CropId);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
model.Id = Convert.ToInt32(reader["Id"]);
model.CropId = Convert.ToInt32(reader["CropId"]);
model.Transportation = Convert.ToString(reader["Transportation"]);
model.LabourCharges = Convert.ToString(reader["LabourCharges"]);
model.Loading = Convert.ToString(reader["Loading"]);
model.Gunnies = Convert.ToString(reader["Gunnies"]);
model.OtherCharges = Convert.ToString(reader["OtherCharges"]);
model.CropName = Convert.ToString(reader["CropName"]);
model.Catagory = Convert.ToString(reader["Catagory"]);
}
}
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(model);
}
public int AddUser(UserModel objuser)
{
int id = 0;
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_AddnewUser";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@PhoneNo", objuser.PhoneNo);
cmd.Parameters.AddWithValue("@Password", objuser.Password);
cmd.Parameters.AddWithValue("@DeviceId", objuser.DeviceId);
cmd.Parameters.AddWithValue("@DeviceType", objuser.DeviceType);
cmd.Parameters.AddWithValue("@IsOTPVerified", false);
cmd.Parameters.AddWithValue("@FullName", objuser.FullName);
cmd.Parameters.AddWithValue("@EmailId", objuser.EmailId);
cmd.Parameters.AddWithValue("@CountryId", objuser.CountryId);
cmd.Parameters.AddWithValue("@StateId", objuser.StateId);
cmd.Parameters.AddWithValue("@DistrictId", objuser.DistrictId);
cmd.Parameters.AddWithValue("@TalukId", objuser.TalukId);
cmd.Parameters.AddWithValue("@HobliId", objuser.HobliId);
cmd.Parameters.AddWithValue("@RefferalCode", objuser.RefferalCode);
cmd.Parameters.AddWithValue("@IsReferValidated", objuser.IsReferValidated);
cmd.Parameters.Add("@UserId", SqlDbType.Int).Direction = ParameterDirection.Output;
int i = cmd.ExecuteNonQuery();
id = Convert.ToInt32(cmd.Parameters["@UserId"].Value);
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(id);
}
public AccessModel GetAccessContentByLangCode(string LanguageCode, string Type)
{
AccessModel response = new AccessModel();
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_GetAccessContentByLanguage";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@LangCode", LanguageCode);
cmd.Parameters.AddWithValue("@Type", Type);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
response.Id = Convert.ToInt32(reader["Id"]);
response.LangCode = Convert.ToString(reader["LangCode"]);
response.Description = Convert.ToString(reader["Description"]);
response.Image = Convert.ToString(reader["Image"]);
response.Type = Convert.ToString(reader["Type"]);
response.Action = Convert.ToString(reader["Action"]);
response.Title = Convert.ToString(reader["Title"]);
response.ClickCount = Convert.ToInt32(reader["ClickCount"]);
}
}
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(response);
}
public IList <UserBankDetails> GetBankDetailsByUser(int UserId)
{
IList <UserBankDetails> BankDetails = new List <UserBankDetails>();
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_GetBankDetailsByUser";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@UserId", UserId);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
UserBankDetails model = new UserBankDetails();
model.Id = Convert.ToInt32(reader["Id"]);
model.AccountHolderName = Convert.ToString(reader["AccountHolderName"]);
model.BankName = Convert.ToString(reader["BankName"]);
model.AccountNumber = Convert.ToString(reader["AccountNumber"]);
model.IFSCCode = Convert.ToString(reader["IFSCCode"]);
model.CreatedBy = Convert.ToInt32(reader["CreatedBy"]);
model.UserId = Convert.ToInt32(reader["UserId"]);
BankDetails.Add(model);
}
}
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(BankDetails);
}
public void UpdateRegisterOTPCountForUser(string PhoneNo, bool IsNew)
{
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_UpdateRegisterOTPCountForUser";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Username", PhoneNo);
cmd.Parameters.AddWithValue("@Isnew", IsNew);
cmd.ExecuteNonQuery();
}
}
}
catch (Exception ex)
{
throw ex;
}
}
public IList <UserModel> GetCustomersList()
{
IList <UserModel> CustomersList = new List <UserModel>();
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_GetCustomersRegistered";
cmd.CommandType = CommandType.StoredProcedure;
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
UserModel model = new UserModel();
model.Id = Convert.ToInt32(reader["Id"]);
model.FullName = Convert.ToString(reader["FullName"]);
model.EmailId = Convert.ToString(reader["EmailId"]);
model.PhoneNo = Convert.ToString(reader["PhoneNo"]);
model.State = Convert.ToString(reader["State"]);
model.ProfilePic = Convert.ToString(reader["ProfilePic"]);
CustomersList.Add(model);
}
}
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(CustomersList);
}
public LoginResponseModel GetRegisterOTPCountForUser(string PhoneNo)
{
LoginResponseModel response = new LoginResponseModel();
try
{
using (var conn = new SqlConnection(ContexDetails.Connectiondetails()))
{
conn.Open();
using (var cmd = conn.CreateCommand())
{
cmd.CommandText = "sp_GetRegisterOTPCountwithDate";
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@Username", PhoneNo);
using (SqlDataReader reader = cmd.ExecuteReader())
{
while (reader.Read())
{
response.UserId = Convert.ToInt32(reader["Id"]);
response.UserName = Convert.ToString(reader["UserName"]);
response.RegisterOTPSentCount = Convert.ToInt32(reader["RegisterOTPSentCount"]);
if (reader["RegisterOTPSentDate"] != DBNull.Value)
{
response.RegisterOTPSentDate = Convert.ToDateTime(reader["RegisterOTPSentDate"]);
}
}
}
}
conn.Close();
}
}
catch (Exception ex)
{
throw ex;
}
return(response);
}