public ActionResult AddNewProduct(Product model, int[] company, int[] color) { ViewBag.Color = new SelectList(contex.Colors.ToList(), "ColorId", "Name"); ViewBag.Company = new SelectList(contex.Companies.ToList(), "CompanyId", "Name"); int c = contex.Products.Where(C => C.Name == model.Name).Select(s => s.ProductId).FirstOrDefault(); if (c > 0) { TempData["UnsuccessMessageProduct"] = "This Product Name Already Added "; } else if (ModelState.IsValid) { Product product = contex.Products.Add(model); contex.SaveChanges(); TempData["SuccessMessageProduct"] = "Product Added Successful "; if (company != null) { foreach (var i in company) { ProductCompany productCompany = new ProductCompany(); productCompany.ProductId = product.ProductId; productCompany.CompanyId = i; contex.ProductCompanies.Add(productCompany); contex.SaveChanges(); } } if (color != null) { foreach (var i in color) { ProductColor clr = new ProductColor(); clr.ProductId = product.ProductId; clr.ColorId = i; contex.ProductColors.Add(clr); contex.SaveChanges(); } } } return(View(model)); }
public ActionResult ProductCompany(ProductCompany obj, FormCollection fc) { try { obj.radio = fc["radio"].ToString(); obj.mobileNumber = fc["mobileNumber"].ToString(); obj.phoneNumber = fc["phoneNumber"].ToString(); BL_ProductCompany save_list = new BL_ProductCompany(); if (save_list.Check_productCompany(obj.nameID, obj.name)) { if (save_list.SAVE(obj)) { if (obj.nameID > 0) { ModelState.Clear(); TempData["Msg"] = "Product Company Name Updated Successfully !"; return(RedirectToAction("ProductCompany", "ProductCompany")); } else { ModelState.Clear(); TempData["Msg"] = "Product Company Name Saved Successfully !"; return(RedirectToAction("ProductCompany", "ProductCompany")); } } } else { ModelState.Clear(); TempData["Msg"] = "Product Company Name is Already Exists"; return(RedirectToAction("ProductCompany", "ProductCompany")); } return(RedirectToAction("ProductCompany", "ProductCompany")); } catch (Exception ex) { return(RedirectToAction("ProductCompany", "ProductCompany")); } }
public ActionResult AjaxMethod(string city) { KeystoneProject.Buisness_Logic.PharmacyMaster.BL_ProductCompany BL_obj = new BL_ProductCompany(); KeystoneProject.Models.PharmacyMaster.ProductCompany obj = new ProductCompany(); List <string> searchList = new List <string>(); DataTable td = new DataTable(); DataSet ds = bl_pComp.BindCity(city, "%"); td = bl_pComp.GetCountryStateID(Convert.ToInt16(ds.Tables[0].Rows[0]["CityID"].ToString())); obj.state = td.Rows[0]["StateName"].ToString(); obj.country = td.Rows[0]["CountryName"].ToString(); obj.stateID = td.Rows[0]["StateID"].ToString(); obj.countryID = td.Rows[0]["CountryID"].ToString(); searchList.Add(obj.state); searchList.Add(obj.country); searchList.Add(obj.stateID); searchList.Add(obj.countryID); return(Json(searchList)); }
public bool SAVE(ProductCompany obj) { Connect(); SqlCommand cmd = new SqlCommand("IUProductCompany", con); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.AddWithValue("@HospitalID", HospitalID); cmd.Parameters.AddWithValue("@LocationID", LocationID); if (obj.nameID == 0) { cmd.Parameters.AddWithValue("@ProductCompanyNameID", 0); cmd.Parameters.AddWithValue("@Mode", "Add"); } else { cmd.Parameters.AddWithValue("@ProductCompanyNameID", obj.nameID); cmd.Parameters.AddWithValue("@Mode", "Edit"); } cmd.Parameters.AddWithValue("@ReferenceCode", 0); cmd.Parameters.AddWithValue("@ProductCompanyName", obj.name); cmd.Parameters.AddWithValue("@SalesTaxID", obj.salesTaxID); cmd.Parameters.AddWithValue("@PurchaseTaxID", obj.purchaseTaxID); cmd.Parameters.AddWithValue("@ShortName", obj.shortName); cmd.Parameters.AddWithValue("@Margin", obj.margin); cmd.Parameters.AddWithValue("@LTEProducts", obj.lteProducts); cmd.Parameters.AddWithValue("@LTIProducts", obj.ltiProducts); if (obj.radio == null) { cmd.Parameters.AddWithValue("@Exclusive", false); cmd.Parameters.AddWithValue("@Inclusive", false); } else if (obj.radio == "Exclusive") { cmd.Parameters.AddWithValue("@Exclusive", true); cmd.Parameters.AddWithValue("@Inclusive", false); } else if (obj.radio == "Inclusive") { cmd.Parameters.AddWithValue("@Exclusive", false); cmd.Parameters.AddWithValue("@Inclusive", true); } else { cmd.Parameters.AddWithValue("@Exclusive", false); cmd.Parameters.AddWithValue("@Inclusive", false); } //cmd.Parameters.AddWithValue("@Exclusive", obj.Exclusive); //cmd.Parameters.AddWithValue("@Inclusive", obj.Inclusive); cmd.Parameters.AddWithValue("@ExclusiveTax", obj.exclusiveTax); cmd.Parameters.AddWithValue("@Address", obj.address); cmd.Parameters.AddWithValue("@CityID", obj.cityID); cmd.Parameters.AddWithValue("@StateID", obj.stateID); cmd.Parameters.AddWithValue("@PhoneNo", obj.phoneNumber); cmd.Parameters.AddWithValue("@EmailID", obj.emailid); cmd.Parameters.AddWithValue("@PinCode", obj.pinCode); cmd.Parameters.AddWithValue("@CountryID", obj.countryID); cmd.Parameters.AddWithValue("@MobileNo", obj.mobileNumber); cmd.Parameters.AddWithValue("@CreationID", UserID); con.Open(); int i = cmd.ExecuteNonQuery(); con.Close(); if (i > 0) { return(true); } else { return(false); } }
public int Update(ProductCompany obj) { db.Entry(obj).State = EntityState.Modified; return db.SaveChanges(); }
public int Delete(ProductCompany objProductCompany) { // var existing = db.ProductCompanies.Find(id); db.ProductCompanies.Remove(objProductCompany); return db.SaveChanges(); }
public int Add(ProductCompany obj) { db.ProductCompanies.Add(obj); return db.SaveChanges(); }
public int EnableProductforCompany(string prodid, string companyid, bool ischecked) { try { if (!string.IsNullOrEmpty(prodid) && !string.IsNullOrEmpty(companyid)) { var prodcomp = _productCompanyRepo.GetAllProductCompanylist() .Where(p => p.ProductId == int.Parse(prodid)).SingleOrDefault(c => c.CompanyId == int.Parse(companyid)); if (prodcomp != null) { if (!ischecked) { // Delete return _productCompanyRepo.Delete(prodcomp); } } else { if (ischecked) { var obj = new ProductCompany(); obj.CompanyId = int.Parse(companyid); obj.ProductId = int.Parse(prodid); // obj.Enable = ischecked; return _productCompanyRepo.Add(obj); } } } } catch (Exception ex) { string msg = ex.Message; } return 0; }
private bool AddCompamiesByProduct(int prodId, string[] companyIds) { bool status = false; foreach (var cid in companyIds) { if (!string.IsNullOrEmpty(cid)) { var objProductCompany = new ProductCompany(); objProductCompany.ProductId = prodId; objProductCompany.CompanyId = int.Parse(cid); _productCompanyRepo.Add(objProductCompany); status = true; } } return status; }