protected void btnAddFooter_OnClick(object sender, ImageClickEventArgs e) { try { var desValue = ((TextBox)gridFactor.FooterRow.Cells[1].Controls[1]).Text; var unitValue = ((DropDownList)gridFactor.FooterRow.Cells[2].Controls[1]).SelectedValue; var countValue = ((TextBox)gridFactor.FooterRow.Cells[3].Controls[1]).Text; //var weightValue = ((TextBox)gridFactor.FooterRow.Cells[4].Controls[1]).Text; var priceValue = ((TextBox)gridFactor.FooterRow.Cells[5].Controls[1]).Text; var fd = new FactorDetail(); fd.RowNumber = ((List <FactorDetail>)Session["GridSource"]).Max(a => a.RowNumber) + 1; fd.Description = desValue; fd.GoodsUnitId = unitValue.ToSafeInt(); fd.Count = countValue.ToSafeDecimal(); //fd.Weight = weightValue.ToSafeDecimal(); fd.Price = priceValue.ToSafeDecimal(); ((List <FactorDetail>)Session["GridSource"]).Add(fd); BindData(); } catch (Exception ex) { Debuging.Error(ex, MethodBase.GetCurrentMethod().Name); ShowErrorMsg(MessageText.UNKNOWN_ERROR); } }
public Message AddOrEdit(FactorDetail factorDetail) { var message = new Message(); var ID = factorDetail.FactorDetailId; int result = _iFactorDetailRepository.AddOrEdit(factorDetail); try { if (result > 0) { if (Convert.ToInt32(ID) > 0) { message = Message.SetMessages.SetSuccessMessage("Submission Updated Successfully!"); } else { message = Message.SetMessages.SetSuccessMessage("Submission Successful!"); } } else { message = Message.SetMessages.SetErrorMessage("Could not be submitted!"); } } catch (Exception e) { message = Message.SetMessages.SetWarningMessage(e.Message.ToString()); } return(message); }
//ثبت تمامی سفارشات private void submit_Click(object sender, EventArgs e) { if (dgvFactorDetails.Rows.Count == 0) { Service.ChangeForm(new Main(), this); return; } Factor factor = new Factor() { Date = DateTime.Now, TotalPrice = double.Parse(txtTotalPrice.Text.Replace(".", "").Replace("$", "")), TotalPriceWithTax = double.Parse(txtTotalPriceWithTax.Text.Replace(".", "").Replace("$", "")) }; _factorService.Add(factor); foreach (DataGridViewRow current in dgvFactorDetails.Rows) { if (current.Cells[0].Value == null) { continue; } var f = new FactorDetail() { Count = int.Parse(current.Cells[1].Value.ToString()), Description = current.Cells[2].Value?.ToString() ?? "", ProductId = _productService.GetIdByName(current.Cells[0].Value.ToString()), Factor = factor, TotalPrice = double.Parse(current.Cells[4].Value.ToString()) }; _factorDetailService.Add(f); } _uow.SaveChanges(); Service.ChangeForm(new Main(), this); }
public ActionResult AddOrEdit(int id = 0) { FactorDetail factorDetail = new FactorDetail(); if (id != 0) { factorDetail = _iFactorDetailManager.GetAFactorDetail(id); } return(View(factorDetail)); }
public virtual ActionResult RegisterFactor() { List <RegisterOrderViewModel> ListOrder = TempData["ListOrder"] as List <RegisterOrderViewModel>; if (ListOrder == null) { return(RedirectToAction("Index", "OrderMe")); } bool success = false; try { var customer = db.Users .Where(C => C.Name == User.Identity.Name) .FirstOrDefault(); Factor oFactor = new Factor(); oFactor.Date = DateTime.Now; oFactor.UserName = User.Identity.Name; oFactor.FactorDetails = new List <FactorDetail>(); oFactor.Mobile = customer.Mobile; oFactor.Address = customer.Address; oFactor.Description = TempData["description"] as string; foreach (var item in ListOrder) { FactorDetail oFactorDetail = new FactorDetail(); oFactorDetail.Name = item.Name; oFactorDetail.Price = item.Price; oFactorDetail.ProductId = item.Id; oFactorDetail.FactorId = oFactor.Id; oFactorDetail.Count = item.count; oFactor.FactorDetails.Add(oFactorDetail); } db.Factors.Add(oFactor); db.SaveChanges(); success = true; if (Request.Cookies["listProduct"] != null) { Response.Cookies.Remove("listProduct"); Response.Cookies["listProduct"].Expires = DateTime.Now.AddDays(-1); Session.Abandon(); } } catch (Exception) { success = false; } ViewBag.success = success; return(View()); }
public async static Task <IDTO> AddUpdate(FactorDetail factor) { string SPName = ""; string message = ""; OracleDynamicParameters oracleParams = new OracleDynamicParameters(); ComplateOperation <int> complate = new ComplateOperation <int>(); if (factor.ID.HasValue) { oracleParams.Add(FactorDetailSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.ID ?? DBNull.Value); SPName = FactorDetailSpName.SP_UPADTE_FACTOR_DETAIL; message = "Updated Successfully"; } else { oracleParams.Add(FactorDetailSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Output); SPName = FactorDetailSpName.SP_INSERT_FACTOR_DETAIL; message = "Inserted Successfully"; } oracleParams.Add(FactorDetailSpParams.PARAMETER_NAME, OracleDbType.Varchar2, ParameterDirection.Input, (object)factor.Name ?? DBNull.Value); oracleParams.Add(FactorDetailSpParams.PARAMETER_NAME2, OracleDbType.Varchar2, ParameterDirection.Input, (object)factor.Name2 ?? DBNull.Value); oracleParams.Add(FactorDetailSpParams.PARAMETER_ST_DIC_COL_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.DictionaryID ?? DBNull.Value); oracleParams.Add(FactorDetailSpParams.PARAMETER_ENTRY_TYPE, OracleDbType.Int64, ParameterDirection.Input, (object)factor.EntryType ?? DBNull.Value); oracleParams.Add(FactorDetailSpParams.PARAMETER_ST_PRD_FACT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.FactorID ?? DBNull.Value); oracleParams.Add(FactorDetailSpParams.PARAMETER_FROM_VALUE, OracleDbType.Int64, ParameterDirection.Input, (object)factor.FromValue ?? DBNull.Value); oracleParams.Add(FactorDetailSpParams.PARAMETER_TO_VALUE, OracleDbType.Int64, ParameterDirection.Input, (object)factor.ToValue ?? DBNull.Value); oracleParams.Add(FactorDetailSpParams.PARAMETER_F_FROM_DATE, OracleDbType.Date, ParameterDirection.Input, (object)factor.FromDate ?? DBNull.Value); oracleParams.Add(FactorDetailSpParams.PARAMETER_F_TO_DATE, OracleDbType.Date, ParameterDirection.Input, (object)factor.ToDate ?? DBNull.Value); oracleParams.Add(FactorDetailSpParams.PARAMETER_ST_CHG_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.ChargeID ?? DBNull.Value); oracleParams.Add(FactorDetailSpParams.PARAMETER_ST_PRD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.ProductID ?? DBNull.Value); oracleParams.Add(FactorDetailSpParams.PARAMETER_ST_PRDT_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.ProductDetailID ?? DBNull.Value); oracleParams.Add(FactorDetailSpParams.PARAMETER_FRRMULA_EDOTORS, OracleDbType.Varchar2, ParameterDirection.Input, (object)factor.FrrmulaEdotors ?? DBNull.Value); oracleParams.Add(FactorDetailSpParams.PARAMETER_ST_PRD_FACD_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.ProductFacdID ?? DBNull.Value); if (await NonQueryExecuter.ExecuteNonQueryAsync(SPName, oracleParams) == -1) { complate.message = "Operation Success"; } else { complate.message = "Operation Failed"; } return(complate); }
public async static Task <IDTO> DeleteFactorDetail(FactorDetail factor) { OracleDynamicParameters oracleParams = new OracleDynamicParameters(); ComplateOperation <int> complate = new ComplateOperation <int>(); var dyParam = new OracleDynamicParameters(); dyParam.Add(FactorDetailSpParams.PARAMETER_ID, OracleDbType.Int64, ParameterDirection.Input, (object)factor.ID ?? DBNull.Value); if (await NonQueryExecuter.ExecuteNonQueryAsync(FactorDetailSpName.SP_DELETE_FACTOR_DETAIL, dyParam) == -1) { complate.message = "Operation Successed"; } else { complate.message = "Operation Failed"; } return(complate); }
public int AddOrEdit(FactorDetail factorDetail) { if (factorDetail.FactorDetailId == 0) { factorDetail.CreatedDate = DateTime.Now; factorDetail.UpdatedDate = DateTime.Now; factorDetail.CreatedBy = 1; factorDetail.UpdatedBy = 1; _dbContext.FactorDetails.Add(factorDetail); } else { factorDetail.UpdatedBy = 1; factorDetail.UpdatedDate = DateTime.Now; _dbContext.Entry(factorDetail).State = EntityState.Modified; } return(_dbContext.SaveChanges()); }
protected void btnAddFirstRow_OnClick(object sender, ImageClickEventArgs e) { try { var newRow = new FactorDetail(); newRow.RowNumber = 1; var source = new List <FactorDetail>(); source.Add(newRow); Session["GridSource"] = source; gridFactor.EditIndex = 0; BindData(); //((TextBox)gridFactor.Rows[gridFactor.EditIndex].Cells[1].Controls[1]).Focus(); //BindFooterGoodsUnitDrp(); } catch (Exception ex) { Debuging.Error(ex, MethodBase.GetCurrentMethod().Name); ShowErrorMsg(MessageText.UNKNOWN_ERROR); } }
public void Remove(FactorDetail fd) { _factorDetails.Remove(fd); }
public void Add(FactorDetail fd) { _factorDetails.Add(fd); }
public ActionResult AddOrEdit(FactorDetail factorDetail) { var data = _iFactorDetailManager.AddOrEdit(factorDetail); return(Json(new { messageType = data.MessageType, message = data.ReturnMessage, html = GlobalClass.RenderRazorViewToString(this, "ViewAll", _iFactorDetailManager.GetAllFactorDetail()) }, JsonRequestBehavior.AllowGet)); }
public ActionResult Sale(SaleViweModel sale, int id) { if (ModelState.IsValid) { var user = db.Users.FirstOrDefault(u => u.Mobile == User.Identity.Name); if (user != null) { string strtoday = pc.GetYear(DateTime.Now).ToString("0000") + "/" + pc.GetMonth(DateTime.Now).ToString("00") + "/" + pc.GetDayOfMonth(DateTime.Now).ToString("00"); var factor = db.Factors.FirstOrDefault(f => f.UserId == user.Id && f.IsPay == false); if (factor != null) { var det = db.FactorDetails.FirstOrDefault(d => d.factorId == factor.Id && d.ProdcutId == id); if (det != null) { det.Tedad = det.Tedad + sale.SaleCount; db.SaveChanges(); } else { FactorDetail newdetail = new FactorDetail() { factorId = factor.Id, ProdcutId = id, Tedad = sale.SaleCount }; db.FactorDetails.Add(newdetail); db.SaveChanges(); } } else { Factor newfactor = new Factor() { UserId = user.Id, IsPay = false, DateFactor = strtoday, CutPrice = 0, NumberFactor = "", SumItem = 0, Tax = 0, SumPrice = 0, NumberControl = "", DatePay = "", }; db.Factors.Add(newfactor); db.SaveChanges(); FactorDetail newdetail = new FactorDetail() { factorId = db.Factors.Max(f => f.Id), ProdcutId = id, Tedad = sale.SaleCount }; db.FactorDetails.Add(newdetail); db.SaveChanges(); } return(RedirectToAction("ShopingCart")); } else { return(RedirectToAction("Login", "Account")); } } return(PartialView()); }
public ActionResult AddToShoppingCart(ShoppingCartViewModel shoppingCart, int id) { var user = db.Users.FirstOrDefault(u => u.Mobile == User.Identity.Name); var product = db.Products.Find(id); var factor = db.Factors.FirstOrDefault(f => f.UserId == user.Id && f.IsPay == false); if (factor != null) { var detail = db.FactorDetail.FirstOrDefault(d => d.FactorId == factor.Id && d.ProductId == id); if (detail != null) { detail.Count = shoppingCart.DetailCount + detail.Count; detail.DetailPrice = product.Price; db.SaveChanges(); } else { FactorDetail factorDetail = new FactorDetail() { FactorId = factor.Id, ProductId = id, Count = shoppingCart.DetailCount, DetailPrice = product.Price }; db.FactorDetail.Add(factorDetail); db.SaveChanges(); } } else { Random random = new Random(); string str = random.Next(100000, 999999).ToString(); var address = db.Addresses.FirstOrDefault(a => a.UserId == user.Id); int addressId = 0; if (address != null) { addressId = address.Id; } Factor newfactor = new Factor() { UserId = user.Id, Date = "", PayDate = "", IsPay = false, Number = str, PayNumber = "", PayTime = "", Price = 0, AddressId = addressId }; db.Factors.Add(newfactor); db.SaveChanges(); FactorDetail factorDetail = new FactorDetail() { FactorId = newfactor.Id, ProductId = id, Count = shoppingCart.DetailCount, DetailPrice = product.Price }; db.FactorDetail.Add(factorDetail); db.SaveChanges(); } return(Redirect("/product/" + id + "/" + product.Name)); }