private void AddResult() { try { for (int i = 0; i < gridData.Rows.Count; i++) { bool check = Convert.ToBoolean(gridData[checkColumn.Index, i].Value); if (!check) { continue; } PurchaseReturn pi = (PurchaseReturn)gridData.Rows[i].Tag; if (RESULT.Count > 0) { PurchaseReturn p1 = (PurchaseReturn)RESULT[0]; if (p1.CURRENCY.ID != pi.CURRENCY.ID) { throw new Exception("Please select same currency"); } } RESULT.Add(pi); } } catch (Exception x) { KryptonMessageBox.Show(x.Message); } }
public ActionResult PurchaseReturn(PurchaseReturn obj, FormCollection fc) { obj.grossTotal = fc["grossTotal"]; obj.ProductSupplierID = Convert.ToInt32(fc["SupplierID"]); obj.ProductSupplierName = fc["supplierName"].ToString(); obj.ProductID = fc["ProductID"].ToString(); obj.UserRate = fc["UserRate"].ToString(); //obj.UserRate obj.Category = fc["Category"].ToString(); obj.Barcode = fc["Barcode"].ToString(); obj.ProductName = fc["ProductName"].ToString(); obj.BatchNo = fc["BatchNo"].ToString(); obj.ExpiryDate = fc["ExpiryDate"].ToString(); obj.Qty = fc["Qty"].ToString(); obj.Scheme = fc["Scheme"].ToString(); obj.DisCountPer = fc["DisCountPer"].ToString(); obj.LessByPer = fc["LessByPer"].ToString(); obj.SchemeDiscountInPer = fc["SchemeDiscountInPer"].ToString(); obj.Rate = fc["Rate"].ToString(); // obj.TaxTypeID = fc["TaxTypeID"].ToString(); obj.TotalAmount = fc["TotalAmount"].ToString(); obj.remark = fc["remark"].ToString(); if (BL_obj.Save(obj)) { } return(RedirectToAction("PurchaseReturn", "PurchaseReturn")); }
private void toolStripButtonFromPR_Click(object sender, EventArgs e) { IList addedPI = new ArrayList(); for (int i = 0; i < itemsDataGrid.Rows.Count; i++) { PurchaseReturn pi = (PurchaseReturn)itemsDataGrid[invoiceNoColumn.Index, i].Tag; if (pi == null) { continue; } addedPI.Add(pi.ID); } using (SearchPRForAPDebitNoteForm frm = new SearchPRForAPDebitNoteForm( (Supplier)supplierkryptonComboBox.SelectedItem, addedPI, m_mainForm.CurrentUser, dateKryptonDateTimePicker.Value)) { frm.ShowDialog(); IList result = frm.RESULT; foreach (PurchaseReturn item in result) { int row = itemsDataGrid.Rows.Add(); itemsDataGrid[invoiceNoColumn.Index, row].Tag = item; itemsDataGrid[invoiceNoColumn.Index, row].Value = item.CODE; itemsDataGrid[invoiceDateColumn.Index, row].Value = item.TRANSACTION_DATE; itemsDataGrid[amountColumn.Index, row].Value = item.TOTAL_AMOUNT_FROM_PO; itemsDataGrid[notesColumn.Index, row].Value = "Wizard from PR# " + item.CODE; ReCalculateNetTotal(); } } }
protected void btnSubmitReturn_OnClick(object sender, EventArgs e) { objPurchaseReturn = new PurchaseReturn(); objPurchaseReturnBiz = new PurchaseReturnBiz(); DataTable dt = (DataTable)Session["ReturnDetail"]; int i; for (i = 0; i < dt.Rows.Count; i++) { objPurchaseReturn.PurchaseId = Convert.ToInt32(lblPurchaseId.Text); objPurchaseReturn.ProductId = Convert.ToInt16(dt.Rows[i][3].ToString()); objPurchaseReturn.ReturnQuantity = Convert.ToDecimal(dt.Rows[i][7].ToString()); objPurchaseReturn.TotalReturnValue = Convert.ToDecimal(txtTotalReturnValue.Text); objPurchaseReturn.DiscountAmount = txtReturnDiscountAmount.Text != "" ? Convert.ToDecimal(txtReturnDiscountAmount.Text) : 0; objPurchaseReturn.CreatedBy = Convert.ToInt16(Session["UserId"].ToString()); objPurchaseReturnBiz.CreateReturnDetail(objPurchaseReturn); } MessageBox("You are successfully return listed products. Thanks!"); Session.Remove("ReturnDetail"); Response.Redirect("ReturnPurchase.aspx"); }
private void CopyFromDO_CustomizePopupWindowParams(object sender, CustomizePopupWindowParamsEventArgs e) { PurchaseReturn masterobject = (PurchaseReturn)View.CurrentObject; string ObjType = masterobject.DocType.BoCode; string BusinessPartner = masterobject.CardCode == null ? "" : masterobject.CardCode.CardCode; IObjectSpace newObjectSpace = Application.CreateObjectSpace(typeof(PurchaseDeliveryDetail)); string listViewId = Application.FindLookupListViewId(typeof(PurchaseDeliveryDetail)); CollectionSourceBase collectionSource = Application.CreateCollectionSource(newObjectSpace, typeof(PurchaseDeliveryDetail), listViewId); if (BusinessPartner == "") { collectionSource.Criteria["filter01"] = CriteriaOperator.Parse("1=0"); } else { if (GeneralValues.LiveWithPost) { collectionSource.Criteria["Filter01"] = CriteriaOperator.Parse("PostVerNo = VerNo and OpenQty > CopyQty and PurchaseDelivery is not null and PurchaseDelivery.PostVerNo = PurchaseDelivery.VerNo and PurchaseDelivery.DocStatus.IsSAPPosted=1 and PurchaseDelivery.DocStatus.CurrDocStatus in (?) and LineStatus in (?) and (PurchaseDelivery.CardCode=?)", DocStatus.Posted, LineStatusEnum.Open, BusinessPartner); } else { collectionSource.Criteria["Filter01"] = CriteriaOperator.Parse("OpenQty > CopyQty and PurchaseDelivery is not null and PurchaseDelivery.DocStatus.CurrDocStatus in (?) and LineStatus in (?, ?) and (PurchaseDelivery.CardCode=?)", DocStatus.Accepted, DocStatus.Posted, LineStatusEnum.Open, BusinessPartner); } } e.View = Application.CreateListView(listViewId, collectionSource, true); //e.View = Application.CreateListView(typeof(PurchaseRequestDetail), true); }
public PurchaseReturnViewModel GetPurchaseReturn(int purchasingID) { PurchaseReturn purchaseReturn = _purchaseReturnRepository.GetMany(x => x.PurchasingId == purchasingID && x.Status == (int)DbConstant.DefaultDataStatus.Active).FirstOrDefault(); PurchaseReturnViewModel viewModel = new PurchaseReturnViewModel(); return(Map(purchaseReturn, viewModel)); }
private void gridData_CellMouseDoubleClick(object sender, DataGridViewCellMouseEventArgs e) { if (gridData.SelectedRows.Count > 0) { PURCHASE_RETURN = (PurchaseReturn)gridData.SelectedRows[0].Tag; this.Close(); } }
public override global::System.Data.DataSet Clone() { PurchaseReturn cln = ((PurchaseReturn)(base.Clone())); cln.InitVars(); cln.SchemaSerializationMode = this.SchemaSerializationMode; return(cln); }
private void OKkryptonButton_Click(object sender, EventArgs e) { if (gridData.SelectedRows.Count > 0) { PURCHASE_RETURN = (PurchaseReturn)gridData.SelectedRows[0].Tag; this.Close(); } }
public void InsertPurchaseReturn(PurchaseReturnColumnModel model) { try { using (this.unitOfWork) { PurchaseReturn item = new PurchaseReturn() { MemoNumber = model.MemoNumber, CustomerId = model.CustomerId, ReturnDate = model.ReturnDate, AmountReturn = model.AmountReturn, Adjustment = model.Adjustment, TotalDebitAmount = model.TotalDebitAmount, Remarks = model.Remarks, IsDeleted = model.IsDeleted, RecordedBy = model.RecordedByUser, ApprovedBy = model.ApprovedByUser, AmountUsed = 0 }; if (model.Details.Count > 0) { foreach (PurchaseReturnDetailModel d in model.Details) { PurchaseReturnDetail detail = new PurchaseReturnDetail() { PartDetailId = d.PartDetailId, PONumber = d.PONumber, Quantity = d.Quantity, UnitPrice = d.UnitPrice, TotalAmount = d.TotalAmount, Balance = d.TotalAmount }; item.PurchaseReturnDetail.Add(detail); AutoPartDetail autoDetail = db.AutoPartDetail.FirstOrDefault(a => a.Id == d.PartDetailId); if (autoDetail != null) { autoDetail.Quantity -= d.Quantity; } } } this.unitOfWork.Context.AddToPurchaseReturn(item); string action = string.Format("Added New Purchase Return - {0}", item.MemoNumber); this.actionLogController.AddToLog(action, UserInfo.UserId); this.unitOfWork.SaveChanges(); } } catch (Exception ex) { throw ex; } }
private void CopyFromDO_Execute(object sender, PopupWindowShowActionExecuteEventArgs e) { PurchaseReturn masterobject = (PurchaseReturn)View.CurrentObject; IObjectSpace ios = View is DetailView ? ObjectSpace : Application.CreateObjectSpace(); if (copyCon.CopyFromDocument(masterobject, (ListView)e.PopupWindow.View, ios)) { masterobject.IsCopy = true; genCon.showMsg("Operation Done", "Item Copied.", InformationType.Success); return; } }
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs) { PurchaseReturn ds = new PurchaseReturn(); global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType(); global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence(); global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny(); any.Namespace = ds.Namespace; sequence.Items.Add(any); type.Particle = sequence; global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable(); if (xs.Contains(dsSchema.TargetNamespace)) { global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream(); global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream(); try { global::System.Xml.Schema.XmlSchema schema = null; dsSchema.Write(s1); for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();) { schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current)); s2.SetLength(0); schema.Write(s2); if ((s1.Length == s2.Length)) { s1.Position = 0; s2.Position = 0; for (; ((s1.Position != s1.Length) && (s1.ReadByte() == s2.ReadByte()));) { ; } if ((s1.Position == s1.Length)) { return(type); } } } } finally { if ((s1 != null)) { s1.Close(); } if ((s2 != null)) { s2.Close(); } } } xs.Add(dsSchema); return(type); }
public IActionResult DeletePurchaseReturn(long id) { PurchaseReturn PurchaseReturn = return_repo.Find(id); if (PurchaseReturn == null) { return(NotFound()); } return_repo.Delete(PurchaseReturn); return(Ok()); }
protected void txtInvoiceNumber_OnTextChanged(object sender, EventArgs e) { objPurchaseReturn = new PurchaseReturn(); objPurchaseReturnBiz = new PurchaseReturnBiz(); objPurchaseReturn = objPurchaseReturnBiz.GetSupplierName(txtInvoiceNumber.Text.Trim()); ddlSupplierList.SelectedValue = objPurchaseReturn.SupplierId.ToString(); lblPurchaseId.Text = objPurchaseReturn.PurchaseId.ToString(); lblDiscountAmount.Text = objPurchaseReturn.DiscountAmount.ToString(); txtReturnDiscountAmount.Text = objPurchaseReturn.DiscountAmount.ToString(); txtReturnProductCode.Attributes.Add("onfocus", "this.select()"); txtReturnProductCode.Focus(); }
protected void btnSave_Click(object sender, EventArgs e) { try { PurchaseReturn.Comment = txtCreditNote.Text.Trim(); PurchaseReturn.CreatedBy = Master.LoggedUser.UserId; if (txtGrnId.Text.Trim() != string.Empty) { PurchaseReturn.GRNId = Int64.Parse(txtGrnId.Text.Trim()); } PurchaseReturn.ModifiedBy = Master.LoggedUser.UserId; PurchaseReturn.ReturnDate = dtpReturnDate.Date; this.CalculateTotal();//to set return total if (PurchaseReturn.Save()) { lblError.Visible = true; lblError.Text = Constant.MSG_Save_SavedSeccessfully; lblPRCode.Text = PurchaseReturn.PRCode; hdnPRId.Value = PurchaseReturn.PRId.ToString(); btnPrintVoucher.Visible = true; AddAttributes(); this.ReadOnlyMode(); } else { lblError.Visible = true; lblError.Text = Constant.MSG_Save_NotSavedSeccessfully; } } catch (Exception ex) { ex.Data.Add("UILayerException", this.GetType().ToString() + Constant.Error_Seperator + "protected void btnSave_Click(object sender, EventArgs e)"); if (Master.LoggedUser != null && Master.LoggedUser.UserName != null && Master.LoggedUser.UserName != string.Empty) { Response.Redirect("Error.aspx?LogId=" + LankaTilesExceptions.WriteEventLogs(ex, Constant.Database_Connection_Name, Master.LoggedUser.UserName), false); } else { Response.Redirect("Error.aspx?LogId=" + LankaTilesExceptions.WriteEventLogs(ex, Constant.Database_Connection_Name, "Annonimous"), false); } } }
public bool UpdateReturn(PurchaseReturn PurchaseReturn, IList <PurchaseReturnitems> PurchaseReturnitemsList, ref string ErrorMessage) { ErrorMessage = string.Empty; try { purchasereturncontext1.Entry(PurchaseReturn).State = EntityState.Modified; purchasereturncontext1.SaveChanges(); foreach (var model in PurchaseReturnitemsList) { if (model.IsDummy == 1) { purchasereturncontext1.Entry(model).State = EntityState.Deleted; purchasereturncontext1.SaveChanges(); } else { if (model.Purchase_ReturnItem_Id == 0) { model.Purchase_Return_Id = PurchaseReturn.Purchase_Invoice_Id; purchasereturncontext1.purchasereturnitems.Add(model); purchasereturncontext1.SaveChanges(); } else { purchasereturncontext1.Entry(model).State = EntityState.Modified; purchasereturncontext1.SaveChanges(); } } } return(true); } catch (DbEntityValidationException dbEx) { var errorList = new List <string>(); foreach (var validationErrors in dbEx.EntityValidationErrors) { foreach (var validationError in validationErrors.ValidationErrors) { errorList.Add(String.Format("Property: {0} Error: {1}", validationError.PropertyName, validationError.ErrorMessage)); } } return(false); } }
/// <summary> /// 生成库存发货 /// </summary> /// <param name="purchaseReturnOrder"></param> /// <returns></returns> private Result CreateGoodsIssues(PurchaseReturn purchaseReturnOrder) { int DocEntry = default(int); if (BOneCommon.IsExistDocument("OIGE", purchaseReturnOrder.OMSDocEntry, out DocEntry)) { return new Result() { ResultCode = 0, ObjCode = DocEntry.ToString(), Message = "has been successfully created document." } } ; Result result = new Result(); SAPbobsCOM.Documents myDocument = SAP.SAPCompany.GetBusinessObject(SAPbobsCOM.BoObjectTypes.oInventoryGenExit); myDocument.CardCode = purchaseReturnOrder.CardCode; myDocument.DocDate = purchaseReturnOrder.OMSDocDate; myDocument.UserFields.Fields.Item("U_OMSDocEntry").Value = purchaseReturnOrder.OMSDocEntry; myDocument.UserFields.Fields.Item("U_BatchNum").Value = purchaseReturnOrder.BatchNum; myDocument.UserFields.Fields.Item("U_InvnTrnsType").Value = purchaseReturnOrder.BusinessType; myDocument.Comments = purchaseReturnOrder.Comments; foreach (var item in purchaseReturnOrder.PurchaseReturnItems) { myDocument.Lines.UserFields.Fields.Item("U_OMSDocEntry").Value = item.OMSDocEntry; myDocument.Lines.UserFields.Fields.Item("U_OMSLineNum").Value = item.OMSLineNum; myDocument.Lines.ItemCode = item.ItemCode; myDocument.Lines.Quantity = Convert.ToDouble(item.Quantity); myDocument.Lines.PriceAfterVAT = Convert.ToDouble(item.Price); myDocument.Lines.AccountCode = BOneCommon.GetAccCodeByBusinessType(purchaseReturnOrder.BusinessType); myDocument.Lines.Add(); } int rt = myDocument.Add(); if (rt != 0) { result.ResultCode = -1; result.Message = SAP.SAPCompany.GetLastErrorDescription(); } else { result.ResultCode = 0; result.ObjCode = SAP.SAPCompany.GetNewObjectKey(); result.Message = "create document successful."; } return(result); }
public async Task <ActionResult> PostAsync(PurchaseReturn model) { if (!this.ModelState.IsValid) { return(this.InvalidModelState(this.ModelState)); } var meta = await AppUsers.GetCurrentAsync().ConfigureAwait(true); model.UserId = meta.UserId; model.OfficeId = meta.OfficeId; model.LoginId = meta.LoginId; long tranId = await DAL.Backend.Tasks.PurchaseReturns.PostAsync(this.Tenant, model).ConfigureAwait(true); return(this.Ok(tranId)); }
private string GenRN() { try { PurchaseReturn lastReturn = return_repo.GetLast(); //PurchaseReturn lastReturn = context.PurchaseReturns.LastOrDefault(); string value = lastReturn.ReturnNumber; string number = Regex.Match(value, "[0-9]+$").Value; return(value.Substring(0, value.Length - number.Length) + (long.Parse(number) + 1).ToString().PadLeft(number.Length, '0')); } catch (NullReferenceException e) { return("PRN0000001"); } }
public PurchaseReturn getPurchaseReturn(SqlConnection con, int InvoiceID) { PurchaseReturn obPurchaseReturn = new PurchaseReturn(); DataTable dt = new DataTable(); try { SqlDataAdapter da = new SqlDataAdapter("Select * from T_Purchase_Return WHERE ReturnMID = @InvoiceID", con); da.SelectCommand.Parameters.Add("@InvoiceID", SqlDbType.Int).Value = InvoiceID; da.Fill(dt); da.Dispose(); if (dt.Rows.Count == 0) { return(null); } obPurchaseReturn.PurchaseInvoiceID = dt.Rows[0].Field <int>("PurchaseInvoiceID"); obPurchaseReturn.ReturnMID = dt.Rows[0].Field <int>("ReturnMID"); obPurchaseReturn.InvoiceNo = dt.Rows[0].Field <string>("InvoiceNo"); obPurchaseReturn.SupplierAccountID = dt.Rows[0].Field <int>("SupplierAccountID"); obPurchaseReturn.ReturnDate = dt.Rows[0].Field <DateTime>("ReturnDate"); obPurchaseReturn.PurchaseAccountID = dt.Rows[0].Field <int>("PurchaseAccountID"); obPurchaseReturn.ReturnAmount = Convert.ToDouble(dt.Rows[0].Field <object>("ReturnAmount")); if (Convert.ToInt32(dt.Rows[0].Field <object>("TransRefID")) == 0) { obPurchaseReturn.TransRefID = 0; } else { obPurchaseReturn.TransRefID = Convert.ToInt32(dt.Rows[0].Field <object>("TransRefID")); } obPurchaseReturn.StockRefID = Convert.ToInt32(dt.Rows[0].Field <object>("StockRefID")); obPurchaseReturn.CurrencyID = Convert.ToInt32(dt.Rows[0].Field <int>("CurrencyID")); obPurchaseReturn.Remarks = dt.Rows[0].Field <string>("Remarks"); obPurchaseReturn.Rate = Convert.ToDouble(dt.Rows[0].Field <object>("Rate")); } catch (Exception ex) { throw new Exception(ex.Message); } return(obPurchaseReturn); }
public void UpdatePurchaseRetrun(List <PurchaseReturnModel> purchaseRetrun) { List <PurchaseReturn> updateStocks = new List <PurchaseReturn>(); List <PurchaseReturn> insertStocks = new List <PurchaseReturn>(); purchaseRetrun?.ForEach(x => { PurchaseReturn updateStock = new PurchaseReturn(x.PurchaseReturnId > 0 ? x.PurchaseReturnId : 0, x.PurchaseId, x.ProductCode, x.Quantity, x.ReturnBy, x.BatchNo, x.ReturnDate, CommonFunctions.ParseDateToFinclaveString(DateTime.Now.ToShortDateString()), x.Reason); if (x.PurchaseReturnId > 0) { updateStocks.Add(updateStock); } else { insertStocks.Add(updateStock); } }); _purchaseRepository.UpdatePurchaseRetrun(updateStocks, insertStocks); }
public void ClearForm() { try { m_prn = new PurchaseReturn(); textBoxCode.Text = ""; dateKryptonDateTimePicker.Value = DateTime.Today; employeeKryptonComboBox.SelectedIndex = 0; notesKryptonTextBox.Text = ""; supplierkryptonComboBox.SelectedIndex = 0; docdatekryptonDateTimePicker.Value = DateTime.Today; docnokryptonTextBox.Text = ""; itemsDataGrid.Rows.Clear(); errorProvider1.Clear(); } catch (Exception x) { KryptonMessageBox.Show(x.Message, "Message", MessageBoxButtons.OK, MessageBoxIcon.Information); } }
public string AddReturn(int staff, int dep, int supplier, string remark, string deport) { try { PurchaseReturn model = new PurchaseReturn(); model.createDate = DateTime.Now; model.depId = dep; model.remark = remark; model.returnNo = GetReturnNo(); model.staffId = staff; model.status = 0; model.supplierId = supplier; model.deportStaff = deport; context.PurchaseReturns.Add(model); context.SaveChanges(); return(model.returnNo); } catch { return(""); } }
public void resetButton() { this.CopyFromDO.Active.SetItemValue("Enabled", false); PurchaseReturn selectobject = (PurchaseReturn)View.CurrentObject; SystemUsers user = ObjectSpace.GetObjectByKey <SystemUsers>(SecuritySystem.CurrentUserId); switch (selectobject.DocStatus.CurrDocStatus) { case DocStatus.Cancelled: case DocStatus.Closed: case DocStatus.Posted: case DocStatus.Accepted: case DocStatus.Submited: break; default: this.CopyFromDO.Active.SetItemValue("Enabled", true); break; } }
public PurchaseReturn GetSupplierName(string searchText) { objDataAccess = DataAccess.NewDataAccess(); objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.ReadCommitted); DbDataReader objDbDataReader = null; PurchaseReturn objPurchaseReturn = new PurchaseReturn(); List <PurchaseReturn> objSupplierList = new List <PurchaseReturn>(); try { objDbCommand.AddInParameter("SearchText", searchText); objDbDataReader = objDataAccess.ExecuteReader(objDbCommand, "[rdb].[uspGetSupplierNameForPR]", CommandType.StoredProcedure); if (objDbDataReader.HasRows) { while (objDbDataReader.Read()) { objPurchaseReturn = new PurchaseReturn(); this.BuildModelForPurchaseReturn(objDbDataReader, objPurchaseReturn); objSupplierList.Add(objPurchaseReturn); } } } catch (Exception ex) { throw new Exception("Error : " + ex.Message); } finally { if (objDbDataReader != null) { objDbDataReader.Close(); } objDataAccess.Dispose(objDbCommand); } return(objPurchaseReturn); }
public static async Task <long> PostAsync(string tenant, PurchaseReturn model) { string connectionString = FrapidDbServer.GetConnectionString(tenant); string sql = @"SELECT * FROM purchase.post_return ( @TransactionMasterId, @OfficeId, @UserId, @LoginId, @ValueDate, @BookDate, @CostCenterId, @SupplierId, @PriceTypeId, @ShipperId, @ReferenceNumber, @StatementReference, ARRAY[{0}] );"; sql = string.Format(sql, Purchases.GetParametersForDetails(model.Details)); using (var connection = new NpgsqlConnection(connectionString)) { using (var command = new NpgsqlCommand(sql, connection)) { command.Parameters.AddWithValue("@TransactionMasterId", model.TransactionMasterId); command.Parameters.AddWithValue("@OfficeId", model.OfficeId); command.Parameters.AddWithValue("@UserId", model.UserId); command.Parameters.AddWithValue("@LoginId", model.LoginId); command.Parameters.AddWithValue("@ValueDate", model.ValueDate); command.Parameters.AddWithValue("@BookDate", model.BookDate); command.Parameters.AddWithValue("@CostCenterId", model.CostCenterId); command.Parameters.AddWithValue("@ReferenceNumber", model.ReferenceNumber); command.Parameters.AddWithValue("@StatementReference", model.StatementReference); command.Parameters.AddWithValue("@SupplierId", model.SupplierId); command.Parameters.AddWithValue("@PriceTypeId", model.PriceTypeId); command.Parameters.AddWithValue("@ShipperId", model.ShipperId); command.Parameters.AddRange(Purchases.AddParametersForDetails(model.Details).ToArray()); connection.Open(); var awaiter = await command.ExecuteScalarAsync().ConfigureAwait(false); return(awaiter.To <long>()); } } }
public string CreateReturnDetail(PurchaseReturn objPurchaseReturn) { int noOfAffacted = 0; objDataAccess = DataAccess.NewDataAccess(); objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.Serializable); objDbCommand.AddInParameter("PurchaseId", objPurchaseReturn.PurchaseId); objDbCommand.AddInParameter("ProductId", objPurchaseReturn.ProductId); objDbCommand.AddInParameter("ReturnQuantity", objPurchaseReturn.ReturnQuantity); objDbCommand.AddInParameter("TotalReturnValue", objPurchaseReturn.TotalReturnValue); objDbCommand.AddInParameter("DiscountAmount", objPurchaseReturn.DiscountAmount); objDbCommand.AddInParameter("CreatedBy", objPurchaseReturn.CreatedBy); try { noOfAffacted = objDataAccess.ExecuteNonQuery(objDbCommand, "[rdb].[uspCreatePurchaseReturn]", CommandType.StoredProcedure); if (noOfAffacted > 0) { objDbCommand.Transaction.Commit(); return("Save Successfully"); } else { objDbCommand.Transaction.Rollback(); return("Cannot save. Try again"); } } catch (Exception ex) { objDbCommand.Transaction.Rollback(); throw new Exception("Database Error Occured", ex); } finally { objDataAccess.Dispose(objDbCommand); } }
public void LoadPurchaseReturnDetails() { PurchaseReturn sReturn = this.purchaseReturnController.FetchPurchaseReturnById(ReturnId); if (sReturn != null) { MemoTextbox.Text = sReturn.MemoNumber; ReturnDatePicker.Value = sReturn.ReturnDate.HasValue ? sReturn.ReturnDate.Value : DateTime.Today; SupplierDropdown.SelectedValue = sReturn.CustomerId; RemarksTextbox.Text = sReturn.Remarks; list = this.purchaseReturnController.FetchPurchaseReturnDetails(ReturnId).ToList(); if (list.Any()) { BindDetails(); ComputeTotalDebit(); } } else { PrepareForm(); } }
public JavaScriptResult Edit(PurchaseReturnViewModel purchaseReturnvm) { try { if (purchaseReturnvm.PurchaseReturnDetails.Any(x => x.Select && x.ReturnQuantity > 0)) { PurchaseReturn purchaseReturn = Mapper.Map <PurchaseReturn>(purchaseReturnvm); List <PurchaseReturnDetail> PurchaseReturnDetailList = Mapper.Map <List <PurchaseReturnDetail> >(purchaseReturnvm.PurchaseReturnDetails.Where(x => x.Select && x.ReturnQuantity > 0)); purchaseReturn.PurchaseReturnDetails = new List <PurchaseReturnDetail>(); foreach (var item in PurchaseReturnDetailList) { purchaseReturn.PurchaseReturnDetails.Add(item); } _purchaseReturnService.Update(purchaseReturn); return(JavaScript($"ShowResult('{"Data updated successfully."}','{"success"}','{"redirect"}','{"/MobileShopPurchaseReturn"}')")); } return(JavaScript($"ShowResult('{"Enter quantity!"}','{"failure"}')")); } catch (Exception ex) { return(JavaScript($"ShowResult('{ex.Message}','failure')")); } }
private void CopyToGR_Execute(object sender, SimpleActionExecuteEventArgs e) { PurchaseDelivery sObject = (PurchaseDelivery)View.CurrentObject; if (GeneralValues.LiveWithPost) { if (sObject.VerNo > sObject.PostVerNo) { genCon.showMsg("Operation fail", "Document has not yet sync. Please wait.", InformationType.Error); return; } foreach (PurchaseDeliveryDetail dtl in sObject.PurchaseDeliveryDetail) { if (dtl.VerNo > dtl.PostVerNo) { genCon.showMsg("Operation fail", "Document has not yet sync. Please wait.", InformationType.Error); return; } } } IObjectSpace ios = Application.CreateObjectSpace(); PurchaseReturn tObject = ios.CreateObject <PurchaseReturn>(); if (copyCon.CopyToDocument(sObject, tObject, ios, (DetailView)View)) { if (tObject.CardCode != null) { tObject.IsCopy = true; } genCon.showMsg("Operation Done", "New Purchase Return copied. Please save it.", InformationType.Success); genCon.openNewView(ios, tObject, ViewEditMode.Edit); return; } genCon.showMsg("Operation Done", "No Open Item for copied.", InformationType.Info); }