public JsonResult InsertProduct(product product)
{
Supplier_Details supplier_Details = new Supplier_Details();
supplier_Details.supplier_id = product.supplier_id;
supplier_Details.supplier_prd_date = DateTime.Now;
supplier_Details.supplier_prd_desc = product.prd_desc;
supplier_Details.supplier_product_categroy = product.Categ_id;
supplier_Details.supplier_product_name = product.prd_name;
supplier_Details.supplier_prd_price = product.price;
var insertsupplierdetails = db.Supplier_Details.Add(supplier_Details);
db.SaveChanges();
if (product.fileupload != null)
{
string fileName = Path.GetFileNameWithoutExtension(product.fileupload.FileName);
string extension = Path.GetExtension(product.fileupload.FileName);
fileName = fileName + DateTime.Now.ToString("yymmssff") + extension;
product.prd_img = fileName;
product.fileupload.SaveAs(Path.Combine(Server.MapPath("~/App_File/Images"), fileName));
db.products.Add(product);
db.SaveChanges();
return(Json("Added", JsonRequestBehavior.AllowGet));
}
else
{
return(Json("An Error Occured", JsonRequestBehavior.AllowGet));
}
}
public ActionResult DeleteConfirmed(int id)
{
Supplier_Details supplier_Details = db.Supplier_Details.Find(id);
db.Supplier_Details.Remove(supplier_Details);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "Supplier_Id,Company_Id,Name,Email,Mobile,Mobile1,Address,City,State,Country,Created_By,Modified_By,Date_Created,Date_Modified")] Supplier_Details supplier_Details)
{
if (ModelState.IsValid)
{
db.Entry(supplier_Details).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.Company_Id = new SelectList(db.Company_Details, "Company_Id", "Name", supplier_Details.Company_Id);
return(View(supplier_Details));
}
public GRN()
{
InitializeComponent();
GetItemCode = new GetItemCodes();
GetItemCode.FormClosed += new FormClosedEventHandler(GetItemCode_FormClosed);
GRNCheque = new ChequeGRN();
GRNCheque.FormClosed += new FormClosedEventHandler(GRNCheque_FormClosed);
SD = new Supplier_Details();
SD.FormClosed += new FormClosedEventHandler(SD_FormClosed);
}
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Supplier_Details supplier_Details = db.Supplier_Details.Find(id);
if (supplier_Details == null)
{
return(HttpNotFound());
}
return(View(supplier_Details));
}
public AddSupplier(Supplier_Details obj)
{
InitializeComponent();
if (obj == null)
{
btnUpdate.Enabled = false;
}
else
{
btnSave.Enabled = false;
supplierDetailsBindingSource.DataSource = obj;
}
}
// GET: Inventory/Supplier_Details/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
Supplier_Details supplier_Details = db.Supplier_Details.Find(id);
if (supplier_Details == null)
{
return(HttpNotFound());
}
ViewBag.Company_Id = new SelectList(db.Company_Details, "Company_Id", "Name", supplier_Details.Company_Id);
return(View(supplier_Details));
}
// GET: Inventory/Supplier_Details/Details/5
public PartialViewResult CreatePartial(int?id)
{
string Company_Id = string.Empty;
HttpCookie myCookie = Request.Cookies["inventoryCookie"];
if (!string.IsNullOrEmpty(myCookie.Values["Company_Id"]))
{
Company_Id = myCookie.Values["Company_Id"].ToString();
}
Supplier_Details car = new Supplier_Details();
if (id != null)
{
car = db.Supplier_Details.Where(c => c.Supplier_Id == id).FirstOrDefault();
}
return(PartialView(car));
}
public GRN()
{
InitializeComponent();
//This is used to clear the static general list collection of GRNChequeDataGridView
//START
ChequeGRN.GRNChequeDataGridView.Clear();
//END
GetItemCode = new GetItemCodes();
GetItemCode.FormClosed += new FormClosedEventHandler(GetItemCode_FormClosed);
GRNCheque = new ChequeGRN();
GRNCheque.FormClosed += new FormClosedEventHandler(GRNCheque_FormClosed);
SD = new Supplier_Details();
SD.FormClosed += new FormClosedEventHandler(SD_FormClosed);
}
// Add function
public string Add(string name, string email, string mobile, string address, int Id)
{
string Returns = "";
if (ModelState.IsValid)
{
string Company_Id = string.Empty;
string UserId = string.Empty;
string UserName = string.Empty;
HttpCookie myCookie = Request.Cookies["inventoryCookie"];
if (myCookie == null)
{
return("Logout");
}
if (!string.IsNullOrEmpty(myCookie.Values["Company_Id"]))
{
Company_Id = myCookie.Values["Company_Id"].ToString();
}
if (!string.IsNullOrEmpty(myCookie.Values["UserId"]))
{
UserId = myCookie.Values["UserId"].ToString();
}
if (!string.IsNullOrEmpty(myCookie.Values["UserName"]))
{
UserName = myCookie.Values["UserName"].ToString();
}
int company_Id = Convert.ToInt32(Company_Id);
if (Id != 0)
{
Supplier_Details supplier = db.Supplier_Details.Where(e => e.Supplier_Id == Id).FirstOrDefault();
supplier.Company_Id = company_Id;
supplier.Created_By = UserName;
supplier.Date_Created = DateTime.Now;
supplier.Name = name;
supplier.Email = email;
supplier.Date_Modified = DateTime.Now;
supplier.Mobile = mobile;
supplier.Address = address;
db.Entry(supplier).State = EntityState.Modified;
db.SaveChanges();
return("Supplier Updated Successfully");
}
else
{
Supplier_Details supplier = db.Supplier_Details.Where(e => e.Name == name && e.Company_Id == company_Id).FirstOrDefault();
if (supplier == null)
{
Supplier_Details supplier_Details = new Supplier_Details();
supplier_Details.Company_Id = company_Id;
supplier_Details.Created_By = UserName;
supplier_Details.Date_Created = DateTime.Now;
supplier_Details.Name = name;
supplier_Details.Email = email;
supplier_Details.Mobile = mobile;
supplier_Details.Address = address;
db.Supplier_Details.Add(supplier_Details);
db.SaveChanges();
return("Supplier Added Successfully");
}
else
{
return("Supplier Already Exist");
}
}
}
return(Returns);
}
