public async Task <IActionResult> AddAndEditToolAndSocketDetails(TblToolAndSocketDetailsCustom data)
        {
            //calling DepartmentDAL busines layer
            CommonResponse response = toolLife.AddAndEditToolAndSocketDetails(data);

            return(Ok(response));
        }
        /// <summary>
        /// Redirect The Page
        /// </summary>
        /// <param name="HostName"></param>
        /// <param name="IpAddress"></param>
        /// <returns></returns>
        public CommonResponse AddAndEditToolAndSocketDetails(TblToolAndSocketDetailsCustom data)
        {
            CommonResponse obj = new CommonResponse();

            try
            {
                var check = db.UnitworkccsTbltoolandsocketdetails.Where(m => m.MachineId == data.machineId && m.SocketNo == data.socketNo && m.IsDeleted == 0).FirstOrDefault();
                if (check == null)
                {
                    var item = db2.TblIssuedReceived.Where(m => m.BarCodeNo == data.toolNumber && m.MachineId == data.machineId).FirstOrDefault();
                    if (item != null)
                    {
                        var toolDetails = db2.TblTools.Where(m => m.ToolName.Trim().Contains(item.ToolName.Trim())).FirstOrDefault();
                        if (toolDetails != null)
                        {
                            int stdToolLife = Convert.ToInt32(toolDetails.StandardToolLife);
                            UnitworkccsTbltoolandsocketdetails tblToolAndSocket = new UnitworkccsTbltoolandsocketdetails();
                            tblToolAndSocket.Qrcode               = data.toolNumber;
                            tblToolAndSocket.ToolNumber           = item.ToolName.Trim();
                            tblToolAndSocket.SocketNo             = data.socketNo;
                            tblToolAndSocket.MachineId            = data.machineId;
                            tblToolAndSocket.StandardToolLife     = stdToolLife;
                            tblToolAndSocket.ActaulToolLife       = 0;
                            tblToolAndSocket.ToolInsertedDateTime = DateTime.Now;
                            tblToolAndSocket.CreatedOn            = DateTime.Now;
                            tblToolAndSocket.CreatedBy            = 1;
                            tblToolAndSocket.IsDeleted            = 0;
                            db.Add(tblToolAndSocket);
                            db.SaveChanges();
                        }
                    }

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