Esempio n. 1
0
        public static bool DeleteItem(int Id)
        {
            using (CFMMCDEntities db = new CFMMCDEntities())
            {
                if (db.ITMGRPs.Where(o => o.Id == Id).Any())
                {
                    ITMGRP IGRow = db.ITMGRPs.SingleOrDefault(o => o.Id == Id);
                    if (IGRow.Item_Type == 1)
                    {
                        db.CSHMIMP0.Single(o => o.MIMMIC == IGRow.Item_Code).Group = 0;
                    }
                    else if (IGRow.Item_Type == 2)
                    {
                        db.INVRIMP0.Single(o => o.RIMRIC == IGRow.Item_Code).Group = 0;
                    }
                    if (IGRow.Item_Type == 3)
                    {
                        db.Store_Profile.Single(o => o.STORE_NO == IGRow.Item_Code).Group = 0;
                    }
                    if (IGRow.Item_Type == 4)
                    {
                        foreach (var v in db.INVRIRP0.Where(o => o.RIRMIC == IGRow.Item_Code))
                        {
                            v.Group = 0;
                        }
                    }

                    db.ITMGRPs.Remove(IGRow);
                    // Save DB
                    try
                    {
                        db.SaveChanges();
                    }
                    catch (Exception e)
                    {
                        System.Diagnostics.Debug.WriteLine(e.Source);
                        System.Diagnostics.Debug.WriteLine(e.Message);
                        System.Diagnostics.Debug.WriteLine(e.StackTrace);
                        System.Diagnostics.Debug.WriteLine(e.InnerException);
                        Exception f = e.InnerException;
                        while (f != null)
                        {
                            System.Diagnostics.Debug.WriteLine("INNER:");
                            System.Diagnostics.Debug.WriteLine(f.Message);
                            System.Diagnostics.Debug.WriteLine(f.Source);
                            f = f.InnerException;
                        }
                        System.Diagnostics.Debug.WriteLine(e.Data);
                        return(false);
                    }
                    return(true);
                }
                return(false);
            }
        }
Esempio n. 2
0
        public static bool UpdateGroup(ItemGroupViewModel IGViewModel)
        {
            using (CFMMCDEntities db = new CFMMCDEntities())
            {
                // Update
                if (IGViewModel.GroupName == null || IGViewModel.GroupName.Equals("") || IGViewModel.GroupType == 0)
                {
                    return(false);
                }

                var IGRowLookup = db.ITMGRPs.Where(o => o.Item_Code == IGViewModel.ItemCode);
                IGRowLookup = IGRowLookup.Where(o => o.Item_Type == IGViewModel.ItemType);
                if (IGRowLookup.Any())
                {
                    return(false);
                }

                ITMGRP IGRow = new ITMGRP();
                IGRow.Id = new Random().Next(1, 999999999);
                // Get new Id if it exist
                for (int i = 0; (i < 10 && db.ITMGRPs.Where(o => o.Id == IGRow.Id).Any()); i++)
                {
                    IGRow.Id = new Random().Next(1, 999999999);
                }
                // If Group is already created
                if (db.ITMGRPs.Where(o => o.Group_Name.Equals(IGViewModel.GroupName)).Any())
                {
                    IGRow.Group_Id   = IGViewModel.GroupId;
                    IGRow.Group_Name = IGViewModel.GroupName;
                    IGRow.Item_Code  = IGViewModel.ItemCode;
                    IGRow.Item_Name  = IGViewModel.ItemName;
                    IGRow.Item_Type  = IGViewModel.ItemType;
                    IGRow.Group_Type = IGViewModel.GroupType;
                    // Add Group to Item table
                    if (IGRow.Item_Type == 1 && db.CSHMIMP0.Where(o => o.MIMMIC == IGViewModel.ItemCode).Any())
                    {
                        db.CSHMIMP0.Single(o => o.MIMMIC == IGViewModel.ItemCode).Group = IGViewModel.GroupId;
                    }
                    else if (IGRow.Item_Type == 2 && db.INVRIMP0.Where(o => o.RIMRIC == IGViewModel.ItemCode).Any())
                    {
                        db.INVRIMP0.Single(o => o.RIMRIC == IGViewModel.ItemCode).Group = IGViewModel.GroupId;
                    }
                    else if (IGRow.Item_Type == 3 && db.Store_Profile.Where(o => o.STORE_NO == IGViewModel.ItemCode).Any())
                    {
                        db.Store_Profile.Single(o => o.STORE_NO == IGViewModel.ItemCode).Group = IGViewModel.GroupId;
                    }
                    else if (IGRow.Item_Type == 4 && db.INVRIRP0.Where(o => o.RIRMIC == IGViewModel.ItemCode).Any())
                    {
                        foreach (var v in db.INVRIRP0.Where(o => o.RIRMIC == IGViewModel.ItemCode))
                        {
                            v.Group = IGViewModel.GroupId;
                        }
                    }
                }
                else
                {
                    IGRow.Group_Id = new Random().Next(1, 999999);
                    // Get new Group_Id if it exist
                    for (int i = 0; (i < 10 && db.ITMGRPs.Where(o => o.Group_Id == IGRow.Group_Id).Any()); i++)
                    {
                        IGRow.Group_Id = new Random().Next(1, 999999);
                    }
                    IGRow.Group_Name = IGViewModel.GroupName;
                    IGRow.Item_Code  = 0;
                    IGRow.Item_Name  = "";
                    IGRow.Item_Type  = IGViewModel.ItemType;
                    IGRow.Group_Type = IGViewModel.GroupType;
                }
                db.ITMGRPs.Add(IGRow);

                // Save DB
                try
                {
                    db.SaveChanges();
                }
                catch (Exception e)
                {
                    System.Diagnostics.Debug.WriteLine(e.Source);
                    System.Diagnostics.Debug.WriteLine(e.Message);
                    System.Diagnostics.Debug.WriteLine(e.StackTrace);
                    System.Diagnostics.Debug.WriteLine(e.InnerException);
                    Exception f = e.InnerException;
                    while (f != null)
                    {
                        System.Diagnostics.Debug.WriteLine("INNER:");
                        System.Diagnostics.Debug.WriteLine(f.Message);
                        System.Diagnostics.Debug.WriteLine(f.Source);
                        f = f.InnerException;
                    }
                    System.Diagnostics.Debug.WriteLine(e.Data);
                    return(false);
                }
                return(true);
            }
        }