public async Task <IActionResult> AddAndUpdateMachineMaster(AddUpdateMachine data)
        {
            CommonResponse response = machineMaster.AddAndUpdateMachineMaster(data);

            return(Ok(response));
        }
コード例 #2
0
        /// <summary>
        /// Add And Update Machine Master
        /// </summary>
        /// <param name="data"></param>
        /// <returns></returns>
        public CommonResponse AddAndUpdateMachineMaster(AddUpdateMachine data)
        {
            CommonResponse obj = new CommonResponse();

            try
            {
                var check = db.UnitworkccsTblmachinedetails.Where(m => m.MachineId == data.machineId).FirstOrDefault();
                if (check == null)
                {
                    try
                    {
                        UnitworkccsTblmachinedetails tblmachinedetails = new UnitworkccsTblmachinedetails();
                        tblmachinedetails.PlantId            = data.plantId;
                        tblmachinedetails.ShopId             = data.shopId;
                        tblmachinedetails.CellId             = data.cellId;
                        tblmachinedetails.Ipaddress          = data.ipAddress;
                        tblmachinedetails.MachineName        = data.machineNo;
                        tblmachinedetails.MachineDisplayName = data.machineNo;
                        tblmachinedetails.MachinePockets     = Convert.ToInt32(data.noOfToolStation);
                        tblmachinedetails.Mmmgroup           = data.mmmGroup;
                        tblmachinedetails.MachineDescription = data.machineName;
                        tblmachinedetails.DedicatedOrShared  = data.dedicatedOrShared;
                        tblmachinedetails.PrimaryOrSecondary = data.primaryOrSecondary;
                        tblmachinedetails.MachineCategoryId  = data.machineCategoryId;
                        tblmachinedetails.MachineMake        = Convert.ToString(data.makeId);
                        tblmachinedetails.MachineSpec        = data.machineSpec;
                        tblmachinedetails.ChuckOrRodSize     = Convert.ToInt32(data.chuckOrRodSize);
                        tblmachinedetails.TallStockAvailId   = Convert.ToInt32(data.tallStockAvailibilityId);
                        tblmachinedetails.NoOfAxisId         = Convert.ToInt32(data.noOfAxisId);
                        tblmachinedetails.TableSize          = data.tableSize;
                        tblmachinedetails.PalletId           = Convert.ToInt32(data.palletId);
                        tblmachinedetails.Category           = data.criticalOrNonCritical;

                        if (data.machineBelongTo == "Wimarasys")
                        {
                            tblmachinedetails.IsWimerasys      = 1;
                            tblmachinedetails.MachineModelType = 99;
                        }
                        else
                        {
                            if (data.controllerType == "FANUC")
                            {
                                tblmachinedetails.ControllerType   = "FANUC";
                                tblmachinedetails.MachineModelType = 1;
                            }
                            else if (data.controllerType == "DL")
                            {
                                tblmachinedetails.ControllerType   = "DL";
                                tblmachinedetails.IsPcb            = 1;
                                tblmachinedetails.MachineModelType = 4;
                            }
                        }

                        tblmachinedetails.IsNormalWc        = 0;
                        tblmachinedetails.CreatedOn         = DateTime.Now;
                        tblmachinedetails.InsertedOn        = Convert.ToString(DateTime.Now);
                        tblmachinedetails.InsertedBy        = 1;
                        tblmachinedetails.EnableLockLogic   = 0;
                        tblmachinedetails.ServerTabFlagSync = 0;
                        tblmachinedetails.ServerTabCheck    = 0;
                        tblmachinedetails.IsShiftWise       = 0;
                        tblmachinedetails.IsDeleted         = 0;
                        tblmachinedetails.IsDlversion       = 0;
                        db.UnitworkccsTblmachinedetails.Add(tblmachinedetails);
                        db.SaveChanges();

                        obj.isStatus = true;
                        obj.response = ResourceResponse.AddedSuccessMessage;
                    }
                    catch (Exception e)
                    {
                        log.Error(e); if (e.InnerException != null)
                        {
                            log.Error(e.InnerException.ToString());
                        }
                        obj.isStatus = false;
                        obj.response = ResourceResponse.FailureMessage;
                    }
                }
                else
                {
                    check.PlantId            = data.plantId;
                    check.ShopId             = Convert.ToInt32(data.shopId);
                    check.CellId             = Convert.ToInt32(data.cellId);
                    check.Ipaddress          = data.ipAddress;
                    check.MachineName        = data.machineNo;
                    check.MachineDisplayName = data.machineName;
                    check.MachinePockets     = Convert.ToInt32(data.noOfToolStation);
                    check.Mmmgroup           = data.mmmGroup;
                    check.MachineDescription = data.machineName;
                    check.DedicatedOrShared  = data.dedicatedOrShared;
                    check.PrimaryOrSecondary = data.primaryOrSecondary;
                    check.MachineCategoryId  = data.machineCategoryId;
                    check.MachineMake        = Convert.ToString(data.makeId);
                    check.MachineSpec        = data.machineSpec;
                    check.ChuckOrRodSize     = Convert.ToInt32(data.chuckOrRodSize);
                    check.TallStockAvailId   = Convert.ToInt32(data.tallStockAvailibilityId);
                    check.NoOfAxisId         = Convert.ToInt32(data.noOfAxisId);
                    check.TableSize          = data.tableSize;
                    check.PalletId           = Convert.ToInt32(data.palletId);
                    check.Category           = data.criticalOrNonCritical;

                    if (data.machineBelongTo == "Wimarasys")
                    {
                        check.IsWimerasys      = 1;
                        check.MachineModelType = 99;
                    }
                    else
                    {
                        if (data.controllerType == "FANUC")
                        {
                            check.ControllerType   = "FANUC";
                            check.MachineModelType = 1;
                        }
                        else if (data.controllerType == "DL")
                        {
                            check.ControllerType   = "DL";
                            check.IsPcb            = 1;
                            check.MachineModelType = 4;
                        }
                    }

                    check.IsNormalWc        = 0;
                    check.CreatedOn         = DateTime.Now;
                    check.InsertedOn        = Convert.ToString(DateTime.Now);
                    check.InsertedBy        = 1;
                    check.EnableLockLogic   = 0;
                    check.ServerTabFlagSync = 0;
                    check.ServerTabCheck    = 0;
                    check.IsShiftWise       = 0;
                    check.IsDeleted         = 0;
                    check.IsDlversion       = 0;
                    db.SaveChanges();

                    obj.isStatus = true;
                    obj.response = ResourceResponse.UpdatedSuccessMessage;
                }
            }
            catch (Exception e)
            {
                log.Error(e); if (e.InnerException != null)
                {
                    log.Error(e.InnerException.ToString());
                }
                obj.isStatus = false;
                obj.response = ResourceResponse.FailureMessage;
            }
            return(obj);
        }