public ActionResult UpdateInvoiceICByFileID(string FileInvoiceList, int fileID) { try { int FileId = fileID; List <InvoiceICDetail> objInvoiceICDetail = new List <InvoiceICDetail>(); string[] arr = FileInvoiceList.Split(','); for (int i = 0; i < arr.Length - 1; i++) { string _ia = arr[i]; string[] arrFields = _ia.Split('-'); InvoiceICDetail objInvoiceIC = new InvoiceICDetail { FileID = Convert.ToInt32(arrFields[0]), InvoiceID = Convert.ToInt32(arrFields[1]), InvoiceICAmt = Convert.ToDecimal(arrFields[2]), }; objInvoiceICDetail.Add(objInvoiceIC); } var validate = _invoice.UpdateInvoiceICAmt(Mapper.Map <IEnumerable <LMGEDI.Core.Data.Model.InvoiceICDetail> >(objInvoiceICDetail)); var getAllInvoices = _invoice.GetInvoiceICRecord(FileId); InvoiceICViewModel invoiceViewModel = new LMGEDIApp.Domain.Models.InvoiceModel.InvoiceICViewModel(); invoiceViewModel.InvoiceICDetails = Mapper.Map <IEnumerable <InvoiceICDetail> >(getAllInvoices); return(Json(invoiceViewModel)); } catch (Exception ex) { _arCommonService.CreateErrorLog(ex.Message, ex.StackTrace); return(View()); } }
public int UpdateInvoiceICAmtAccFileIdInvoiceID(InvoiceICDetail objInvoiceICDetail) { SqlParameter _FileID = new SqlParameter("@FileId", objInvoiceICDetail.FileID); SqlParameter _InvoiceID = new SqlParameter("@InvoiceID", objInvoiceICDetail.InvoiceID); SqlParameter _InvoiceICAmt = new SqlParameter("@InvoiceICAmt", objInvoiceICDetail.InvoiceICAmt); return(Context.Database.ExecuteSqlCommand(Constant.StoredProcedureConst.InvoiceRepositoryProcedure.UpdateICAmtAccFileIdInvID, _FileID, _InvoiceID, _InvoiceICAmt)); }