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