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