public ActionResult AddOrEdit(GarmentViewModel sm)
{
using (ELaundryDBEntities db = new ELaundryDBEntities())
{
if (sm.GarmentId == 0)
{
tblGarment tb = new tblGarment();
tb.CategoryId = sm.CategoryId;
tb.GarmentName = sm.GarmentName;
tb.UnitPrice = sm.UnitPrice;
db.tblGarments.Add(tb);
db.SaveChanges();
return(Json(new { success = true, message = "Saved Successfully" }, JsonRequestBehavior.AllowGet));
}
else
{
tblGarment tbm = db.tblGarments.Where(m => m.GarmentId == sm.GarmentId).FirstOrDefault();
tbm.CategoryId = sm.CategoryId;
tbm.GarmentName = sm.GarmentName;
tbm.UnitPrice = sm.UnitPrice;
db.SaveChanges();
return(Json(new { success = true, message = "Updated Successfully" }, JsonRequestBehavior.AllowGet));
}
}
}
public JsonResult HighestSalesGarment()
{
DateTime dt = Convert.ToDateTime(DateTime.Today);
var lstgarment = _db.GetTotalGarmentOrderCount();
List <object> iData = new List <object>();
//Creating sample data
DataTable dtt = new DataTable();
dtt.Columns.Add("GarmentName", System.Type.GetType("System.String"));
dtt.Columns.Add("TotalOrdered", System.Type.GetType("System.Int32"));
foreach (var item in lstgarment)
{
DataRow dr = dtt.NewRow();
tblGarment tb = _db.tblGarments.Where(p => p.GarmentId == item.GarmentId).FirstOrDefault();
dr["GarmentName"] = tb.GarmentName;
dr["TotalOrdered"] = item.TotalOrdered;
dtt.Rows.Add(dr);
}
//Looping and extracting each DataColumn to List<Object>
foreach (DataColumn dc in dtt.Columns)
{
List <object> x = new List <object>();
x = (from DataRow drr in dtt.Rows select drr[dc.ColumnName]).ToList();
iData.Add(x);
}
//Source data returned as JSON
return(Json(iData, JsonRequestBehavior.AllowGet));
}
public ActionResult AdminRegProduct(tblGarment collection)
{
try
{
//Registro de imagen
HttpPostedFileBase FileBase = Request.Files[0];
WebImage image = new WebImage(FileBase.InputStream);
string idUser = System.Web.HttpContext.Current.Session["id"].ToString();
SqlParameter param1 = new SqlParameter("@name", collection.gmtName);
SqlParameter param2 = new SqlParameter("@tipo", collection.gmtType);
SqlParameter param3 = new SqlParameter("@condicion", collection.gmtCondition);
SqlParameter param4 = new SqlParameter("@precio", collection.gmtPrice);
SqlParameter param5 = new SqlParameter("@user", idUser);
SqlParameter param6 = new SqlParameter("@img", collection.gmtImage = image.GetBytes());
//Registro de producto
var db = new DBPawnshopEntitiesConection();
db.Database.ExecuteSqlCommand("setGarmet @name, @tipo, @condicion, @precio,@user,@img", param1, param2, param3, param4, param5, param6);
TempData["Prueba"] = "SI";
@ViewData["ID"] = TempData["Prueba"];
return(View());
}
catch (Exception e)
{
return(View(e.Message));
}
}
public ActionResult ManageOrder(List <tblTempOrder> lst)
{
if (lst != null)
{
//List<tblTempOrder> neworder = new List<tblTempOrder>();
List <TempOrderViewModel> neworder = new List <TempOrderViewModel>();
foreach (var item in lst)
{
TempOrderViewModel tb = new TempOrderViewModel();
tblGarment tbpro = _db.tblGarments.Where(p => p.GarmentId == item.GarmentId).FirstOrDefault();
tb.GarmentId = item.GarmentId;
tb.GarmentName = tbpro.GarmentName;
tb.UnitPrice = item.UnitPrice;
tb.Quantity = item.Quantity;
tb.Total = item.Total;
tb.TokenNo = item.TokenNo;
tb.TW = item.TW;
tb.BranchId = Convert.ToInt32(Session["branchid"]);
tb.ItemState = "Queued";
neworder.Add(tb);
}
TempData["mytemp"] = neworder;
//List<tblTempOrder> temporder = TempData["mytemp"] as List<tblTempOrder>;
return(Json(1, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(0, JsonRequestBehavior.AllowGet));
}
}
public ActionResult UserRegSolicitud(tblGarment collection)
{
//Creación de sesión del producto
var optionValue = Request.Form["Producto"];
System.Web.HttpContext.Current.Session["idGar"] = optionValue;
return(RedirectToAction("UserRegSolicitud2"));
}
public ActionResult AdminDeleteProduct(tblGarment collection)
{
//Selección del producto
var optionValue = Request.Form["Producto"];
System.Web.HttpContext.Current.Session["idGar"] = optionValue;
return(RedirectToAction("AdminDeleteProduct2"));
}
public ActionResult Delete(int id)
{
using (ELaundryDBEntities db = new ELaundryDBEntities())
{
tblGarment sm = db.tblGarments.Where(x => x.GarmentId == id).FirstOrDefault();
db.tblGarments.Remove(sm);
db.SaveChanges();
return(Json(new { success = true, message = "Deleted Successfully" }, JsonRequestBehavior.AllowGet));
}
}
//Obtención de imagen de producto
public ActionResult getImageGar(string id)
{
var db = new DBPawnshopEntitiesConection();
tblGarment img = db.tblGarment.Find(id);
byte[] byteImage = img.gmtImage;
MemoryStream memoryStream = new MemoryStream(byteImage);
System.Drawing.Image image = System.Drawing.Image.FromStream(memoryStream);
memoryStream = new MemoryStream();
image.Save(memoryStream, ImageFormat.Jpeg);
memoryStream.Position = 0;
return(File(memoryStream, "image/jpg"));
}
public JsonResult CheckGarment(string GarmentName)
{
bool isexists = false;
tblGarment tb = db.tblGarments.Where(c => c.GarmentName == GarmentName).FirstOrDefault();
if (tb != null)
{
isexists = true;
}
else
{
isexists = false;
}
return(Json(isexists, JsonRequestBehavior.AllowGet));
}
public ActionResult getImage()
{
//Obtención de imagen
string idProd = System.Web.HttpContext.Current.Session["idProduct"].ToString();
var db = new DBPawnshopEntitiesConection();
tblGarment img = db.tblGarment.Find(idProd);
byte[] byteImage = img.gmtImage;
//Asignación a memoria
MemoryStream memoryStream = new MemoryStream(byteImage);
System.Drawing.Image image = System.Drawing.Image.FromStream(memoryStream);
memoryStream = new MemoryStream();
image.Save(memoryStream, ImageFormat.Jpeg);
memoryStream.Position = 0;
return(File(memoryStream, "image/jpg"));
}
public ActionResult AdminEditProduct2(tblGarment collection)
{
//Obtención de datos del formulario
var db = new DBPawnshopEntitiesConection();
tblGarment _dbp = new tblGarment();
HttpPostedFileBase FileBase = Request.Files[0];
string idProd = System.Web.HttpContext.Current.Session["idGar"].ToString();
string idUser = System.Web.HttpContext.Current.Session["id"].ToString();
//Validación de edición de imagen
if (FileBase.ContentLength == 0)
{
//Edición de producto con misma imagen
_dbp = db.tblGarment.Find(idProd);
SqlParameter param1 = new SqlParameter("@id", idProd);
SqlParameter param2 = new SqlParameter("@name", collection.gmtName);
SqlParameter param3 = new SqlParameter("@tipo", collection.gmtType);
SqlParameter param4 = new SqlParameter("@condicion", collection.gmtCondition);
SqlParameter param5 = new SqlParameter("@precio", collection.gmtPrice);
SqlParameter param6 = new SqlParameter("@user", idUser);
SqlParameter param7 = new SqlParameter("@img", collection.gmtImage = _dbp.gmtImage);
var data = db.Database.ExecuteSqlCommand("updateGarmetData @id, @name,@tipo,@condicion,@precio,@user,@img", param1, param2, param3, param4, param5, param6, param7);
TempData["Prueba"] = "SI";
@ViewData["ID"] = TempData["Prueba"];
return(View());
}
else
{
//Edición de producto con nueva imagen
WebImage image = new WebImage(FileBase.InputStream);
SqlParameter param1 = new SqlParameter("@id", idProd);
SqlParameter param2 = new SqlParameter("@name", collection.gmtName);
SqlParameter param3 = new SqlParameter("@tipo", collection.gmtType);
SqlParameter param4 = new SqlParameter("@condicion", collection.gmtCondition);
SqlParameter param5 = new SqlParameter("@precio", collection.gmtPrice);
SqlParameter param6 = new SqlParameter("@user", idUser);
SqlParameter param7 = new SqlParameter("@img", collection.gmtImage = image.GetBytes());
var data = db.Database.ExecuteSqlCommand("updateGarmetData @id, @name,@tipo,@condicion,@precio,@user,@img", param1, param2, param3, param4, param5, param6, param7);
TempData["Prueba"] = "SI";
@ViewData["ID"] = TempData["Prueba"];
return(View());
}
}
