public ServiceRes GetGenders()
{
ServiceRes <List <Genders> > serviceRes = new ServiceRes <List <Genders> >();
try
{
List <Genders> genders = new List <Genders>();
DataTable dtCities = SqlHelper.GetTableFromSP("Usp_GetGender");
foreach (DataRow row in dtCities.Rows)
{
Genders gender = new Genders
{
GenderId = Convert.ToInt32(row["GenderId"]),
Gender = Convert.ToString(row["Gender"])
};
genders.Add(gender);
}
serviceRes.Data = genders;
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "";
}
catch (Exception ex)
{
LogManager.WriteLog(ex, SeverityLevel.Critical);
serviceRes.Data = null;
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "500";
serviceRes.ReturnMsg = "Something went wrong";
}
return(serviceRes);
}
public ServiceRes UpdateCategory(int id, string name)
{
ServiceRes serviceRes = new ServiceRes();
try
{
SqlParameter[] parameter = new SqlParameter[3];
parameter[0] = new SqlParameter {
ParameterName = "@id", Value = id
};
parameter[0] = new SqlParameter {
ParameterName = "@id", Value = name
};
parameter[1] = new SqlParameter {
ParameterName = "@flag", Value = "U"
};
int ret = SqlHelper.ExecuteNonQuery("Usp_Admin_CatgoryMaster", parameter);
if (ret > 0)
{
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Updated";
}
}
catch (Exception ex)
{
LogManager.WriteLog(ex);
}
return(serviceRes);
}
public ServiceRes UnlockUserAccount(User objUser)
{
ServiceRes serviceRes = new ServiceRes();
try
{
LoginDetails loginDetails = new LoginDetails()
{
Username = objUser.MobileNumber,
IsLocked = true,
LoginAttempts = 3
};
var returnValue = UpdateLoginDetails(loginDetails);
if (returnValue == 1)
{
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Login details updated";
}
else
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "400";
serviceRes.ReturnMsg = "Login details not updated";
}
}
catch (Exception ex)
{
LogManager.WriteLog(ex, SeverityLevel.Important);
}
return(serviceRes);
}
public ServiceRes GetSubCategoryMaster(int categoryId)
{
ServiceRes <List <ProductSubCategory> > serviceRes = new ServiceRes <List <ProductSubCategory> >();
try
{
List <ProductSubCategory> subCategories = new List <ProductSubCategory>();
SqlParameter[] sqlParameter = new SqlParameter[1];
sqlParameter[0] = new SqlParameter {
ParameterName = "@categoryId", Value = categoryId
};
DataTable dtCities = SqlHelper.GetTableFromSP("Usp_GetSubCategory", sqlParameter);
foreach (DataRow row in dtCities.Rows)
{
ProductSubCategory businessCategory = new ProductSubCategory
{
SubCategoryId = Convert.ToInt32(row["Product_SubCategoryId"]),
Name = Convert.ToString(row["SubCategory_Name"])
};
subCategories.Add(businessCategory);
}
serviceRes.Data = subCategories;
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Sub Category master";
}
catch (Exception ex)
{
LogManager.WriteLog(ex);
}
return(serviceRes);
}
public ServiceRes AddCategory(string name)
{
ServiceRes serviceRes = new ServiceRes();
try
{
SqlParameter[] parameter = new SqlParameter[2];
parameter[0] = new SqlParameter {
ParameterName = "@value", Value = name
};
parameter[1] = new SqlParameter {
ParameterName = "@flag", Value = "A"
};
int ret = SqlHelper.ExecuteNonQuery("Usp_Admin_CatgoryMaster", parameter);
if (ret > 0)
{
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Success";
}
else
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "400";
serviceRes.ReturnMsg = "Failed";
}
}
catch (Exception ex)
{
LogManager.WriteLog(ex);
}
return(serviceRes);
}
public ServiceRes GetStates()
{
ServiceRes <List <States> > serviceRes = new ServiceRes <List <States> >();
try
{
List <States> states = new List <States>();
DataTable dtCities = SqlHelper.GetTableFromSP("Usp_GetStates");
foreach (DataRow row in dtCities.Rows)
{
States state = new States
{
StateId = Convert.ToInt32(row["StateId"]),
State = Convert.ToString(row["State"])
};
states.Add(state);
}
serviceRes.Data = states;
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "";
}
catch (Exception ex)
{
LogManager.WriteLog(ex, SeverityLevel.Critical);
serviceRes.Data = null;
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "500";
serviceRes.ReturnMsg = "Something went wrong";
}
return(serviceRes);
}
public ServiceRes Distributor_ConfirmOrder(ConfirmOrder confirmOrder)
{
ServiceRes serviceRes = new ServiceRes();
try
{
if (confirmOrder.Request != null)
{
int retValue = 0;
foreach (var order in confirmOrder.Request)
{
SqlParameter[] sqlParameter = new SqlParameter[5];
sqlParameter[0] = new SqlParameter {
ParameterName = "@MemberId", Value = order.UserId
};
sqlParameter[1] = new SqlParameter {
ParameterName = "@Order_Id", Value = order.OrderId
};
sqlParameter[2] = new SqlParameter {
ParameterName = "@Product_Id", Value = order.ProductId
};
sqlParameter[3] = new SqlParameter {
ParameterName = "@Order_Status", Value = "D"
};
sqlParameter[4] = new SqlParameter {
ParameterName = "@Flag", Value = "OS"
};
retValue = SqlHelper.ExecuteNonQuery("USP_DistributorOrder", sqlParameter);
if (retValue > 0)
{
EmailerRepository emailerRepository = EmailerRepository.GetInstance;
if (emailerRepository.Send(order.EmailAddress))
{
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Success";
}
}
else
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "400";
serviceRes.ReturnMsg = "Failed";
};
}
}
}
catch (Exception ex)
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "400";
serviceRes.ReturnMsg = "Exception occurred.";
LogManager.WriteLog(ex);
}
return(serviceRes);
}
public ServiceRes RecentOrderDetail(RecentReport recentReport)
{
ServiceRes <List <RecentReport> > serviceRes = new ServiceRes <List <RecentReport> >();
try
{
SqlParameter[] sqlParameters = new SqlParameter[3];
sqlParameters[0] = new SqlParameter {
ParameterName = "@MemberId", Value = recentReport.UserId
};
sqlParameters[1] = new SqlParameter {
ParameterName = "@Order_Id", Value = recentReport.OrderId
};
sqlParameters[2] = new SqlParameter {
ParameterName = "@Flag", Value = "OP"
};
var dataTable = SqlHelper.GetTableFromSP("USP_DistributorOrder", sqlParameters);
if (dataTable.Rows.Count > 0)
{
serviceRes.Data = dataTable.AsEnumerable().Select(x => new RecentReport
{
OrderId = x.Field <int>("Order_Id"),
OrderNumber = x.Field <string>("Order_Number"),
OrderDate = x.Field <DateTime>("Order_Date"),
UserId = x.Field <int>("Member_Id"),
ProductId = x.Field <int>("Product_Id"),
OrderQuantity = x.Field <int>("OQty"),
DeliveredQuantity = x.Field <int>("DQty"),
CreatedOn = x.Field <DateTime>("Created_On"),
ProductName = x.Field <string>("ProductName"),
MechantName = x.Field <string>("MerchantName"),
Price = x.Field <decimal>("Price")
}).ToList();
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Success";
}
else
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "400";
serviceRes.ReturnMsg = "failed";
}
}
catch (Exception ex)
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "500";
serviceRes.ReturnMsg = "Exception Occured";
LogManager.WriteLog(ex);
}
return(serviceRes);
}
public ServiceRes ChangePassword(ChangePassword changePassword)
{
ServiceRes serviceRes = new ServiceRes();
try
{
if (!string.IsNullOrEmpty(changePassword.Username))
{
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter {
ParameterName = "@mobileNumber", Value = changePassword.Username
};
var oldPassword = SqlHelper.GetTableFromSP("Usp_GetUserPassword", sqlParameters);
if (_objRepo.Decrypt(Convert.ToString(oldPassword.Rows[0][0])).Equals(changePassword.OldPassword))
{
SqlParameter[] sqlParameter = new SqlParameter[2];
sqlParameter[0] = new SqlParameter {
ParameterName = "@mobileNumber", Value = changePassword.Username
};
sqlParameter[1] = new SqlParameter {
ParameterName = "@newPassword", Value = changePassword.NewPassword
};
var passwordChanged = SqlHelper.ExecuteNonQuery("Usp_UpdatePassword", sqlParameter);
if (passwordChanged == 1)
{
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Your password has been changed successfully";
}
else
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "201";
serviceRes.ReturnMsg = "UnAuthorized attempt";
}
}
else
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "202";
serviceRes.ReturnMsg = "Old password is not correct";
}
}
}
catch (Exception ex)
{
LogManager.WriteLog(ex);
}
return(serviceRes);
}
public ServiceRes ProductByCategories(NearByDistributors nearBy)
{
ServiceRes <List <ProductListByCategory> > serviceRes = new ServiceRes <List <ProductListByCategory> >();
try
{
SqlParameter[] sqlParameters = new SqlParameter[3];
sqlParameters[0] = new SqlParameter {
ParameterName = "@Member_Id", Value = nearBy.UserId
};
sqlParameters[1] = new SqlParameter {
ParameterName = "@Category_Id", Value = nearBy.CategoryId
};
sqlParameters[2] = new SqlParameter {
ParameterName = "@flag", Value = "DPC"
};
DataTable dtProductByCategory = SqlHelper.GetTableFromSP("Usp_Products_Test", sqlParameters);
if (dtProductByCategory.Rows.Count > 0)
{
List <ProductListByCategory> productDetails = dtProductByCategory.AsEnumerable().
Select(x => new ProductListByCategory
{
Price = x.Field <decimal>("Price"),
Specification = x.Field <string>("Specification"),
Quantity = x.Field <int>("Quantity"),
Photos_Url = $"http://escandent.com/{x.Field<string>("Photos_Url")}",
Name = x.Field <string>("Name"),
ProductId = x.Field <int>("Product_Id")
}).ToList();
serviceRes.Data = productDetails;
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Product by Category";
}
else
{
serviceRes.Data = null;
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "400";
serviceRes.ReturnMsg = "";
}
}
catch (Exception ex)
{
LogManager.WriteLog(ex);
}
return(serviceRes);
}
public ServiceRes GetAllRecentOrders(RecentReport recentReport)
{
ServiceRes <List <RecentReport> > serviceRes = new ServiceRes <List <RecentReport> >();
try {
SqlParameter[] sqlParameters = new SqlParameter[2];
sqlParameters[0] = new SqlParameter {
ParameterName = "@MemberId", Value = recentReport.UserId
};
sqlParameters[1] = new SqlParameter {
ParameterName = "@Flag", Value = "OL"
};
var dataTable = SqlHelper.GetTableFromSP("USP_DistributorOrder", sqlParameters);
if (dataTable.Rows.Count > 0)
{
serviceRes.Data = dataTable.AsEnumerable().Select(x => new RecentReport {
OrderId = x.Field <int>("Order_Id"),
OrderNumber = x.Field <string>("Order_Number"),
OrderDate = x.Field <DateTime>("Order_Date"),
UserId = x.Field <int>("Member_Id"),
ProductId = x.Field <int>("Product_Id"),
MechantName = x.Field <string>("MerchantName"),
Locality = x.Field <string>("Locality"),
PinCode = Convert.ToString(x.Field <int>("PinCode")),
EmailAddress = x.Field <string>("Email")
}).ToList();
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Success";
}
else
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "400";
serviceRes.ReturnMsg = "failed";
}
}
catch (Exception ex)
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "500";
serviceRes.ReturnMsg = "Exception Occured";
LogManager.WriteLog(ex);
}
return(serviceRes);
}
public ServiceRes ViewCartItem(Cart cart)
{
ServiceRes <List <ProductListByCategory> > serviceRes = new ServiceRes <List <ProductListByCategory> >();
try
{
SqlParameter[] sqlParameters = new SqlParameter[2];
sqlParameters[0] = new SqlParameter {
ParameterName = "@Member_Id", Value = cart.UserId
};
sqlParameters[1] = new SqlParameter {
ParameterName = "@Flag", Value = "S"
};
DataTable dataTable = SqlHelper.GetTableFromSP("Usp_Cart", sqlParameters);
if (dataTable.Rows.Count > 0)
{
List <ProductListByCategory> productDetails = dataTable.AsEnumerable().
Select(x => new ProductListByCategory
{
Price = x.Field <decimal>("Price"),
Specification = x.Field <string>("Specification"),
Quantity = x.Field <int>("Quantity"),
Photos_Url = $"http://escandent.com/{x.Field<string>("Photos_Url")}",
Name = x.Field <string>("Name"),
ProductId = x.Field <int>("Product_Id"),
UserId = x.Field <int>("Member_Id")
}).ToList();
serviceRes.Data = productDetails;
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Success";
}
else
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "400";
serviceRes.ReturnMsg = "No item in bag";
}
}
catch (Exception ex)
{
LogManager.WriteLog(ex);
}
return(serviceRes);
}
public ServiceRes CategoryListByDistributor(NearByDistributors byDistributors)
{
ServiceRes <List <ProductCategory> > serviceRes = new ServiceRes <List <ProductCategory> >();
try {
SqlParameter[] sqlParameters = new SqlParameter[2];
sqlParameters[0] = new SqlParameter {
ParameterName = "@Member_Id", Value = byDistributors.UserId
};
sqlParameters[1] = new SqlParameter {
ParameterName = "@flag", Value = "CL"
};
DataTable dtByDistributors = SqlHelper.GetTableFromSP("Usp_Products_Test", sqlParameters);
if (dtByDistributors.Rows.Count > 0)
{
List <ProductCategory> productCategories = dtByDistributors.AsEnumerable().
Select(x => new ProductCategory {
CategoryId = x.Field <int>("Product_Category_Id"),
Name = x.Field <string>("Product_Name"),
CompanyName = x.Field <string>("Company_Name"),
Building_Name = x.Field <string>("Building_Name"),
Locality = x.Field <string>("Locality"),
PinCode = Convert.ToInt32(x.Field <int>("PinCode")),
State = x.Field <string>("State"),
City = x.Field <string>("City"),
UserId = x.Field <int>("Member_Id")
}).ToList();
serviceRes.Data = productCategories;
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Category Listing";
}
else
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "400";
serviceRes.ReturnMsg = "Category not found";
}
}
catch (Exception ex)
{
LogManager.WriteLog(ex);
}
return(serviceRes);
}
public ServiceRes ForgetPassword(User user)
{
ServiceRes serviceRes = new ServiceRes();
try {
SqlParameter[] parameter = new SqlParameter[1];
parameter[0] = new SqlParameter {
ParameterName = "@mobileNumber", Value = user.MobileNumber
};
DataTable dataTable = SqlHelper.GetTableFromSP("Usp_GetUserDetails", parameter);
if (dataTable.Rows.Count > 0)
{
string emailAddress = Convert.ToString(dataTable.Rows[0][0]);
string password = this._objRepo.Decrypt(Convert.ToString(dataTable.Rows[0][1]));
if (!string.IsNullOrEmpty(emailAddress))
{
if (this._emailerRepository.Send(emailAddress, password))
{
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Password reset link has been sent to your registered email address.";
}
else
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "400";
serviceRes.ReturnMsg = "Something went wrong";
}
}
}
else
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "404";
serviceRes.ReturnMsg = "Data not found";
}
}
catch (Exception ex)
{
LogManager.WriteLog(ex);
}
return(serviceRes);
}
public ServiceRes AllMessages(Messages messages)
{
ServiceRes <List <Messages> > serviceRes = new ServiceRes <List <Messages> >();
try
{
SqlParameter[] sqlParameter = new SqlParameter[2];
sqlParameter[0] = new SqlParameter {
ParameterName = "@senderId", Value = messages.SenderId
};
sqlParameter[1] = new SqlParameter {
ParameterName = "@flag", Value = "G"
};
var dataTable = SqlHelper.GetTableFromSP("Usp_MessageMaster", sqlParameter);
if (dataTable != null || dataTable.Rows.Count > 0)
{
serviceRes.Data = dataTable.AsEnumerable().Select(x => new Messages {
MessageContent = x.Field <string>("Msg_Description"),
RecieverId = x.Field <int>("Recipent_Id"),
SenderId = x.Field <int>("Sender_Id"),
IsRead = x.Field <bool>("Read_Flag"),
MessageDate = x.Field <DateTime>("Created_On")
}).ToList();
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Success";
}
else
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "400";
serviceRes.ReturnMsg = "Failed";
}
}
catch (Exception ex)
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "500";
serviceRes.ReturnMsg = "Exception occured";
LogManager.WriteLog(ex);
}
return(serviceRes);
}
public ServiceRes AddToCart(Cart cart)
{
ServiceRes serviceRes = new ServiceRes();
try
{
SqlParameter[] sqlParameter = new SqlParameter[5];
sqlParameter[0] = new SqlParameter {
ParameterName = "@Product_Id", Value = cart.ProductId
};
sqlParameter[1] = new SqlParameter {
ParameterName = "@Member_Id", Value = cart.UserId
};
sqlParameter[2] = new SqlParameter {
ParameterName = "@Quantity", Value = cart.Quantity
};
sqlParameter[3] = new SqlParameter {
ParameterName = "@Flag", Value = "A"
};
sqlParameter[4] = new SqlParameter {
ParameterName = "@IsActive", Value = "1"
};
int returnValue = SqlHelper.ExecuteNonQuery("Usp_Cart", sqlParameter);
if (returnValue > 0)
{
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Success";
}
else
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "400";
serviceRes.ReturnMsg = "Failed";
}
}
catch (Exception ex)
{
LogManager.WriteLog(ex);
}
return(serviceRes);
}
public ServiceRes Send(Messages messages)
{
ServiceRes serviceRes = new ServiceRes();
try {
SqlParameter[] sqlParameter = new SqlParameter[4];
sqlParameter[0] = new SqlParameter {
ParameterName = "@senderId", Value = messages.SenderId
};
sqlParameter[1] = new SqlParameter {
ParameterName = "@reciId", Value = messages.RecieverId
};
sqlParameter[2] = new SqlParameter {
ParameterName = "@msgDiscription", Value = messages.MessageContent
};
sqlParameter[3] = new SqlParameter {
ParameterName = "@flag", Value = "S"
};
int returnValue = SqlHelper.ExecuteNonQuery("Usp_MessageMaster", sqlParameter);
if (returnValue > 0)
{
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Success";
}
else
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "400";
serviceRes.ReturnMsg = "Failed";
}
}
catch (Exception ex)
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "500";
serviceRes.ReturnMsg = "Exception occured";
LogManager.WriteLog(ex);
}
return(serviceRes);
}
public ServiceRes ViewProducts(Distributor_User distributor_User)
{
ServiceRes <List <ProductListByCategory> > serviceRes = new ServiceRes <List <ProductListByCategory> >();
List <ProductDetails> productDetails = new List <ProductDetails>();
try
{
SqlParameter[] sqlParameters = new SqlParameter[1];
sqlParameters[0] = new SqlParameter {
ParameterName = "@distributorId", Value = distributor_User.UserId
};
var dataTable = SqlHelper.GetTableFromSP("Usp_DistributorProducts", sqlParameters);
if (dataTable != null && dataTable.Rows.Count > 0)
{
serviceRes.Data = dataTable.AsEnumerable().Select(x =>
new ProductListByCategory
{
Name = x.Field <string>("ProductName"),
Quantity = x.Field <int>("Quantity"),
Price = x.Field <decimal>("Price"),
Photos_Url = x.Field <string>("Photos_Url"),
Specification = x.Field <string>("Specification")
}).ToList();
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Product list ";
}
else
{
serviceRes.Data = null;
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "202";
serviceRes.ReturnMsg = "Product not found";
}
}
catch (Exception ex)
{
LogManager.WriteLog(ex);
}
return(serviceRes);
}
public ServiceRes DeleteCategory(int id)
{
ServiceRes serviceRes = new ServiceRes();
try
{
SqlParameter[] parameter = new SqlParameter[2];
parameter[0] = new SqlParameter {
ParameterName = "@id", Value = id
};
parameter[1] = new SqlParameter {
ParameterName = "@flag", Value = "D"
};
int ret = SqlHelper.ExecuteNonQuery("Usp_Admin_CatgoryMaster", parameter);
}
catch (Exception ex)
{
LogManager.WriteLog(ex);
}
return(serviceRes);
}
public ServiceRes NearByDistributors(NearByDistributors request)
{
ServiceRes <List <NearByDistributors> > serviceRes = new ServiceRes <List <NearByDistributors> >();
try {
SqlParameter [] sqlParameter = new SqlParameter[2];
sqlParameter[0] = new SqlParameter {
ParameterName = "@Member_Id", Value = request.UserId
};
sqlParameter[1] = new SqlParameter {
ParameterName = "@flag", Value = "ND"
};
DataTable dtNearbyDist = SqlHelper.GetTableFromSP("Usp_Products_Test", sqlParameter);
if (dtNearbyDist.Rows.Count > 0)
{
List <NearByDistributors> nearByDistributors = dtNearbyDist.AsEnumerable().
Select(x => new NearByDistributors {
CompanyName = x.Field <string>("Company_Name"),
Distance = x.Field <double>("Distance"),
UserId = x.Field <int>("Member_Id")
}).ToList();
serviceRes.Data = nearByDistributors;
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Near by distributor";
}
else
{
serviceRes.Data = null;
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "400";
serviceRes.ReturnMsg = "Distributor not found";
}
}
catch (Exception ex) {
LogManager.WriteLog(ex);
}
return(serviceRes);
}
public ServiceRes DeliveryTimeSlot()
{
ServiceRes <List <OrderDeliveryTimeSlot> > serviceRes = new ServiceRes <List <OrderDeliveryTimeSlot> >();
try
{
DataTable dataTable = SqlHelper.GetTableFromSP("Usp_GetDeliveryTimeSlot");
serviceRes.Data = dataTable.AsEnumerable().Select(x =>
new OrderDeliveryTimeSlot
{
TimeSlotId = x.Field <int>("Delivery_TimeSlot_ID"),
TimeSlotText = x.Field <string>("Delivery_TimeText")
}).ToList();
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Success";
}
catch (Exception ex)
{
LogManager.WriteLog(ex);
}
return(serviceRes);
}
public ServiceRes DeleteItemfromCart(Cart cart)
{
ServiceRes serviceRes = new ServiceRes();
try
{
SqlParameter[] sqlParameters = new SqlParameter[3];
sqlParameters[0] = new SqlParameter {
ParameterName = "@Member_Id", Value = cart.UserId
};
sqlParameters[1] = new SqlParameter {
ParameterName = "@Product_Id", Value = cart.ProductId
};
sqlParameters[2] = new SqlParameter {
ParameterName = "@Flag", Value = "D"
};
int ret = SqlHelper.ExecuteNonQuery("Usp_Cart", sqlParameters);
if (ret > 0)
{
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Success";
}
else
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "400";
serviceRes.ReturnMsg = "No item in bag";
}
}
catch (Exception ex)
{
LogManager.WriteLog(ex);
}
return(serviceRes);
}
public ServiceRes GetCitiesByState(States states)
{
ServiceRes <List <Cities> > serviceRes = new ServiceRes <List <Cities> >();
try
{
List <Cities> cities = new List <Cities>();
SqlParameter[] sqlParameter = new SqlParameter[1];
sqlParameter[0] = new SqlParameter {
ParameterName = "@StateId", Value = states.StateId
};
DataTable dtCities = SqlHelper.GetTableFromSP("Usp_GetCitiesByState", sqlParameter);
foreach (DataRow row in dtCities.Rows)
{
Cities city = new Cities
{
CityId = Convert.ToInt32(row["CityId"]),
City = Convert.ToString(row["City"])
};
cities.Add(city);
}
serviceRes.Data = cities;
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "";
}
catch (Exception ex)
{
LogManager.WriteLog(ex);
serviceRes.Data = null;
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "500";
serviceRes.ReturnMsg = "Something went wrong";
}
return(serviceRes);
}
public ServiceRes Distributor_Report(Distributor_User distributor_User)
{
ServiceRes <DataSet> serviceRes = new ServiceRes <DataSet>();
try
{
SqlParameter[] sqlParameter = new SqlParameter[2];
sqlParameter[0] = new SqlParameter {
ParameterName = "@MemberId", Value = distributor_User.UserId
};
sqlParameter[1] = new SqlParameter {
ParameterName = "@Date", Value = distributor_User.FilterDate == null ? DateTime.Now: distributor_User.FilterDate
};
var dataSet = SqlHelper.GetDatasetFromSP("USP_DistributorReport", sqlParameter);
if (dataSet.Tables.Count > 0)
{
serviceRes.Data = dataSet;
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Success";
}
else
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "400";
serviceRes.ReturnMsg = "Failed";
}
;
}
catch (Exception ex)
{
LogManager.WriteLog(ex);
}
return(serviceRes);
}
public ServiceRes IsAdminValid(AdminRequest adminRequest)
{
ServiceRes serviceRes = new ServiceRes();
try
{
SqlParameter[] parameter = new SqlParameter[2];
parameter[0] = new SqlParameter {
ParameterName = "@username", Value = adminRequest.Username
};
parameter[1] = new SqlParameter {
ParameterName = "@password", Value = adminRequest.Password
};
var adminDt = SqlHelper.GetTableFromSP("Usp_AdminLogin", parameter);
if (adminDt.Rows.Count > 0)
{
if (Convert.ToString(adminDt.Rows[0][0]) == "0")
{
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Success";
}
else
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "400";
serviceRes.ReturnMsg = "Invalid username and password";
}
}
}
catch (Exception ex)
{
LogManager.WriteLog(ex);
}
return(serviceRes);
}
public ServiceRes IsUserValid(User objUser)
{
ServiceRes serviceRes = new ServiceRes();
try
{
SqlParameter[] parameter = new SqlParameter[1];
parameter[0] = new SqlParameter {
ParameterName = "@MobileNumber", Value = objUser.MobileNumber
};
var dtUser = SqlHelper.GetTableFromSP("Usp_ValidateUser", parameter);
if (dtUser != null && dtUser.Rows.Count > 0)
{
if (Convert.ToString(dtUser.Rows[0][0]) == "201")
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "201";
serviceRes.ReturnMsg = "User not found";
}
else
{
string decryptedPassword = _objRepo.Decrypt(Convert.ToString(dtUser.Rows[0][1]));
string username = Convert.ToString(dtUser.Rows[0][0]);
int isLocked = Convert.ToInt32(dtUser.Rows[0][2]);
int loginAttempts = Convert.ToInt32(dtUser.Rows[0][3]);
if ((username.Equals(objUser.MobileNumber) && decryptedPassword.Equals(objUser.Password)))
{
if (isLocked == 0)
{
//reset login attempts and is locked column
LoginDetails loginDetails = new LoginDetails()
{
Username = objUser.MobileNumber,
IsLocked = false,
LoginAttempts = 3
};
UpdateLoginDetails(loginDetails);
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Valid user";
}
else
{
//return account suspended status
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "403";
serviceRes.ReturnMsg = "Account suspended contact your administrator";
}
}
else if (String.IsNullOrEmpty(objUser.Password) || decryptedPassword != objUser.Password)
{
//decrese login attempts
//if attempts greater than zero set account status active and decrease attempts
loginAttempts = loginAttempts - 1;
if (loginAttempts > 0)
{
LoginDetails loginDetails = new LoginDetails()
{
Username = objUser.MobileNumber,
IsLocked = false,
LoginAttempts = loginAttempts
};
UpdateLoginDetails(loginDetails);
//update attempts left and return status as wrong password
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "403";
serviceRes.ReturnMsg = $"Wrong Password attempts left {loginAttempts} ";
}
else
{
//LoginDetails loginDetails = new LoginDetails()
//{
// Username = objUser.MobileNumber,
// IsLocked = true,
// LoginAttempts = 0
//};
//UpdateLoginDetails(loginDetails);
//update if attempts equal to zero or less suspend the account and set attempts left to zero
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "500";
serviceRes.ReturnMsg = "Account locked contact your administrator";
}
}
}
}
}
catch (Exception ex)
{
LogManager.WriteLog(ex, SeverityLevel.Critical);
}
return(serviceRes);
}
public ServiceRes RegisterUser(Registration objRegister)
{
ServiceRes serviceRes = new ServiceRes();
try
{
//string tempLocation = commonRepository.Base64toImage(objRegister.CompanyPhoto, "TempImages", "Temp", "Photos");
string fileLocation = commonRepository.Base64toImage(objRegister.CompanyPhoto, "Images", "CompanyPhoto", "CompanyPhoto");
SqlParameter[] parameter = new SqlParameter[20];
parameter[0] = new SqlParameter {
ParameterName = "@Mobile", Value = objRegister.MobileNumber
};
parameter[1] = new SqlParameter {
ParameterName = "@Password", Value = _objRepo.Encrypt(objRegister.Password)
};
parameter[2] = new SqlParameter {
ParameterName = "@EmailId", Value = objRegister.EmaillAddress
};
parameter[3] = new SqlParameter {
ParameterName = "@Name", Value = objRegister.FullName
};
parameter[4] = new SqlParameter {
ParameterName = "@BuildingName", Value = objRegister.Building_Name
};
parameter[5] = new SqlParameter {
ParameterName = "@Locality", Value = objRegister.Locality
};
parameter[6] = new SqlParameter {
ParameterName = "@Pincode", Value = objRegister.PinCode
};
parameter[7] = new SqlParameter {
ParameterName = "@City", Value = objRegister.City
};
parameter[8] = new SqlParameter {
ParameterName = "@State", Value = objRegister.State
};
parameter[9] = new SqlParameter {
ParameterName = "@Landmark", Value = objRegister.Landmark
};
parameter[10] = new SqlParameter {
ParameterName = "@AddressType", Value = (int)objRegister.AddressType
};
parameter[11] = new SqlParameter {
ParameterName = "@CompanyName", Value = objRegister.CompanyName
};
parameter[12] = new SqlParameter {
ParameterName = "@GSTNo", Value = objRegister.GST_No
};
parameter[13] = new SqlParameter {
ParameterName = "@BusinessId", Value = objRegister.BusinessId
};
parameter[14] = new SqlParameter {
ParameterName = "@RoleId", Value = (int)objRegister.RoleId
};
parameter[15] = new SqlParameter {
ParameterName = "@IpAddress", Value = objRegister.IpAddress
};
parameter[16] = new SqlParameter {
ParameterName = "@PanNumber", Value = objRegister.PanNumber
};
parameter[17] = new SqlParameter {
ParameterName = "@CompanyImage", Value = fileLocation
};
parameter[18] = new SqlParameter {
ParameterName = "@Latitude", Value = objRegister.Latitude
};
parameter[19] = new SqlParameter {
ParameterName = "@Longitude", Value = objRegister.Longitude
};
DataTable dt = SqlHelper.GetTableFromSP("Usp_RegisterUser", parameter);
var returnValue = dt.Rows[0][0];
if (Convert.ToInt32(returnValue) == 1)
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "201";
serviceRes.ReturnMsg = "Username already exists.Please login with same username";
}
else if (Convert.ToInt32(returnValue) == 0)
{
//commonRepository.RemoveFileFromDirectory("TempImages", "Temp", tempLocation);
//commonRepository.Base64toImage(objRegister.CompanyPhoto, "Images", "CompanyPhoto", "CompanyPhoto");
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "User registered";
}
else
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "400";
serviceRes.ReturnMsg = "Error occured in procedure or database";
}
}
catch (Exception ex)
{
LogManager.WriteLog(ex);
}
return(serviceRes);
}
public ServiceRes RegisterUser(Registration objRegister)
{
ServiceRes serviceRes = new ServiceRes();
try
{
SqlParameter[] parameter = new SqlParameter[16];
parameter[0] = new SqlParameter {
ParameterName = "@MobileNum", Value = objRegister.MobileNumber
};
parameter[1] = new SqlParameter {
ParameterName = "@Password", Value = _objRepo.Encrypt(objRegister.Password)
};
parameter[2] = new SqlParameter {
ParameterName = "@EmailId", Value = objRegister.EmaillAddress
};
parameter[3] = new SqlParameter {
ParameterName = "@Name", Value = objRegister.FullName
};
parameter[4] = new SqlParameter {
ParameterName = "@BuildingName", Value = objRegister.Building_Name
};
parameter[5] = new SqlParameter {
ParameterName = "@Locality", Value = objRegister.Locality
};
parameter[6] = new SqlParameter {
ParameterName = "@Pincode", Value = objRegister.PinCode
};
parameter[7] = new SqlParameter {
ParameterName = "@City", Value = objRegister.City
};
parameter[8] = new SqlParameter {
ParameterName = "@State", Value = objRegister.State
};
parameter[9] = new SqlParameter {
ParameterName = "@Landmark", Value = objRegister.Landmark
};
parameter[10] = new SqlParameter {
ParameterName = "@AddressType", Value = objRegister.AddressType
};
parameter[11] = new SqlParameter {
ParameterName = "@CompanyName", Value = objRegister.CompanyName
};
parameter[12] = new SqlParameter {
ParameterName = "@GSTNo", Value = objRegister.GST_No
};
parameter[13] = new SqlParameter {
ParameterName = "@Category", Value = objRegister.Category
};
parameter[14] = new SqlParameter {
ParameterName = "@BusinessType", Value = objRegister.Businees_Type
};
parameter[15] = new SqlParameter {
ParameterName = "@RoleID", Value = (int)objRegister.RoleId
};
DataTable dt = SqlHelper.GetTableFromSP("Usp_RegisterUser", parameter);
int returnValue = Convert.ToInt32(dt.Rows[0][0]);
if (returnValue > 0)
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "201";
serviceRes.ReturnMsg = "Something went wrong";
}
else
{
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "User registered";
}
}
catch (Exception ex)
{
LogManager.WriteLog(ex, SeverityLevel.Important);
}
return(serviceRes);
}
public ServiceRes ChangePassword(ChangePassword changePassword)
{
ServiceRes serviceRes = new ServiceRes();
return(serviceRes);
}
public ServiceRes AddProduct(ProductDetails objProduct)
{
ServiceRes serviceRes = new ServiceRes();
try
{
if (objProduct != null)
{
ICommonRepository _commonRepository = new CommonRepository();
string fileLocation = _commonRepository.Base64toImage(objProduct.ImagePath, "Images", "ProductImages", "ProductPhoto");
SqlParameter[] sqlParameters = new SqlParameter[13];
sqlParameters[0] = new SqlParameter {
ParameterName = "@Name", Value = objProduct.Name
};
sqlParameters[1] = new SqlParameter {
ParameterName = "@SKUNumber", Value = objProduct.SKUNumber
};
sqlParameters[2] = new SqlParameter {
ParameterName = "@Specification", Value = objProduct.Specification
};
sqlParameters[3] = new SqlParameter {
ParameterName = "@Price", Value = objProduct.Price
};
sqlParameters[4] = new SqlParameter {
ParameterName = "@IsPackaging", Value = objProduct.IsPackaging
};
sqlParameters[5] = new SqlParameter {
ParameterName = "@IsAvailable", Value = objProduct.IsAvailable
};
sqlParameters[6] = new SqlParameter {
ParameterName = "@Discount", Value = objProduct.Discount
};
sqlParameters[7] = new SqlParameter {
ParameterName = "@Category_Id", Value = objProduct.CategoryId
};
sqlParameters[8] = new SqlParameter {
ParameterName = "@SubCategory_Id", Value = objProduct.SubCategoryId
};
sqlParameters[9] = new SqlParameter {
ParameterName = "@Quantity", Value = objProduct.Quantity
};
sqlParameters[10] = new SqlParameter {
ParameterName = "@Photos_Url", Value = fileLocation
};
sqlParameters[11] = new SqlParameter {
ParameterName = "@Member_Id", Value = objProduct.UserId
};
sqlParameters[12] = new SqlParameter {
ParameterName = "@flag", Value = "A"
};
int returnValue = SqlHelper.ExecuteNonQuery("Usp_Products_Test", sqlParameters);
if (returnValue > 0)
{
serviceRes.IsSuccess = true;
serviceRes.ReturnCode = "200";
serviceRes.ReturnMsg = "Product added successfully";
}
else
{
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "400";
serviceRes.ReturnMsg = "Something went wrong";
}
}
}
catch (Exception ex)
{
LogManager.WriteLog(ex);
serviceRes.IsSuccess = false;
serviceRes.ReturnCode = "400";
serviceRes.ReturnMsg = "Error occured in database";
}
return(serviceRes);
}
