public ClsResponseModel GetCustomerReportCount(int Businessid, int Userid, DateTime fromdate, DateTime todate) { ClsResponseModel <List <CustomerReportResponse> > clsResponse = new ClsResponseModel <List <CustomerReportResponse> >(); var parameters = new DynamicParameters(); parameters.Add("@Businessid", Businessid); parameters.Add("@Userid", Userid); parameters.Add("@fromdate", fromdate); parameters.Add("@todate", todate); List <CustomerReportResponse> clsProducts = this._dbContext.Query <CustomerReportResponse>("SP_CustomerReportCount", parameters, commandType: CommandType.StoredProcedure).ToList(); if (clsProducts.Count > 0) { clsResponse.IsSuccess = true; clsResponse.ErrorCode = 200; clsResponse.Message = "Success"; clsResponse.Data = clsProducts; } else { clsResponse.IsSuccess = false; clsResponse.ErrorCode = 400; clsResponse.Message = "Failed"; } return(clsResponse); }
public async Task <ClsResponseModel> AddProductAsync(ClsProductModel clsProductModel) { ClsResponseModel clsResponse = new ClsResponseModel(); var parameters = new DynamicParameters(); parameters.Add("@Categoryid", clsProductModel.CategoryId); parameters.Add("@SubCategoryid", clsProductModel.SubCategoryId); parameters.Add("@Quantity", clsProductModel.Quantity); parameters.Add("@IsDepositAllowed", clsProductModel.IsDepositAllowed); parameters.Add("@IsExchangeAllowed", clsProductModel.IsExchangeAllowed); parameters.Add("@UserId", clsProductModel.UserId); parameters.Add("@Price", clsProductModel.Price); parameters.Add("@Businessid", clsProductModel.BusinessId); int returnValue = await this._dbContext.ExecuteAsync("USP_AddProducts", parameters, commandType : CommandType.StoredProcedure); if (returnValue > 0) { clsResponse.IsSuccess = true; clsResponse.ErrorCode = 200; clsResponse.Message = "Product added successfully."; } else { clsResponse.IsSuccess = false; clsResponse.ErrorCode = 400; clsResponse.Message = "Something went wrong"; } return(clsResponse); }
public async Task <ClsResponseModel> CustomerReturnAsync(ClsCustomerPurchase clsCustomer) { ClsResponseModel clsResponse = new ClsResponseModel(); var parameters = new DynamicParameters(); parameters.Add("@UserId", clsCustomer.UserId); parameters.Add("@DepositReturnAmount", clsCustomer.DepositAmount); parameters.Add("@Createdby", clsCustomer.BusinessId); parameters.Add("@Productid", clsCustomer.ProductId); parameters.Add("@Quantity", clsCustomer.Quantity); parameters.Add("@Businessid", clsCustomer.BusinessId); int returnValue = await this._dbContext.ExecuteAsync("USP_Custreturn", parameters, commandType : CommandType.StoredProcedure); if (returnValue > 0) { clsResponse.IsSuccess = true; clsResponse.ErrorCode = 200; clsResponse.Message = "Purchase successfully."; } else { clsResponse.IsSuccess = false; clsResponse.ErrorCode = 400; clsResponse.Message = "Purchase failed"; } return(clsResponse); }
public async Task <ClsResponseModel> CreateCustomerAsync(ClsCustomerModel responseModel) { ClsResponseModel clsResponse = new ClsResponseModel(); var parameters = new DynamicParameters(); parameters.Add("@Name", responseModel.Name); parameters.Add("@Mobile", responseModel.Mobile); parameters.Add("@CompanyName", responseModel.CompanyName); parameters.Add("@TypeId", responseModel.TypeId); parameters.Add("@BusinessId", responseModel.BusinessId); parameters.Add("@GSTNo", responseModel.GSTNo); parameters.Add("@Address", responseModel.Address); parameters.Add("@userId", responseModel.UserId); parameters.Add("@AlternateNumber", responseModel.AlternateNumber); parameters.Add("@Password", responseModel.Password); int returnValue = await this._dbContext.ExecuteAsync("Usp_RegisterCustomer", parameters, commandType : CommandType.StoredProcedure); if (returnValue > 0) { clsResponse.IsSuccess = true; clsResponse.ErrorCode = 200; clsResponse.Message = "Customer created successully"; } else { clsResponse.IsSuccess = false; clsResponse.ErrorCode = 400; clsResponse.Message = "Failed to create customer"; } return(clsResponse); }
public ActionResult SearchCustomerAuto(string searchText) { if (searchText != null) { ClsResponseModel <List <ClsCustomerModel> > customerResponse = (ClsResponseModel <List <ClsCustomerModel> >) this._user.GetCustomerDetails(); var customers = (from customer in customerResponse.Data where customer.CompanyName.ToLower().Contains(searchText.ToLower()) && customer.BusinessId.Contains(Convert.ToString(Session["businessId"])) select new { id = customer.UserId, label = customer.CompanyName, name = customer.CompanyName, address = customer.Address, mobile = customer.Mobile, depositamount = customer.DepositAmount, notes = customer.Notes, alternatenumber = customer.AlternateNumber }).ToList(); return(Json(customers, JsonRequestBehavior.AllowGet)); } else { return(Json("", JsonRequestBehavior.AllowGet)); } }
public async Task <ClsResponseModel> UpdateCustomerLadger(int Userid, int ProductId, int FullIssue_Update, int Return_Update, int Trail_id_Update, int Createdby) { ClsResponseModel clsResponse = new ClsResponseModel(); var parameters = new DynamicParameters(); parameters.Add("@Userid", Userid); parameters.Add("@ProductId", ProductId); parameters.Add("@FullIssue_Update", FullIssue_Update); parameters.Add("@Return_Update", Return_Update); parameters.Add("@Trail_id_Update", Trail_id_Update); parameters.Add("@Createdby", Createdby); int returnValue = await this._dbContext.ExecuteAsync("Update_TrailDetails", parameters, commandType : CommandType.StoredProcedure); if (returnValue > 0) { clsResponse.IsSuccess = true; clsResponse.ErrorCode = 200; clsResponse.Message = "Leadger Updated successully"; } else { clsResponse.IsSuccess = false; clsResponse.ErrorCode = 400; clsResponse.Message = "Failed to update notes"; } return(clsResponse); }
public ClsResponseModel Delete_SubCategory(int userId, int subCateId) { ClsResponseModel clsResponse = new ClsResponseModel(); var parameters = new DynamicParameters(); parameters.Add("@flag", "D"); parameters.Add("@SubCategoryid", subCateId); parameters.Add("@UserId", userId); parameters.Add("@IsActive", 0); int afftectedRows = this._dbContext.Execute("USP_SubCategoryMaster", parameters, commandType: CommandType.StoredProcedure); if (afftectedRows > 0) { clsResponse.IsSuccess = true; clsResponse.ErrorCode = 200; clsResponse.Message = "Success"; } else { clsResponse.IsSuccess = false; clsResponse.ErrorCode = 400; clsResponse.Message = "Failed"; } return(clsResponse); }
public async Task <ActionResult> Create(ClsCustomerModel clsCustomerModel) { clsCustomerModel.Address = "NA"; clsCustomerModel.AlternateNumber = "9999999999"; clsCustomerModel.CompanyName = Convert.ToString(Session["businessName"]); clsCustomerModel.GSTNo = "0"; if (ModelState.IsValid) { clsCustomerModel.UserId = Convert.ToString(Session["userId"]); clsCustomerModel.BusinessId = Convert.ToString(Session["businessId"]); clsCustomerModel.TypeId = 2; ClsResponseModel clsResponse = await this._user.CreateCustomerAsync(clsCustomerModel); if (clsResponse.IsSuccess) { ViewBag.UserMessage = 200; return(View()); } else { ViewBag.UserMessage = 0; return(View()); } } else { ViewBag.UserMessage = 0; return(View()); } }
public async Task <ClsResponseModel> Create_SubCategoryAsync(ClsSubCategoryMasterModel clsSubCategoryMaster) { ClsResponseModel clsResponse = new ClsResponseModel(); try { var parameters = new DynamicParameters(); parameters.Add("@Categoryid", clsSubCategoryMaster.CategoryId); parameters.Add("@SubCategoryName", clsSubCategoryMaster.SubCategoryName); parameters.Add("@UserId", clsSubCategoryMaster.UserId = 1); parameters.Add("@flag", "I"); int affectedRows = await this._dbContext.ExecuteAsync("USP_SubCategoryMaster", parameters, commandType : CommandType.StoredProcedure); if (affectedRows > 0) { clsResponse.IsSuccess = true; clsResponse.ErrorCode = 200; clsResponse.Message = "Success: Successfully created"; } else { clsResponse.IsSuccess = false; clsResponse.ErrorCode = 400; clsResponse.Message = "Error: Failed to create sub-category"; } } catch (Exception ex) { throw; } return(clsResponse); }
public async Task <ClsResponseModel> AddRateCardAsync(ClsRateCard rateCard) { ClsResponseModel clsResponse = new ClsResponseModel(); var parameters = new DynamicParameters(); parameters.Add("@userId", rateCard.CustomerId); parameters.Add("@categoryId", rateCard.CategoryId); parameters.Add("@rate", rateCard.RateCard); parameters.Add("@createdBy", rateCard.UserId); int returnValue = await this._dbContext.ExecuteAsync("Usp_AddRateCard", parameters, commandType : CommandType.StoredProcedure); if (returnValue > 0) { clsResponse.IsSuccess = true; clsResponse.ErrorCode = 200; clsResponse.Message = "Success"; } else { clsResponse.IsSuccess = false; clsResponse.ErrorCode = 400; clsResponse.Message = "Failed"; } return(clsResponse); }
public async Task <ClsResponseModel> CustomerDepositAsync(ClsCustomerDeposiit customerDeposiit) { ClsResponseModel clsResponse = new ClsResponseModel(); var parameters = new DynamicParameters(); parameters.Add("@UserId", customerDeposiit.UserId); parameters.Add("@DepositType", customerDeposiit.DepositType); parameters.Add("@CreatedBy", customerDeposiit.BusinessId); parameters.Add("@DepositAmount", customerDeposiit.DepositAmount); int returnValue = await this._dbContext.ExecuteAsync("USP_CustDeposit", parameters, commandType : CommandType.StoredProcedure); if (returnValue > 0) { clsResponse.IsSuccess = true; clsResponse.ErrorCode = 200; clsResponse.Message = "Success."; } else { clsResponse.IsSuccess = false; clsResponse.ErrorCode = 400; clsResponse.Message = "Failed"; } return(clsResponse); }
public async Task <ActionResult> CreateCustomer(ClsCustomerModel clsCustomerModel) { clsCustomerModel.Password = "******"; if (ModelState.IsValid) { clsCustomerModel.UserId = Convert.ToString(Session["userId"]); clsCustomerModel.BusinessId = Convert.ToString(Session["businessId"]); clsCustomerModel.TypeId = 1; ClsResponseModel clsResponse = await this._user.CreateCustomerAsync(clsCustomerModel); if (clsResponse.IsSuccess) { ViewBag.UserMessage = 200; ViewBag.Message = clsResponse.Message; return(View("Index")); } else { ViewBag.UserMessage = 0; return(View("Index")); } } else { ViewBag.UserMessage = 400; return(View()); } }
public ClsResponseModel GetAllEmptyProductandHoldingStock(int businessId, int UserId) { //List<ClsProductDetailModel> ClsProductDetail = new List<ClsProductDetailModel>(); //List<ClsUserHoldingStockModel> ClsUserHoldingStock = new List<ClsUserHoldingStockModel>(); var parameters = new DynamicParameters(); parameters.Add("@Businessid", businessId); List <ClsProductDetailModel> ClsProductDetail = this._dbContext.Query <ClsProductDetailModel>("SP_ProductEmptyList", parameters, commandType: CommandType.StoredProcedure).ToList(); ClsResponseModel <List <ClsProductDetailModel> > clsResponse = new ClsResponseModel <List <ClsProductDetailModel> >(); if (ClsProductDetail.Count > 0) { try { var Parameters = new DynamicParameters(); Parameters.Add("@UserId", UserId); List <ClsUserHoldingStockModel> ClsUserHoldingStock = this._dbContext.Query <ClsUserHoldingStockModel>("SP_CustomerHoldingStock", Parameters, commandType: CommandType.StoredProcedure).ToList(); for (int i = 0; i < ClsProductDetail.Count; i++) { if (ClsUserHoldingStock.Count > 0) { int flag = 0; for (int j = 0; j < ClsUserHoldingStock.Count; j++) { if (ClsUserHoldingStock[j].ProductId == ClsProductDetail[i].ProductId) { ClsProductDetail[i].HoldingStock = ClsUserHoldingStock[j].HoldingStock; flag = 1; break; } } if (flag == 0) { ClsProductDetail[i].HoldingStock = 0; } } else { ClsProductDetail[i].HoldingStock = 0; } } } catch (Exception ex) { } clsResponse.IsSuccess = true; clsResponse.ErrorCode = 200; clsResponse.Message = "Success"; clsResponse.Data = ClsProductDetail; } else { clsResponse.IsSuccess = false; clsResponse.ErrorCode = 400; clsResponse.Message = "Failed"; } return(clsResponse); }
public async Task <ActionResult> GetUserDepositDetails(int userId) { ClsResponseModel <IEnumerable <ClsUserDepositDetails> > _depositDetails = null; if (userId > 0) { _depositDetails = await this._product.GetDepositDetails(userId) as ClsResponseModel <IEnumerable <ClsUserDepositDetails> >; } return(PartialView("/Views/_DepositDetailsPartial.cshtml", _depositDetails.Data)); }
public async Task <ActionResult> DeleteCustomerLadger(int Userid, string ChallanNumber) { ClsResponseModel responseModel = await this._user.DeleteCustomerLadger(Userid, Convert.ToInt32(Session["userId"]), ChallanNumber); if (responseModel.IsSuccess) { return(Json(new { Status = 1 })); } else { return(Json(new { Status = 0 })); } }
public async Task <ActionResult> UpdateCustomerLadger(int Userid, int ProductId, int FullIssue, int Return, int Trail_id) { ClsResponseModel responseModel = await this._user.UpdateCustomerLadger(Userid, ProductId, FullIssue, Return, Trail_id, Convert.ToInt32(Session["userId"])); if (responseModel.IsSuccess) { return(Json(new { Status = 1 })); } else { return(Json(new { Status = 0 })); } }
public MasterController() { this._masters = new MasterRepository(); this.clsResponse = (ClsResponseModel <List <ClsCategoryMasterModel> >) this._masters.Get_Category(); ViewBag.Category = clsResponse.Data.Select(x => new SelectListItem { Text = x.CategoryName, Value = Convert.ToString(x.CategoryId) } ).ToList(); }
public async Task <ActionResult> CustomerDepositAsync(ClsCustomerDeposiit customerDeposiit) { customerDeposiit.BusinessId = Convert.ToInt32(Session["businessid"]); ClsResponseModel responseModel = await this._product.CustomerDepositAsync(customerDeposiit); if (responseModel.IsSuccess) { return(Json(new { Status = 1 })); } else { return(Json(new { Status = 0 })); } }
public async Task <ActionResult> CustomerReturn(ClsCustomerPurchase clsCustomerReturn) { clsCustomerReturn.BusinessId = Convert.ToInt32(Session["businessId"]); ClsResponseModel purchaseResponse = await this._product.CustomerReturnAsync(clsCustomerReturn); if (purchaseResponse.IsSuccess) { return(Json(new { Status = 1 })); } else { return(Json(new { Status = 0 })); } }
public ActionResult ViewProduct(int businessId) { ClsResponseModel <List <ClsProductDetailModel> > clsResponseModel = (ClsResponseModel <List <ClsProductDetailModel> >) this._product.GetAllProduct(businessId); if (clsResponseModel.IsSuccess) { return(View(clsResponseModel.Data)); //return Json(new { data = clsResponseModel.Data }); } else { return(View(clsResponseModel.Data)); //return Json(""); } }
public ClsResponseModel Get_Category() { ClsResponseModel <List <ClsCategoryMasterModel> > clsResponse = new ClsResponseModel <List <ClsCategoryMasterModel> >(); var parameters = new DynamicParameters(); parameters.Add("@flag", "S"); List <ClsCategoryMasterModel> response = _dbContext.Query <ClsCategoryMasterModel>("USP_CategoryMaster", parameters, commandType: CommandType.StoredProcedure).ToList(); if (response.Count > 0) { clsResponse.IsSuccess = true; clsResponse.ErrorCode = 200; clsResponse.Message = "Success"; clsResponse.Data = response; } return(clsResponse); }
public async Task <ClsResponseModel> Add_Category(ClsCategoryMasterModel data) { ClsResponseModel <IEnumerable <ClsCategoryMasterModel> > clsResponse = new ClsResponseModel <IEnumerable <ClsCategoryMasterModel> >(); var parameters = new DynamicParameters(); parameters.Add("@flag", "I"); parameters.Add("@CategoryName", data.CategoryName); parameters.Add("@UserId", 1); IEnumerable <ClsCategoryMasterModel> models = await _dbContext.QueryAsync <ClsCategoryMasterModel>("USP_CategoryMaster", parameters, commandType : CommandType.StoredProcedure); clsResponse.IsSuccess = true; clsResponse.Message = "Message"; clsResponse.ErrorCode = 200; clsResponse.Data = models; return(clsResponse); }
public async Task <ClsResponseModel> CustomerPurchaseReturnAsync(List <ClsCustomerPurchaseReturn> customerPurchaseReturn) { try { int returnValue = 0; string uniqueid = Guid.NewGuid().ToString(); ClsResponseModel clsResponse = new ClsResponseModel(); foreach (var item in customerPurchaseReturn) { var parameters = new DynamicParameters(); parameters.Add("@UserId", item.UserId); parameters.Add("@Createdby", customerPurchaseReturn[0].BusinessId); parameters.Add("@Productid", item.ProductId); parameters.Add("@PurchaseQuantity", item.PurchaseQuantity); parameters.Add("@ReturnQuantity", item.ReturnQuantity); parameters.Add("@HoldingStock", item.HoldingStock); parameters.Add("@Businessid", customerPurchaseReturn[0].BusinessId); parameters.Add("@ChallanNumber", "C" + customerPurchaseReturn[0].BusinessId + "-" + item.ChallanNumber); parameters.Add("@IsHolding", item.IsHolding); parameters.Add("@ChallanDate", Convert.ToDateTime(item.ChallanDate)); parameters.Add("@UniqueId", uniqueid); returnValue = await this._dbContext.ExecuteAsync("USP_CustPurchaseReturn", parameters, commandType : CommandType.StoredProcedure); } if (returnValue > 0) { clsResponse.IsSuccess = true; clsResponse.ErrorCode = 200; clsResponse.Message = "Success."; } else { clsResponse.IsSuccess = false; clsResponse.ErrorCode = 400; clsResponse.Message = "Failed"; } return(clsResponse); } catch (Exception ex) { throw; } }
public async Task <ActionResult> CustomerPurchase(ClsCustomerPurchase clsCustomerPurchase) { clsCustomerPurchase.BusinessId = Convert.ToInt32(Session["businessId"]); clsCustomerPurchase.IsDepositGiven = true; clsCustomerPurchase.IsDepositReturn = false; clsCustomerPurchase.SubCategoryId = clsResponseModel.Data.Where(x => x.SubCategoryName == clsCustomerPurchase.SubCategoryId).Select(y => y.SubCategoryId).FirstOrDefault().ToString(); clsCustomerPurchase.CategoryId = clsResponse.Data.Where(x => x.CategoryName == clsCustomerPurchase.CategoryId).Select(y => y.CategoryId).FirstOrDefault().ToString(); ClsResponseModel purchaseResponse = await this._product.CustomerPurchaseAsync(clsCustomerPurchase); if (purchaseResponse.IsSuccess) { return(Json(new { Status = 1 })); } else { return(Json(new { Status = 0 })); } }
public ClsResponseModel GetCustomerDetails() { ClsResponseModel <List <ClsCustomerModel> > clsResponse = new ClsResponseModel <List <ClsCustomerModel> >(); List <ClsCustomerModel> response = _dbContext.Query <ClsCustomerModel>("USP_GetCustomer", null, commandType: CommandType.StoredProcedure).ToList(); if (response.Count > 0) { clsResponse.IsSuccess = true; clsResponse.ErrorCode = 200; clsResponse.Message = "Success"; clsResponse.Data = response; } else { clsResponse.IsSuccess = false; clsResponse.ErrorCode = 400; clsResponse.Message = "Failed"; } return(clsResponse); }
public async Task <ActionResult> DistributorPurchaseReturnAsync(List <ClsCustomerPurchaseReturn> customerPurchaseReturn) { try { customerPurchaseReturn[0].BusinessId = Convert.ToInt32(Session["businessid"]); ClsResponseModel responseModel = await this._product.DistributorPurchaseReturnAsync(customerPurchaseReturn); if (responseModel.IsSuccess) { return(Json(new { Status = 1 })); } else { return(Json(new { Status = 0 })); } } catch (Exception ex) { Helper.WriteErrorLog("functionname : DistributorPurchaseReturnAsync" + Environment.NewLine + "Source : " + ex.Source.Trim() + Environment.NewLine + ex.Message + Environment.NewLine + "inner exception :" + ex.InnerException); return(Json(new { Status = 400 })); } }
public async Task <ActionResult> CreateSubCategory(ClsSubCategoryMasterModel clsSubCategoryMaster) { if (ModelState.IsValid) { ClsResponseModel response = await this._masters.Create_SubCategoryAsync(clsSubCategoryMaster); if (response.IsSuccess) { ViewData["ErrorMsg"] = response.Message; return(RedirectToAction("SubCategoryDetails")); } else { ViewData["ErrorMsg"] = response.Message; return(View()); } } else { return(View()); } }
public ClsResponseModel GetAllProduct(int businessId) { ClsResponseModel <List <ClsProductDetailModel> > clsResponse = new ClsResponseModel <List <ClsProductDetailModel> >(); var parameters = new DynamicParameters(); parameters.Add("@Businessid", businessId); List <ClsProductDetailModel> clsProducts = this._dbContext.Query <ClsProductDetailModel>("SP_ProductInvetoryList", parameters, commandType: CommandType.StoredProcedure).ToList(); if (clsProducts.Count > 0) { clsResponse.IsSuccess = true; clsResponse.ErrorCode = 200; clsResponse.Message = "Success"; clsResponse.Data = clsProducts; } else { clsResponse.IsSuccess = false; clsResponse.ErrorCode = 400; clsResponse.Message = "Failed"; } return(clsResponse); }
public async Task <ClsResponseModel> GetRateCardDetailsByUser(int userId) { ClsResponseModel <IEnumerable <ClsRateCard> > clsResponse = new ClsResponseModel <IEnumerable <ClsRateCard> >(); var parameters = new DynamicParameters(); parameters.Add("@userId", userId); IEnumerable <ClsRateCard> lstRateDetails = await this._dbContext.QueryAsync <ClsRateCard>("Usp_GetRateCardDetailsByUser", parameters, commandType : CommandType.StoredProcedure); if (lstRateDetails.Count() > 0) { clsResponse.IsSuccess = true; clsResponse.ErrorCode = 200; clsResponse.Message = "Success"; clsResponse.Data = lstRateDetails; } else { clsResponse.IsSuccess = false; clsResponse.ErrorCode = 400; clsResponse.Message = "Failed"; } return(clsResponse); }
public async Task <ClsResponseModel> UpdateCustomerNote(int Userid, string Notes) { ClsResponseModel clsResponse = new ClsResponseModel(); var parameters = new DynamicParameters(); parameters.Add("@Userid", Userid); parameters.Add("@Notes", Notes); int returnValue = await this._dbContext.ExecuteAsync("Usp_UpdateCustomerNote", parameters, commandType : CommandType.StoredProcedure); if (returnValue > 0) { clsResponse.IsSuccess = true; clsResponse.ErrorCode = 200; clsResponse.Message = "Notes Updated successully"; } else { clsResponse.IsSuccess = false; clsResponse.ErrorCode = 400; clsResponse.Message = "Failed to update notes"; } return(clsResponse); }