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