public async Task <IActionResult> updateSalesProfile([FromBody] updateSalesModel model) { Dictionary <String, Object> dctData = new Dictionary <string, object>(); HttpStatusCode statusCode = HttpStatusCode.OK; TranStatus transaction = new TranStatus(); try { //model.Image = CommonHelper.SaveImage(HttpContext, "Images\\SalesProfile", model.Image, true, model.ImageExtn); model.Image = CommonHelper.SaveImage(HttpContext, "Avatars\\Sales", model.Image, true, model.ImageExtn); //transaction = await isales.updateSalesProfile(model); var result = await isales.updateSalesProfile(model); var loginDetail = result.Item1; transaction = result.Item2; dctData.Add("loginDetail", loginDetail); } catch (Exception ex) { transaction = CommonHelper.TransactionErrorHandler(ex); statusCode = HttpStatusCode.BadRequest; } dctData.Add("Status", transaction); return(this.StatusCode(Convert.ToInt32(statusCode), dctData)); }
//UpdateSalesProfile //public Task<TranStatus> updateSalesProfile(updateSalesModel model) //{ // using (salesRepository = new SalesRepository()) // { // return salesRepository.updateSalesProfile(model); // } //} public Task <Tuple <List <updateSalesModel>, TranStatus> > updateSalesProfile(updateSalesModel model) { using (salesRepository = new SalesRepository()) { return(salesRepository.updateSalesProfile(model)); } }
//UpdateSalesProfiel public async Task <Tuple <List <updateSalesModel>, TranStatus> > updateSalesProfile(updateSalesModel model) { using (var connection = new SqlConnection(ConnectionString)) { await connection.OpenAsync(); DynamicParameters parameter = new DynamicParameters(); parameter.Add("@ID", model.ID); parameter.Add("@Image", model.Image); parameter.Add("@SalesName", model.SalesName); parameter.Add("@Email", model.Email); parameter.Add("@Gender", model.Gender); parameter.Add("@Mobile", model.Mobile); parameter.Add("@Adharcard", model.Adharcard); parameter.Add("@Address", model.Address); parameter.Add("@Password", model.Password); parameter.Add("@Message", dbType: DbType.String, direction: ParameterDirection.Output, size: 500); parameter.Add("@Code", dbType: DbType.Int32, direction: ParameterDirection.Output); var result = await connection.QueryAsync <updateSalesModel>("updateSalesProfile", parameter, commandType : CommandType.StoredProcedure); transaction.returnMessage = parameter.Get <string>("@Message"); transaction.code = parameter.Get <int>("@Code"); return(new Tuple <List <updateSalesModel>, TranStatus>(result.ToList(), transaction)); } }