private async void btnSave_Click(object sender, EventArgs e)
{
try
{
if (txtName.Text.Trim() == string.Empty || txtAmount.Text.Trim() == string.Empty)
{
MessageBox.Show("All fields required....", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtName.Focus();
return;
}
if (!System.Text.RegularExpressions.Regex.IsMatch(txtName.Text, "^[a-zA-Z]"))
{
MessageBox.Show("Invaild Name", "Error", MessageBoxButtons.OK, MessageBoxIcon.Error);
txtName.Focus();
txtName.Text.Remove(txtName.Text.Length - 1);
return;
}
SaleReturn _saleReturn = new SaleReturn()
{
Amount = (decimal)Convert.ToDouble(txtAmount.Text),
CustomerName = Convert.ToString(txtName.Text),
Date = DateTime.Now
};
await _saleReturnRepository.Add(_saleReturn);
this.Dispose();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
/// <summary>
/// 修改销售退货单
/// </summary>
/// <param name="qp"></param>
/// <param name="list"></param>
/// <returns></returns>
internal static int EditStocks(SaleReturn qp, List <SaleReturnDetail> list)
{
PSSEntities db = new PSSEntities();
int fg = 1;
using (var tx = db.Database.BeginTransaction())
{
try
{
SaleReturn c = db.SaleReturn.FirstOrDefault(p => p.SRID.Equals(qp.SRID));
c.CusID = qp.CusID;
c.DepotID = qp.DepotID;
c.SDID = qp.SDID;
c.SRDate = qp.SRDate;
c.SRDesc = qp.SRDesc;
db.SaleReturnDetail.RemoveRange(db.SaleReturnDetail.Where(s => s.SRID.Equals(qp.SRID)));
if (list != null)
{
db.SaleReturnDetail.AddRange(list);
}
db.SaveChanges();
tx.Commit();
}
catch (Exception ex)
{
fg = 0;
tx.Rollback();
throw new Exception(ex.Message);
}
}
return(fg);
}
public SaleReturnDashboard()
{
InitializeComponent();
_saleReturnRepository = new SaleReturnRepository();
_saleReturn = new SaleReturn();
EditSaleReturn.OnLoadData += Setup;
}
public void CreateTest()
{
SaleReturnVM vm = _controller.Wtm.CreateVM <SaleReturnVM>();
SaleReturn v = new SaleReturn();
v.SRID = "qH2ATmQ";
v.CustomersID = AddCustomers();
v.DepotsID = AddDepots();
v.SRState = SCMSupplyChain.Model.SRState.未定义3;
v.SRDesc = "jubk";
vm.Entity = v;
var rv = _controller.Add(vm);
Assert.IsInstanceOfType(rv, typeof(OkObjectResult));
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var data = context.Set <SaleReturn>().Find(v.ID);
Assert.AreEqual(data.SRID, "qH2ATmQ");
Assert.AreEqual(data.SRState, SCMSupplyChain.Model.SRState.未定义3);
Assert.AreEqual(data.SRDesc, "jubk");
Assert.AreEqual(data.CreateBy, "user");
Assert.IsTrue(DateTime.Now.Subtract(data.CreateTime.Value).Seconds < 10);
}
}
/*******************************************************************************************************/
#region LIST
private void populateGrid()
{
//sale barcode
Guid?saleID = null;
txtBarcode.Text = txtBarcode.Text.Trim();
if (!string.IsNullOrEmpty(txtBarcode.Text))
{
if (!Tools.isHexNumber(txtBarcode.Text))
{
Tools.hasMessage(String.Format("{0} is an invalid invoice barcode", txtBarcode.Text));
txtBarcode.Focus();
}
else
{
try
{
saleID = Sale.getIDByBarcode(txtBarcode.Text);
}
catch
{
Tools.hasMessage(String.Format("{0} does not exist in database", txtBarcode.Text));
return;
}
}
}
//item barcode
Guid?inventoryItemID = null;
txtInventoryItemBarcode.Text = txtInventoryItemBarcode.Text.Trim();
if (!string.IsNullOrEmpty(txtInventoryItemBarcode.Text))
{
if (!InventoryItem.isValidBarcode(txtInventoryItemBarcode.Text))
{
txtInventoryItemBarcode.Focus();
}
else
{
try
{
inventoryItemID = InventoryItem.getIDByBarcode(InventoryItem.getBarcodeWithoutPrefix(txtInventoryItemBarcode.Text));
}
catch
{
Tools.hasMessage(String.Format("{0} does not exist in database", txtBarcode.Text));
return;
}
}
}
if (_startingMode == FormModes.Browse)
{
Util.setGridviewDataSource(grid, true, true, SaleReturn.get_by_BrowsingForFakturPajak_Customers_Id((Guid)_BrowsingForFakturPajak_Customers_Id));
}
else
{
Util.setGridviewDataSource(grid, true, true, SaleReturn.get(idtp_StartDate.ValueAsStartDateFilter, idtp_EndDate.ValueAsEndDateFilter, inventoryItemID, (Guid?)cbCustomers.SelectedValue, saleID));
}
}
/// <summary>
/// 添加销售退货单
/// </summary>
/// <param name="qp"></param>
/// <param name="list"></param>
/// <returns></returns>
internal static int AddStocks(SaleReturn qp, List <SaleReturnDetail> list)
{
PSSEntities db = new PSSEntities();
int fg = 1;
using (var tx = db.Database.BeginTransaction())
{
try
{
db.SaleReturn.Add(qp);
if (list != null)
{
db.SaleReturnDetail.AddRange(list);
}
db.SaveChanges();
tx.Commit();
}
catch (Exception ex)
{
fg = 0;
tx.Rollback();
throw new Exception(ex.Message);
}
}
return(fg);
}
public JsonResult SaveSaleItems(List <SaleReturnValidation> saleReturn)
{
SaleReturn newSaleReturn = new SaleReturn();
newSaleReturn.TotalBeforePercentage = saleReturn.Select(x => x.TotalBeforePercentage).FirstOrDefault();
decimal?totalAfterPercentage = saleReturn.Select(x => x.TotalAfterPercentage).FirstOrDefault();
newSaleReturn.TotalAfterPercentage = saleReturn.Select(x => x.TotalAfterPercentage).FirstOrDefault();
newSaleReturn.SpecialDiscount = saleReturn.Select(x => x.SpecialDiscount).FirstOrDefault();
newSaleReturn.AmountPaid = saleReturn.Select(x => x.AmountPaid).FirstOrDefault();
newSaleReturn.Arears = saleReturn.Select(x => x.Arears).FirstOrDefault();
newSaleReturn.DateOfSaleReturn = DateTime.Now;
context.SaleReturns.Add(newSaleReturn);
context.SaveChanges();
foreach (var n in saleReturn)
{
SaleReturnItem saleReturnItem = new SaleReturnItem();
var itemID = context.Items.Where(x => x.Name == n.Name).Select(x => x.ID).FirstOrDefault();
saleReturnItem.SaleReturnID = newSaleReturn.ID;
saleReturnItem.ItemID = itemID;
saleReturnItem.SalePercentage = n.SalePercentage;
saleReturnItem.Quantity = n.Quantity;
saleReturnItem.LoosePack = n.LoosePack;
context.SaleReturnItems.Add(saleReturnItem);
context.SaveChanges();
var Item = context.Items.Where(x => x.ID == itemID).FirstOrDefault();
if (n.LoosePack == "P")
{
Item.TotalStock += n.Quantity;
}
else if (n.LoosePack == "L")
{
Item.LooseQuantitySold += n.Quantity;
if (Item.LooseQuantitySold >= n.PiecesPerPack)
{
int?packReturned = Item.LooseQuantitySold / n.PiecesPerPack;
int?looseQuantityleftAfterPackomission = Item.LooseQuantitySold % n.PiecesPerPack;
Item.TotalStock += packReturned;
Item.LooseQuantitySold = looseQuantityleftAfterPackomission;
}
}
//TODO: remove last line. just to save saleprice at run time
Item.SalePrice = n.SalePrice;
context.SaveChanges();
}
return(Json(true));
}
/*******************************************************************************************************/
#region INITIALIZATION
public Print_Form(Guid SaleReturnID)
{
InitializeComponent();
_saleReturn = new SaleReturn(SaleReturnID);
setupControls();
populatePage();
Tools.rearrangeButtonsInPanel(pnlButtons, HorizontalAlignment.Center);
Tools.disableResizing(this);
}
private void populateGridReturns(bool repopulateGridFakturPajak)
{
DataTable data = SaleReturn.get_by_FakturPajaks_Id(selectedRowID());
Util.setGridviewDataSource(gridReturns, false, false, data);
tpSaleReturns.Text = string.Format("{0}: {1:N2}", TABTITLE_SaleReturns, -1 * Util.compute(data, "SUM", SaleReturn.COL_RETURNAMOUNT, ""));
if (repopulateGridFakturPajak)
{
populateGridViewDataSource(true);
}
}
private void populateGridReturns(bool repopulateGridKontrabon)
{
DataTable data = SaleReturn.get_by_Kontrabons_Id((Guid)_lastSelectedKontrabons_Id);
Util.setGridviewDataSource(gridReturns, false, false, data);
tpSaleReturns.Text = string.Format("{0}: {1:N2}", TABTITLE_SaleReturns, -1 * Util.compute(data, "SUM", SaleReturn.COL_RETURNAMOUNT, ""));
if (repopulateGridKontrabon)
{
populateGridViewDataSource(true);
}
}
/// <summary>
/// 修改销售退货单
/// </summary>
/// <param name="qp"></param>
/// <param name="list"></param>
/// <returns></returns>
public ActionResult EditSaleReturn(SaleReturn qp, List <SaleReturnDetail> list)
{
if (SaleReturnBLL.EditStocks(qp, list) > 0)
{
return(Content("edit_yes"));
}
else
{
return(Content("edit_no"));
}
}
private void grid_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (Util.isColumnMatch(sender, e, hexbarcode))
{
Util.displayForm(null, new Returns.Print_Form((Guid)Util.getSelectedRowValue(sender, col_grid_id)));
}
else if (Util.isColumnMatch(sender, e, col_grid_Checked))
{
SaleReturn.updateCheckedStatus(LIBUtil.Util.getSelectedRowID(grid, col_grid_id), !LIBUtil.Util.getCheckboxValue(sender, e));
populateGrid();
}
}
private void GridReturns_CellContentClick(object sender, DataGridViewCellEventArgs e)
{
if (Util.isColumnMatch(sender, e, col_gridReturns_hexbarcode))
{
Util.displayForm(null, new Returns.Print_Form(Util.getSelectedRowID(sender, col_gridReturns_id)));
}
else if (Util.isColumnMatch(sender, e, col_gridReturns_removeFakturPajaks_Id))
{
SaleReturn.update_FakturPajaks_Id((Guid)Util.getSelectedRowValue(sender, col_gridReturns_id), null);
populateGridReturns(true);
}
}
/// <summary>
/// 添加销售退货单
/// </summary>
/// <param name="qp"></param>
/// <param name="list"></param>
/// <returns></returns>
public ActionResult AddSaleReturn(SaleReturn qp, List <SaleReturnDetail> list)
{
qp.UserID = Convert.ToInt32(Session["uid"]);
if (SaleReturnBLL.AddStocks(qp, list) > 0)
{
return(Content("add_yes"));
}
else
{
return(Content("add_no"));
}
}
/// <summary>
/// 更新
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int Update(SaleReturn obj)
{
try
{
int count = 0;
string sql = "update jinchen.salereturn_info set return_num={0},return_price={1},return_all_price={2},remark='{3}' where seq_id={4} and return_index='{5}' ";
sql = string.Format(sql, obj.return_num, obj.return_price, obj.return_all_price, obj.remark, obj.seq_id, obj.return_index);
count = PostgreHelper.ExecuteNonQuery(sql);
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 插入
/// </summary>
/// <param name="obj"></param>
/// <returns></returns>
public int Insert(SaleReturn obj)
{
try
{
string sql = "insert into jinchen.salereturn_info(seq_id,return_index,return_num," +
"return_time,return_price,return_all_price,insert_time,deliver_index,remark) values({0},'{1}',{2},'{3}',{4},{5},'{6}','{7}','{8}')";
sql = string.Format(sql, obj.seq_id, obj.return_index,
obj.return_num, obj.return_time, obj.return_price, obj.return_all_price, obj.insert_time, obj.deliver_index, obj.remark);
int count = PostgreHelper.ExecuteNonQuery(sql);
return(count);
}
catch (Exception ex)
{
throw ex;
}
}
/*******************************************************************************************************/
#region SUBMISSION
private void btnSubmit_Click(object sender, EventArgs e)
{
if (isSaleReturnValid())
{
SaleReturn obj = new SaleReturn(txtNotes.Text, (DataTable)grid.DataSource);
if (obj.submitNew() != null)
{
if (_customerID != null)
{
CustomerCredit.submitNew((Guid)_customerID, _totalAmount, null, string.Format("Credit from Sale Return " + obj.barcode), PaymentMethod.Cash);
Tools.hasMessage("Credit sudah dibuat sejumlah " + lblTotalAmount.Text);
}
this.Close();
}
}
}
public void EditTest()
{
SaleReturn v = new SaleReturn();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
v.SRID = "qH2ATmQ";
v.CustomersID = AddCustomers();
v.DepotsID = AddDepots();
v.SRState = SCMSupplyChain.Model.SRState.未定义3;
v.SRDesc = "jubk";
context.Set <SaleReturn>().Add(v);
context.SaveChanges();
}
SaleReturnVM vm = _controller.Wtm.CreateVM <SaleReturnVM>();
var oldID = v.ID;
v = new SaleReturn();
v.ID = oldID;
v.SRID = "2Fx2f";
v.SRState = SCMSupplyChain.Model.SRState.未定义3;
v.SRDesc = "L62";
vm.Entity = v;
vm.FC = new Dictionary <string, object>();
vm.FC.Add("Entity.SRID", "");
vm.FC.Add("Entity.CustomersID", "");
vm.FC.Add("Entity.DepotsID", "");
vm.FC.Add("Entity.SRState", "");
vm.FC.Add("Entity.SRDesc", "");
var rv = _controller.Edit(vm);
Assert.IsInstanceOfType(rv, typeof(OkObjectResult));
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var data = context.Set <SaleReturn>().Find(v.ID);
Assert.AreEqual(data.SRID, "2Fx2f");
Assert.AreEqual(data.SRState, SCMSupplyChain.Model.SRState.未定义3);
Assert.AreEqual(data.SRDesc, "L62");
Assert.AreEqual(data.UpdateBy, "user");
Assert.IsTrue(DateTime.Now.Subtract(data.UpdateTime.Value).Seconds < 10);
}
}
public void GetTest()
{
SaleReturn v = new SaleReturn();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
v.SRID = "qH2ATmQ";
v.CustomersID = AddCustomers();
v.DepotsID = AddDepots();
v.SRState = SCMSupplyChain.Model.SRState.未定义3;
v.SRDesc = "jubk";
context.Set <SaleReturn>().Add(v);
context.SaveChanges();
}
var rv = _controller.Get(v.ID.ToString());
Assert.IsNotNull(rv);
}
/// <summary>
/// 插入更新页面
/// </summary>
/// <returns></returns>
public IActionResult Edit()
{
try
{
string return_index = Convert.ToString(Request.Query["return_index"]);
int seq_id = Convert.ToInt32(Request.Query["seq_id"]);
ViewBag.return_index = return_index;
ViewBag.seq_id = seq_id;
SaleReturn res = SM.SelectSingleBySeqReturnIndex(seq_id, return_index);
return(View(res));
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 查询单笔退货信息
/// </summary>
/// <param name="id">用户id</param>
/// <returns></returns>
public SaleReturn SelectSingleBySeqReturnIndex(int seq_id, string return_index)
{
try
{
SaleReturn obj = new SaleReturn();
string sql = "select a.deliver_index,a.deliver_company_head,b.order_index,d.company_name,b.company_order_index,a.id," +
"c.order_time,c.order_name,c.order_num,c.order_price,c.purchase_person,c.unit,a.real_num,a.deliver_price,a.deliver_all_price," +
"e.return_num,e.return_time,e.return_price,e.return_all_price,e.remark,e.seq_id,c.open_num,c.tui_num " +
"from jinchen.salereturn_info e, jinchen.sale_info a, jinchen.order_info b, jinchen.orderseq_info c, jinchen.company_info d " +
"where a.order_id = b.id and b.id = c.order_id and a.seq_id = c.seq_id and e.seq_id=a.seq_id and b.customer_id = d.id and a.seq_id ={0} and e.return_index='{1}' ";
sql = string.Format(sql, seq_id, return_index);
obj = PostgreHelper.GetSingleEntity <SaleReturn>(sql);
return(obj);
}
catch (Exception ex)
{
throw ex;
}
}
private async void dgvSaleReturn_CellDoubleClick(object sender, DataGridViewCellEventArgs e)
{
try
{
if (dgvSaleReturn.CurrentRow != null)
{
var row = dgvSaleReturn.CurrentRow.Cells;
int id = Convert.ToInt32(row["Id"].Value);
//Console.WriteLine(id);
SaleReturn _saleReturn = await _saleReturnRepository.Find(id);
EditSaleReturn editSaleReturn = new EditSaleReturn(_saleReturn);
editSaleReturn.Show();
}
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
protected void btnSaveReturn_Click(object sender, EventArgs e)
{
SaleReturn objSaleReturn = new SaleReturn();
SaleReturnBiz objSaleReturnBiz = new SaleReturnBiz();
objSaleReturn.InvoiceNumber = Convert.ToInt32(txtSaleInvoiceNumber.Text.Trim());
//objSaleReturn.CustomerId = Convert.ToInt32(txtCustomerUsername.Text);
//objSaleReturn.ProductId = Convert.ToInt16(txtSaleReturnProductCode.Text.Trim());
//objSaleReturn.ReturnQuantity = Convert.ToDecimal(txtSaleReturnQty.Text.Trim());
//objSaleReturn.ReturnAmount = Convert.ToDecimal(txtReturnTotalAmount.Text.Trim());
objSaleReturn.CreatedBy = Convert.ToInt16(Session["UserId"].ToString());
objSaleReturn.Remarks = txtRemark.Text.Trim();
for (int i = 0; i < GvReturnSell.Rows.Count; i++)
{
objSaleReturn.ProductId = short.Parse(GvReturnSell.Rows[i].Cells[0].Text);
objSaleReturn.ReturnQuantity = decimal.Parse(GvReturnSell.Rows[i].Cells[2].Text);
objSaleReturnBiz.ReturnProduct(objSaleReturn);
}
GvReturnSell.Visible = false;
}
/// <summary>
/// 确认数据
/// </summary>
/// <returns></returns>
public IActionResult Confirm()
{
try
{
//将退单状态改为1，保存到退单历史
string return_index = Convert.ToString(HttpContext.Request.Form["return_index"]);
int seq_id = Convert.ToInt32(HttpContext.Request.Form["seq_id"]);
//更新退单的状态
int count = SM.UpdateReturnStatus(return_index, seq_id);
//将退单的数量加到对应订单中的剩余数量中，开单数量不变
SaleReturn saleReturn = SM.SelectSingleBySeqReturnIndex(seq_id, return_index);
Order orderOld = OM.SelectByOrderSeqId(seq_id);
Order orderNew = new Order();
orderNew.seq_id = seq_id;
orderNew.open_num = orderOld.open_num;
orderNew.tui_num = orderOld.tui_num + saleReturn.return_num;
OM.UpdateSeqNum(orderNew);
//退单确认后更新订单的状态（不管原来订单是否完成，全部改为0）
Order order = new Order();
order.seq_id = seq_id;
order.order_status = 0;
OM.UpdateOrderStatus(order);
if (count > 0)
{
return(Json("Success"));
}
else
{
return(Json("Fail"));
}
}
catch (Exception ex)
{
throw ex;
}
}
/// <summary>
/// 编辑处理页面
/// </summary>
/// <returns></returns>
public IActionResult EditHandle(SaleReturn saleReturn)
{
SaleReturn saleReturnNew = new SaleReturn();
saleReturnNew.return_index = saleReturn.return_index;
saleReturnNew.seq_id = saleReturn.seq_id;
saleReturnNew.return_num = saleReturn.return_num;
saleReturnNew.return_price = saleReturn.return_price;
saleReturnNew.return_all_price = saleReturn.return_all_price;
saleReturnNew.remark = saleReturn.remark;
int count = SM.Update(saleReturnNew);
if (count > 0)
{
return(Json("Success"));
}
else
{
return(Json("Fail"));
}
}
public JavaScriptResult Create(SaleReturnViewModel saleReturnvm, string Type)
{
try
{
if (saleReturnvm.SaleReturnDetails.Any(x => x.Select && x.ReturnQuantity > 0))
{
SaleReturn saleReturn = Mapper.Map <SaleReturn>(saleReturnvm);
List <SaleReturnDetail> saleReturnDetailList = Mapper.Map <List <SaleReturnDetail> >(saleReturnvm.SaleReturnDetails.Where(x => x.Select && x.ReturnQuantity > 0));
saleReturn.SaleReturnDetails = new List <SaleReturnDetail>();
foreach (var item in saleReturnDetailList)
{
saleReturn.SaleReturnDetails.Add(item);
}
_saleReturnService.Add(saleReturn, Type);
return(JavaScript($"ShowResult('{"Data saved successfully."}','{"success"}','{"redirect"}','{"/SuperShopSaleReturn/Index?companyId=" + saleReturn.CompanyId + "&&branchId=" + saleReturn.BranchId}')"));
}
return(JavaScript($"ShowResult('{"Enter quantity!"}','{"failure"}')"));
}
catch (Exception ex)
{
return(JavaScript($"ShowResult('{ex.Message}','failure')"));
}
}
public async Task <IActionResult> Create(SaleReturn saleReturn)
{
int count = _context.SaleReturns.Count() + 1;
saleReturn.VoucharNo = "SRV000" + count.ToString();
saleReturn.Status = 0;
if (ModelState.IsValid)
{
_context.Add(saleReturn);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
var sale = _context.Sales
.Include(m => m.Purchase)
.Include(m => m.Purchase.Product)
.Include(m => m.Purchase.PackSize)
.Where(m => m.Id == saleReturn.SaleId).FirstOrDefault();
ViewData["Sale"] = sale;
return(View(saleReturn));
}
public void BatchDeleteTest()
{
SaleReturn v1 = new SaleReturn();
SaleReturn v2 = new SaleReturn();
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
v1.SRID = "qH2ATmQ";
v1.CustomersID = AddCustomers();
v1.DepotsID = AddDepots();
v1.SRState = SCMSupplyChain.Model.SRState.未定义3;
v1.SRDesc = "jubk";
v2.SRID = "2Fx2f";
v2.CustomersID = v1.CustomersID;
v2.DepotsID = v1.DepotsID;
v2.SRState = SCMSupplyChain.Model.SRState.未定义3;
v2.SRDesc = "L62";
context.Set <SaleReturn>().Add(v1);
context.Set <SaleReturn>().Add(v2);
context.SaveChanges();
}
var rv = _controller.BatchDelete(new string[] { v1.ID.ToString(), v2.ID.ToString() });
Assert.IsInstanceOfType(rv, typeof(OkObjectResult));
using (var context = new DataContext(_seed, DBTypeEnum.Memory))
{
var data1 = context.Set <SaleReturn>().Find(v1.ID);
var data2 = context.Set <SaleReturn>().Find(v2.ID);
Assert.AreEqual(data1.IsValid, false);
Assert.AreEqual(data2.IsValid, false);
}
rv = _controller.BatchDelete(new string[] {});
Assert.IsInstanceOfType(rv, typeof(OkResult));
}
private void BtnAddReturns_Click(object sender, EventArgs e)
{
if (_lastSelectedFakturPajaks_Id == null)
{
Util.displayMessageBoxError("Double click faktur pajak");
}
else
{
if (!Util.selectedItemIsNotNull(dgv, col_dgv_Customers_Id))
{
Util.displayMessageBoxError("Invalid Customer");
}
else
{
Returns.Main_Form form = new Returns.Main_Form(FormModes.Browse, (Guid)Util.getSelectedRowValue(dgv, col_dgv_Customers_Id));
Util.displayForm(null, form);
if (form.DialogResult == DialogResult.OK)
{
SaleReturn.update_FakturPajaks_Id(form.BrowsedItemSelectionId, (Guid)_lastSelectedFakturPajaks_Id);
populateGridReturns(true);
}
}
}
}
public void ReturnProduct(SaleReturn objSaleReturn)
{
objDataAccess = DataAccess.NewDataAccess();
objDbCommand = objDataAccess.GetCommand(true, IsolationLevel.Serializable);
int noOfAffacted = 0;
objDbCommand.AddInParameter("InvoiceNumber", objSaleReturn.InvoiceNumber);
objDbCommand.AddInParameter("ProductId", objSaleReturn.ProductId);
objDbCommand.AddInParameter("ReturnQuantity", objSaleReturn.ReturnQuantity);
objDbCommand.AddInParameter("UserId", objSaleReturn.CreatedBy);
objDbCommand.AddInParameter("Remarks", objSaleReturn.Remarks ?? (object)DBNull.Value);
try
{
noOfAffacted = objDataAccess.ExecuteNonQuery(objDbCommand, "[rdb].[uspReturnSale]", CommandType.StoredProcedure);
if (noOfAffacted > 0)
{
objDbCommand.Transaction.Commit();
}
else
{
objDbCommand.Transaction.Rollback();
}
}
catch (Exception ex)
{
objDbCommand.Transaction.Rollback();
throw new Exception("Database Error Occured", ex);
}
finally
{
objDataAccess.Dispose(objDbCommand);
}
}
