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