public ActionResult EditSupplier(int?id)
{
if (id == null)
{
return(View("EditSupplier"));
}
using (TimchurDatabaseEntities entity = new TimchurDatabaseEntities())
{
Suppliers sup = entity.Suppliers.Where(x => x.ID == id).First();
if (sup == null)
{
return(View("EditSupplier"));
}
else
{
SupplierFModel fm = new SupplierFModel();
fm.supliers = sup;
List <int?> fl = new List <int?>();
foreach (SuppliersClusetrs ua in sup.SuppliersClusetrs)
{
if (ua.Statuses.ID == 1)
{
fl.Add(ua.ClusetrID);
}
}
fm.Limitions = fl;
return(View("EditSupplier", fm));
}
}
}
public ActionResult EditSupplier(SupplierFModel sup)
{
if (ModelState.IsValid)
{
SingletonCache.Instance().Storage[User.Identity.Name] = sup;
return(RedirectToAction("ESupplierLoadingScreen", "Main"));
}
else
{
return(View(sup));
}
}
public ActionResult AddSupplier(SupplierFModel sup)
{
if (ModelState.IsValid)
{
using (TimchurDatabaseEntities entity = new TimchurDatabaseEntities())
{
int cou = entity.Suppliers.Count(x => x.Name == sup.supliers.Name);
if (cou != 0)
{
ModelState.AddModelError("Exist", "יחידה בעלת מספר זה כבר קיים.");
return(View(sup));
}
else
{
SingletonCache.Instance().Storage[User.Identity.Name] = sup;
return(RedirectToAction("SupplierLoadingScreen", "Main"));
}
}
}
else
{
return(View(sup));
}
}
public ActionResult ESupplierLoadingScreen(SupplierFModel target)
{
return(View(target));
}
public void editSupplierOperation()
{
int?id = -1;
Cache.gen_lock.WaitOne();
SupplierFModel mf = ((SupplierFModel)SingletonCache.Instance().Storage[Context.User.Identity.Name]);
try
{
using (TimchurDatabaseEntities entity = new TimchurDatabaseEntities())
{
var original = entity.Suppliers.Find(mf.supliers.ID);
if (original != null)
{
if (mf.Limitions != null)
{
foreach (int i in mf.Limitions)
{
SuppliersClusetrs ua = new SuppliersClusetrs();
if (entity.SuppliersClusetrs.Where(x => x.ClusetrID == i && x.SupplierID == mf.supliers.ID).Count() > 0)
{
entity.SuppliersClusetrs.Where(x => x.ClusetrID == i && x.SupplierID == mf.supliers.ID).First().StatusID = 1;
}
else
{
ua.ClusetrID = i;
ua.SupplierID = id;
ua.FormarLastTimeInList = new DateTime(2000, 1, 1);
ua.LastTimeInList = new DateTime(2000, 1, 1);
ua.StatusID = 1;
entity.SuppliersClusetrs.Add(ua);
}
}
}
foreach (SuppliersClusetrs sc in entity.SuppliersClusetrs.Where(x => !mf.Limitions.Contains(x.ClusetrID) && x.SupplierID == mf.supliers.ID))
{
sc.StatusID = 2;
}
if (mf.ActualEmail == null)
{
mf.supliers.EmailAddress = "";
}
else
{
mf.supliers.EmailAddress = mf.ActualEmail;
}
mf.supliers.PhoneNumber = mf.Prefix + mf.ActualNumber;
entity.Entry(original).CurrentValues.SetValues(((SupplierFModel)SingletonCache.Instance().Storage[Context.User.Identity.Name]).supliers);
entity.SaveChanges();
}
}
using (TimchurDatabaseEntities entity2 = new TimchurDatabaseEntities())
{
int strm = mf.supliers.ID;
id = entity2.Suppliers.Where(x => x.ID == strm).First().ID;
}
SingletonCache.Instance().last_msg[Context.User.Identity.Name] = "בפעולה האחרונה,יחידה עודכה במערכת";
}
catch (Exception e)
{
SingletonCache.Instance().last_msg[Context.User.Identity.Name] = "בפעולה האחרונה,הוספת יחידה נכשלה במערכת";
}
Cache.gen_lock.ReleaseMutex();
string str = Context.User.Identity.Name;
string msg = "";
if (SingletonCache.Instance().last_msg.Keys.Contains(str))
{
msg = SingletonCache.Instance().last_msg[str];
}
string to_s = string.Format("סטאטוס:" + msg);
Clients.Caller.sendMessage(id.Value.ToString());
}
public void AddSupplierOperation()
{
int?id = -1;
Cache.gen_lock.WaitOne();
SupplierFModel mf = ((SupplierFModel)SingletonCache.Instance().Storage[Context.User.Identity.Name]);
try
{
using (TimchurDatabaseEntities entity = new TimchurDatabaseEntities())
{
if (mf.ActualEmail == null)
{
mf.supliers.EmailAddress = "";
}
else
{
mf.supliers.EmailAddress = mf.ActualEmail;
}
mf.supliers.PhoneNumber = mf.Prefix + mf.ActualNumber;
entity.Suppliers.Add(mf.supliers);
entity.SaveChanges();
}
using (TimchurDatabaseEntities entity2 = new TimchurDatabaseEntities())
{
string strm = mf.supliers.Name;
id = entity2.Suppliers.Where(x => x.Name == strm).First().ID;
if (mf.Limitions != null)
{
foreach (int i in mf.Limitions)
{
SuppliersClusetrs ua = new SuppliersClusetrs();
ua.ClusetrID = i;
ua.SupplierID = id;
ua.FormarLastTimeInList = new DateTime(2000, 1, 1);
ua.LastTimeInList = new DateTime(2000, 1, 1);
ua.StatusID = 1;
entity2.SuppliersClusetrs.Add(ua);
}
}
entity2.SaveChanges();
}
SingletonCache.Instance().last_msg[Context.User.Identity.Name] = "בפעולה האחרונה,ספק נוספה למערכת";
}
catch (Exception e)
{
SingletonCache.Instance().last_msg[Context.User.Identity.Name] = "בפעולה האחרונה,הוספת ספק נכשלה";
}
Cache.gen_lock.ReleaseMutex();
string str = Context.User.Identity.Name;
string msg = "";
if (SingletonCache.Instance().last_msg.Keys.Contains(str))
{
msg = SingletonCache.Instance().last_msg[str];
}
string to_s = string.Format("סטאטוס:" + msg);
Clients.Caller.sendMessage(id.Value.ToString());
}
