Пример #1
0
        public IHttpActionResult EditFormData(int id, [FromBody] EquipmentModels.Edit Equipment)
        {
            JavaScriptSerializer js = new JavaScriptSerializer();
            string logForm          = "Form : " + js.Serialize(Equipment);
            string logAPI           = "[Put] " + Request.RequestUri.ToString();

            if (!ModelState.IsValid || Equipment == null)
            {
                Startup._sfAppLogger.Warn(logAPI + " || Input Parameter not expected || " + logForm);
                return(BadRequest("Invalid data"));
            }

            try
            {
                EquipmentModels equipmentModel = new EquipmentModels();
                equipmentModel.updateEquipment(id, Equipment);
                return(Ok());
            }
            catch (Exception ex)
            {
                StringBuilder logMessage = LogUtility.BuildExceptionMessage(ex);
                logMessage.AppendLine(logForm);
                Startup._sfAppLogger.Error(logAPI + logMessage);

                return(InternalServerError(ex));
            }
        }
Пример #2
0
        public IHttpActionResult AddFormData([FromBody] EquipmentModels.Edit Equipment)
        {
            string logForm = "Form : " + Startup._jsSerializer.Serialize(Equipment);
            string logAPI  = "[Post] " + Request.RequestUri.ToString();

            if (!ModelState.IsValid || Equipment == null)
            {
                Startup._sfAppLogger.Warn(logAPI + " || Input Parameter not expected || " + logForm);
                return(BadRequest("Invalid data"));
            }

            try
            {
                EquipmentModels equipmentModel = new EquipmentModels();
                int             newEquipmentId = equipmentModel.addEquipment(Equipment);
                return(Json(new { id = newEquipmentId }));
            }
            catch (Exception ex)
            {
                StringBuilder logMessage = LogUtility.BuildExceptionMessage(ex);
                logMessage.AppendLine(logForm);
                Startup._sfAppLogger.Error(logAPI + logMessage);

                return(InternalServerError(ex));
            }
        }
        public JsonResult OPCSendCommand(string Equipment, string Command, string Type)
        {
            Dictionary <string, object> response = new Dictionary <string, object>();
            string port = EquipmentModels.GetPort(Equipment);

            //for forcing values for testing purposes
            //Equipment = "AMPICIMAPPDEV1";
            //port = "6666";

            if (port != "" && port != null)
            {
                if (Type.ToString().ToUpper() == "LASER MARK TEST")
                {
                    Command = "<C>" + Command + "</C>";
                }

                var Duration = Convert.ToInt32(SettingModels.GetOPCTimeout());
                var isTimer  = SettingModels.IsOPCTimeout();

                EquipmentModels.insertTCPNotification(Equipment, Command, "MACHINE_REQUEST");

                var result = HttpHandler.OPCSendCommand(Equipment, port, Command, Duration, isTimer);

                if (result != null)
                {
                    response.Add("Result", result.Result);
                    response.Add("Error", Convert.ToBoolean(result.Error));
                }
            }

            return(Json(response, JsonRequestBehavior.AllowGet));
        }
Пример #4
0
        public IHttpActionResult GetAlarmMessageByEquipmentId(int equipmentId, [FromUri] int top = 10, [FromUri] int hours = 168, [FromUri] string order = "desc")
        {
            try
            {
                EquipmentModels        equipmentModel = new EquipmentModels();
                EquipmentModels.Detail equipment      = equipmentModel.getEquipmentById(equipmentId);
                CompanyModel           companyModel   = new CompanyModel();
                var companySubscription       = companyModel.GetValidSubscriptionPlanByCompanyId(equipment.CompanyId);
                DocumentDBHelper docDBHelpler = new DocumentDBHelper(equipment.CompanyId, companySubscription.CosmosDBConnectionString);
                return(Ok(docDBHelpler.GetAlarmMessageByEquipmentId(equipment.EquipmentId, top, hours, order)));
            }
            catch (CDSException cdsEx)
            {
                IHttpActionResult   response;
                HttpResponseMessage responseMsg = new HttpResponseMessage(HttpStatusCode.BadRequest);
                string body = new JavaScriptSerializer().Serialize(CDSException.GetCDSErrorMessageByCode(cdsEx.ErrorId));
                responseMsg.Content = new StringContent(body, Encoding.UTF8, "application/json");
                response            = ResponseMessage(responseMsg);
                return(response);
            }
            catch (Exception ex)
            {
                StringBuilder logMessage = LogHelper.BuildExceptionMessage(ex);
                string        logAPI     = "[Get] " + Request.RequestUri.ToString();
                Global._appLogger.Error(logAPI + logMessage);

                return(Content(HttpStatusCode.InternalServerError, ex));
            }
        }
        public JsonResult getChildEquipments(string parent)
        {
            List <string> child = new List <string>();

            child = EquipmentModels.getChildEquipments(parent);
            return(Json(child, JsonRequestBehavior.AllowGet));
        }
Пример #6
0
        public IHttpActionResult GetMessageByEquipmentId(int equipmentId, [FromUri] int top = 10, [FromUri] int hours = 168, [FromUri] string order = "desc")
        {
            try
            {
                int companyId = Global.GetCompanyIdFromToken();
                if (!General.IsEquipmentUnderCompany(equipmentId, companyId))
                {
                    return(Unauthorized());
                }

                CompanyModel companyModel          = new CompanyModel();
                CompanyModel.Format_Detail company = companyModel.GetById(companyId);

                var companySubscription = companyModel.GetValidSubscriptionPlanByCompanyId(companyId);
                if (companySubscription == null)
                {
                    throw new Exception("can't find valid subscription plan.");
                }

                DocumentDBHelper docDBHelpler   = new DocumentDBHelper(companyId, companySubscription.CosmosDBConnectionString);
                EquipmentModels  equipmentModel = new EquipmentModels();

                return(Ok(docDBHelpler.GetMessageByEquipmentId(equipmentModel.getEquipmentById(equipmentId).EquipmentId, top, hours, order, companyId)));
            }
            catch (Exception ex)
            {
                StringBuilder logMessage = LogHelper.BuildExceptionMessage(ex);
                string        logAPI     = "[Get] " + Request.RequestUri.ToString();
                Global._appLogger.Error(logAPI + logMessage);

                return(Content(HttpStatusCode.InternalServerError, ex));
            }
        }
Пример #7
0
        public string getParentEquipment(string equipment)
        {
            string parent = "";

            parent = EquipmentModels.getParentEquipment(equipment);
            return(parent);
        }
Пример #8
0
        public bool IsChildEquipment(string equipment)
        {
            bool check = false;

            check = EquipmentModels.IsChildEquipment(equipment);
            return(check);
        }
Пример #9
0
        public async Task <HttpResponseMessage> UploadLogoFile(int id)
        {
            // Check if the request contains multipart/form-data.
            if (!Request.Content.IsMimeMultipartContent())
            {
                return(Request.CreateResponse(HttpStatusCode.UnsupportedMediaType));
            }

            EquipmentModels equipmentModel = new EquipmentModels();
            FileUtility     fileHelper     = new FileUtility();
            string          root           = Path.GetTempPath();
            var             provider       = new MultipartFormDataStreamProvider(root);

            try
            {
                EquipmentModels.Detail equipment = equipmentModel.getEquipmentById(id);
            }
            catch
            {
                return(Request.CreateResponse(HttpStatusCode.NotFound));
            }

            try
            {
                // Read the form data.
                string fileAbsoluteUri = "";
                await Request.Content.ReadAsMultipartAsync(provider);

                //FileData
                foreach (MultipartFileData fileData in provider.FileData)
                {
                    string formColumnName   = fileData.Headers.ContentDisposition.Name;
                    string fileExtenionName = fileData.Headers.ContentDisposition.FileName.Split('.')[1];
                    if (fileHelper.CheckImageExtensionName(formColumnName, fileExtenionName))
                    {
                        string uploadFilePath = "company-" + equipmentModel.getCompanyId(id) + "/equipment/" + id + "-default." + fileHelper.LowerAndFilterString(fileExtenionName);
                        fileAbsoluteUri = fileHelper.SaveFiletoStorage(fileData.LocalFileName, uploadFilePath, "images");
                    }
                }

                if (fileAbsoluteUri.Equals(""))
                {
                    return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, "File is empty or wrong extension name"));
                }

                //Edit company logo path
                equipmentModel.updateEquipmentLogoURL(id, fileAbsoluteUri);
                return(Request.CreateResponse(HttpStatusCode.OK, new { imageURL = fileAbsoluteUri }));
            }
            catch (System.Exception ex)
            {
                string        logAPI     = "[Put] " + Request.RequestUri.ToString();
                StringBuilder logMessage = LogUtility.BuildExceptionMessage(ex);
                Startup._sfAppLogger.Error(logAPI + logMessage);
                return(Request.CreateErrorResponse(HttpStatusCode.InternalServerError, ex));
            }
        }
Пример #10
0
        public JsonResult getAllAlarmsTCP(string Equipment)
        {
            var result = EquipmentModels.getAllAlarmsTCP(Equipment);

            var jsonSerialiser = new JavaScriptSerializer();
            var json           = jsonSerialiser.Serialize(result);

            return(Json(json, JsonRequestBehavior.AllowGet));
        }
Пример #11
0
        public IHttpActionResult GetMetaDataById(int Id)
        {
            EquipmentModels equipmentModel = new EquipmentModels();

            try
            {
                return(Ok(equipmentModel.GetMetaDataById(Id)));
            }
            catch
            {
                return(NotFound());
            }
        }
Пример #12
0
        public IHttpActionResult GeById(int id)
        {
            EquipmentModels equipmentModel = new EquipmentModels();

            try
            {
                EquipmentModels.Detail company = equipmentModel.getEquipmentById(id);
                return(Ok(company));
            }
            catch
            {
                return(NotFound());
            }
        }
Пример #13
0
    public static int GetNewAlarmCountTCP(string Equipment)
    {
        int alarms = 0;

        try
        {
            alarms = EquipmentModels.getNewAlarmCountTCP(Equipment);
        }
        catch
        {
            alarms = 0;
        }

        return(alarms);
    }
Пример #14
0
 public IHttpActionResult Delete(int id)
 {
     try
     {
         EquipmentModels equipmentModel = new EquipmentModels();
         equipmentModel.deleteEquipment(id);
         return(Ok("Success"));
     }
     catch (Exception ex)
     {
         string        logAPI     = "[Delete] " + Request.RequestUri.ToString();
         StringBuilder logMessage = LogUtility.BuildExceptionMessage(ex);
         Startup._sfAppLogger.Error(logAPI + logMessage);
         return(InternalServerError());
     }
 }
        public JsonResult DeleteEquipmentType(string ID)
        {
            var result = EquipTypeModels.DeleteEquipmentType(ID);

            DataTable dt = new DataTable();

            if (result == true)
            {
                dt = EquipmentModels.GetEquipmentByType(ID);

                int count = 0;
                try
                {
                    count = dt.Rows.Count;
                }
                catch
                {
                    count = 0;
                }

                if (count > 0)
                {
                    result = EquipmentModels.DeleteEquipmentByType(ID);
                }

                bool temp = result;
                if (result == true)
                {
                    foreach (DataRow dr in dt.Rows)
                    {
                        int EquipID = Convert.ToInt32(dr["ID"].ToString());
                        result = UserEquipmentModels.DeleteUserEquipmentByBatch(EquipID.ToString());
                        if (result == true)
                        {
                            temp = true;
                        }
                    }
                }

                result = temp;
            }

            return(Json(result.ToString(), JsonRequestBehavior.AllowGet));
        }
Пример #16
0
        public IHttpActionResult GetMessageByEquipmentId(string equipmentId, [FromUri] int top = 10, [FromUri] int hours = 168, [FromUri] string order = "desc")
        {
            try
            {
                EquipmentModels      equipmentModel = new EquipmentModels();
                int                  companyId      = equipmentModel.getCompanyId(equipmentId);
                CompanyModels        companyModel   = new CompanyModels();
                CompanyModels.Detail company        = companyModel.getCompanyById(companyId);
                DocumentDBHelper     docDBHelpler   = new DocumentDBHelper(companyId, company.DocDBConnectionString);
                return(Ok(docDBHelpler.GetMessageByEquipmentId(equipmentId, top, hours, order)));
            }
            catch (Exception ex)
            {
                StringBuilder logMessage = LogUtility.BuildExceptionMessage(ex);
                string        logAPI     = "[Get] " + Request.RequestUri.ToString();
                Startup._sfAppLogger.Error(logAPI + logMessage);

                return(InternalServerError(ex));
            }
        }
Пример #17
0
        public IHttpActionResult GetEquipmentWithMetaDataById(string equipmentId)
        {
            try
            {
                int companyId = GetCompanyIdFromToken();
                if (!General.IsEquipmentUnderCompany(equipmentId, companyId))
                {
                    return(Unauthorized());
                }

                EquipmentModels equipmentModel = new EquipmentModels();
                return(Ok(equipmentModel.getEquipmentWithMetaDataById(equipmentId)));
            }
            catch (Exception ex)
            {
                StringBuilder logMessage = LogUtility.BuildExceptionMessage(ex);
                string        logAPI     = "[Get] " + Request.RequestUri.ToString();
                Startup._sfAppLogger.Error(logAPI + logMessage);

                return(InternalServerError());
            }
        }
Пример #18
0
        public JsonResult getProcessedQTY(string equipment)
        {
            var res = EquipmentModels.getProcessedQTY(equipment);

            return(Json(res, JsonRequestBehavior.AllowGet));
        }
Пример #19
0
        public JsonResult markAsBrand(string equipment, string isBrand)
        {
            var res = EquipmentModels.markAsBrand(equipment, isBrand);

            return(Json(res, JsonRequestBehavior.AllowGet));
        }
Пример #20
0
        public JsonResult isBrand(string equipment)
        {
            var res = EquipmentModels.isBrand(equipment);

            return(Json(res, JsonRequestBehavior.AllowGet));
        }
Пример #21
0
        //function for Report Setup
        public static List <SECSGEMDefaultReplyObject> SetupReport(string Equipment)
        {
            try
            {
                int    ID   = EquipmentModels.GetEquipmentID(Equipment);
                string type = EquipmentModels.GetEquipmentTypeJoin(ID);

                List <SECSGEMDefaultReplyObject> obj      = new List <SECSGEMDefaultReplyObject>();
                SECSGEMDefaultReplyObject        temp_obj = new SECSGEMDefaultReplyObject();

                if (type == "")
                {
                    var child = EquipmentModels.getChildEquipments(Equipment);
                    foreach (var x in child)
                    {
                        string ChildEquipment = x;

                        int    ChildID   = EquipmentModels.GetEquipmentID(ChildEquipment);
                        string childtype = EquipmentModels.GetEquipmentTypeJoin(ChildID);

                        if (childtype.ToUpper() == "DEK PRINTER")
                        {
                            //Product Data modified (CEID 31346)
                            //Equipment constant change (CEID 31440)
                            //Configuration change (CEID 31287)
                            //Configuration Parameter modified(CEID 31345)
                            //Adjust Parameter modified (CEID 31347)

                            //for processed quantity
                            temp_obj = HttpHandler.DisableCollection(ChildEquipment, 31277); //31277 Board printed
                            obj.Add(temp_obj);

                            temp_obj = HttpHandler.DeleteReport(ChildEquipment, 301); //301 RPTID = User Defined ID
                            obj.Add(temp_obj);

                            temp_obj = HttpHandler.UnlinkCollection(ChildEquipment, 31277);
                            obj.Add(temp_obj);

                            temp_obj = HttpHandler.AddToReport_Single(ChildEquipment, 301, 1020); //SVID = 1020 (batch_count)
                            obj.Add(temp_obj);

                            temp_obj = HttpHandler.LinkCollection(ChildEquipment, 31277, 301);
                            obj.Add(temp_obj);

                            temp_obj = HttpHandler.EnableCollection(ChildEquipment, 31277);
                            obj.Add(temp_obj);

                            //for multi vid sample
                            //List<int> lstVID = new List<int>();
                            //lstVID.Add(456);
                            //lstVID.Add(789);

                            //temp_obj = HttpHandler.AddToReport_Multi(ChildEquipment, 301, lstVID);
                            //obj.Add(temp_obj);
                        }
                        else if (childtype.ToUpper() == "HELLER OVEN")
                        {
                            //for lane 1
                            temp_obj = HttpHandler.DisableCollection(ChildEquipment, 1080); //1080 HellerBoardExitLane1
                            obj.Add(temp_obj);

                            temp_obj = HttpHandler.DeleteReport(ChildEquipment, 401); //401 RPTID = User Defined ID
                            obj.Add(temp_obj);

                            temp_obj = HttpHandler.UnlinkCollection(ChildEquipment, 1080);
                            obj.Add(temp_obj);

                            temp_obj = HttpHandler.AddToReport_Single(ChildEquipment, 401, 13049); //SVID = 13049 (HellerPVChannel49) Boards processed Lane1
                            obj.Add(temp_obj);

                            temp_obj = HttpHandler.LinkCollection(ChildEquipment, 1080, 401);
                            obj.Add(temp_obj);

                            temp_obj = HttpHandler.EnableCollection(ChildEquipment, 1080);
                            obj.Add(temp_obj);

                            //for lane 2
                            temp_obj = HttpHandler.DisableCollection(ChildEquipment, 1081); //1080 HellerBoardExitLane2
                            obj.Add(temp_obj);

                            temp_obj = HttpHandler.DeleteReport(ChildEquipment, 402); //402 RPTID = User Defined ID
                            obj.Add(temp_obj);

                            temp_obj = HttpHandler.UnlinkCollection(ChildEquipment, 1081);
                            obj.Add(temp_obj);

                            temp_obj = HttpHandler.AddToReport_Single(ChildEquipment, 402, 13050); //SVID = 13050 (HellerPVChannel50) Boards processed Lane2
                            obj.Add(temp_obj);

                            temp_obj = HttpHandler.LinkCollection(ChildEquipment, 1081, 402);
                            obj.Add(temp_obj);

                            temp_obj = HttpHandler.EnableCollection(ChildEquipment, 1081);
                            obj.Add(temp_obj);
                        }
                        else if (childtype.ToUpper() == "PANASONIC COMPONENT ATTACH")
                        {
                            if (EnablePanasonic == true)
                            {
                                temp_obj = HttpHandler.DisableCollection(ChildEquipment, 16016); //16016 (Product1BoardEnd)??
                                obj.Add(temp_obj);

                                temp_obj = HttpHandler.DeleteReport(ChildEquipment, 501); //501 RPTID = User Defined ID
                                obj.Add(temp_obj);

                                temp_obj = HttpHandler.UnlinkCollection(ChildEquipment, 16016);
                                obj.Add(temp_obj);

                                temp_obj = HttpHandler.AddToReport_Single(ChildEquipment, 501, 7003); //SVID = 7003 (Board)
                                obj.Add(temp_obj);

                                temp_obj = HttpHandler.LinkCollection(ChildEquipment, 16016, 501);
                                obj.Add(temp_obj);

                                temp_obj = HttpHandler.EnableCollection(ChildEquipment, 16016);
                                obj.Add(temp_obj);
                            }
                            else
                            {
                                //Override
                                //Disable Collection
                                temp_obj                = new SECSGEMDefaultReplyObject();
                                temp_obj.Equipment      = ChildEquipment;
                                temp_obj.EquipmentType  = childtype;
                                temp_obj.StreamFunction = "S2F37_DISABLE_COLLECTION";
                                temp_obj.Value          = 0;
                                obj.Add(temp_obj);

                                //Delete Report
                                temp_obj                = new SECSGEMDefaultReplyObject();
                                temp_obj.Equipment      = ChildEquipment;
                                temp_obj.EquipmentType  = childtype;
                                temp_obj.StreamFunction = "S2F33_DELETE_REPORT";
                                temp_obj.Value          = 0;
                                obj.Add(temp_obj);

                                //Unlink Collection
                                temp_obj                = new SECSGEMDefaultReplyObject();
                                temp_obj.Equipment      = ChildEquipment;
                                temp_obj.EquipmentType  = childtype;
                                temp_obj.StreamFunction = "S2F35_UNLINK_COLLECTION";
                                temp_obj.Value          = 0;
                                obj.Add(temp_obj);

                                //Add Report
                                temp_obj                = new SECSGEMDefaultReplyObject();
                                temp_obj.Equipment      = ChildEquipment;
                                temp_obj.EquipmentType  = childtype;
                                temp_obj.StreamFunction = "S2F33_ADD_REPORT";
                                temp_obj.Value          = 0;
                                obj.Add(temp_obj);

                                //Link Collection
                                temp_obj                = new SECSGEMDefaultReplyObject();
                                temp_obj.Equipment      = ChildEquipment;
                                temp_obj.EquipmentType  = childtype;
                                temp_obj.StreamFunction = "S2F35_LINK_COLLECTION";
                                temp_obj.Value          = 0;
                                obj.Add(temp_obj);

                                //Enable Collection
                                temp_obj                = new SECSGEMDefaultReplyObject();
                                temp_obj.Equipment      = ChildEquipment;
                                temp_obj.EquipmentType  = childtype;
                                temp_obj.StreamFunction = "S2F37_ENABLE_COLLECTION";
                                temp_obj.Value          = 0;
                                obj.Add(temp_obj);
                            }
                        }
                    }
                }
                else
                {
                    if (type.ToUpper() == "DEK PRINTER")
                    {
                        temp_obj = HttpHandler.DisableCollection(Equipment, 31277); //31277 Board printed
                        obj.Add(temp_obj);

                        temp_obj = HttpHandler.DeleteReport(Equipment, 301); //301 RPTID = User Defined ID
                        obj.Add(temp_obj);

                        temp_obj = HttpHandler.UnlinkCollection(Equipment, 31277);
                        obj.Add(temp_obj);

                        temp_obj = HttpHandler.AddToReport_Single(Equipment, 301, 1020); //SVID = 1020 (batch_count)
                        obj.Add(temp_obj);

                        temp_obj = HttpHandler.LinkCollection(Equipment, 31277, 301);
                        obj.Add(temp_obj);

                        temp_obj = HttpHandler.EnableCollection(Equipment, 31277);
                        obj.Add(temp_obj);


                        //Product Data modified (CEID 31346)
                        //Equipment constant change (CEID 31440)
                        //Configuration change (CEID 31287)
                        //Configuration Parameter modified(CEID 31345)
                        //Adjust Parameter modified (CEID 31347)

                        //testing ceids

                        //temp_obj = HttpHandler.DisableCollection(Equipment, 31346);
                        //obj.Add(temp_obj);

                        //temp_obj = HttpHandler.DeleteReport(Equipment, 302);
                        //obj.Add(temp_obj);

                        //temp_obj = HttpHandler.UnlinkCollection(Equipment, 31346);
                        //obj.Add(temp_obj);

                        ////temp_obj = HttpHandler.AddToReport_Single(Equipment, 302, 2009); //SVID = 2009 (rear_print_pressure)
                        ////obj.Add(temp_obj);

                        //List<int> lstVID = new List<int>();
                        //lstVID.Add(2009); //SVID = 2009 (rear_print_pressure)
                        //lstVID.Add(2008); //SVID = 2008 (front_print_pressure)

                        //temp_obj = HttpHandler.AddToReport_Multi(Equipment, 302, lstVID);
                        //obj.Add(temp_obj);

                        //temp_obj = HttpHandler.LinkCollection(Equipment, 31346, 302);
                        //obj.Add(temp_obj);

                        //temp_obj = HttpHandler.EnableCollection(Equipment, 31346);
                        //obj.Add(temp_obj);

                        //end of testing ceid
                    }
                    else if (type.ToUpper() == "HELLER OVEN")
                    {
                        //for lane 1
                        temp_obj = HttpHandler.DisableCollection(Equipment, 1080); //1080 HellerBoardExitLane1
                        obj.Add(temp_obj);

                        temp_obj = HttpHandler.DeleteReport(Equipment, 401); //401 RPTID = User Defined ID
                        obj.Add(temp_obj);

                        temp_obj = HttpHandler.UnlinkCollection(Equipment, 1080);
                        obj.Add(temp_obj);

                        temp_obj = HttpHandler.AddToReport_Single(Equipment, 401, 13049); //SVID = 13049 (HellerPVChannel49) Boards processed Lane1
                        obj.Add(temp_obj);

                        temp_obj = HttpHandler.LinkCollection(Equipment, 1080, 401);
                        obj.Add(temp_obj);

                        temp_obj = HttpHandler.EnableCollection(Equipment, 1080);
                        obj.Add(temp_obj);

                        //for lane 2
                        temp_obj = HttpHandler.DisableCollection(Equipment, 1081); //1080 HellerBoardExitLane2
                        obj.Add(temp_obj);

                        temp_obj = HttpHandler.DeleteReport(Equipment, 402); //402 RPTID = User Defined ID
                        obj.Add(temp_obj);

                        temp_obj = HttpHandler.UnlinkCollection(Equipment, 1081);
                        obj.Add(temp_obj);

                        temp_obj = HttpHandler.AddToReport_Single(Equipment, 402, 13050); //SVID = 13050 (HellerPVChannel50) Boards processed Lane2
                        obj.Add(temp_obj);

                        temp_obj = HttpHandler.LinkCollection(Equipment, 1081, 402);
                        obj.Add(temp_obj);

                        temp_obj = HttpHandler.EnableCollection(Equipment, 1081);
                        obj.Add(temp_obj);
                    }
                    else if (type.ToUpper() == "PANASONIC COMPONENT ATTACH")
                    {
                        if (EnablePanasonic == true)
                        {
                            temp_obj = HttpHandler.DisableCollection(Equipment, 16016); //16016 (Product1BoardEnd)??
                            obj.Add(temp_obj);

                            temp_obj = HttpHandler.DeleteReport(Equipment, 501); //501 RPTID = User Defined ID
                            obj.Add(temp_obj);

                            temp_obj = HttpHandler.UnlinkCollection(Equipment, 16016);
                            obj.Add(temp_obj);

                            temp_obj = HttpHandler.AddToReport_Single(Equipment, 501, 7003); //SVID = 7003 (Board)
                            obj.Add(temp_obj);

                            temp_obj = HttpHandler.LinkCollection(Equipment, 16016, 501);
                            obj.Add(temp_obj);

                            temp_obj = HttpHandler.EnableCollection(Equipment, 16016);
                            obj.Add(temp_obj);
                        }
                        else
                        {
                            //Override
                            //Disable Collection
                            temp_obj                = new SECSGEMDefaultReplyObject();
                            temp_obj.Equipment      = Equipment;
                            temp_obj.EquipmentType  = type;
                            temp_obj.StreamFunction = "S2F37_DISABLE_COLLECTION";
                            temp_obj.Value          = 0;
                            obj.Add(temp_obj);

                            //Delete Report
                            temp_obj                = new SECSGEMDefaultReplyObject();
                            temp_obj.Equipment      = Equipment;
                            temp_obj.EquipmentType  = type;
                            temp_obj.StreamFunction = "S2F33_DELETE_REPORT";
                            temp_obj.Value          = 0;
                            obj.Add(temp_obj);

                            //Unlink Collection
                            temp_obj                = new SECSGEMDefaultReplyObject();
                            temp_obj.Equipment      = Equipment;
                            temp_obj.EquipmentType  = type;
                            temp_obj.StreamFunction = "S2F35_UNLINK_COLLECTION";
                            temp_obj.Value          = 0;
                            obj.Add(temp_obj);

                            //Add Report
                            temp_obj                = new SECSGEMDefaultReplyObject();
                            temp_obj.Equipment      = Equipment;
                            temp_obj.EquipmentType  = type;
                            temp_obj.StreamFunction = "S2F33_ADD_REPORT";
                            temp_obj.Value          = 0;
                            obj.Add(temp_obj);

                            //Link Collection
                            temp_obj                = new SECSGEMDefaultReplyObject();
                            temp_obj.Equipment      = Equipment;
                            temp_obj.EquipmentType  = type;
                            temp_obj.StreamFunction = "S2F35_LINK_COLLECTION";
                            temp_obj.Value          = 0;
                            obj.Add(temp_obj);

                            //Enable Collection
                            temp_obj                = new SECSGEMDefaultReplyObject();
                            temp_obj.Equipment      = Equipment;
                            temp_obj.EquipmentType  = type;
                            temp_obj.StreamFunction = "S2F37_ENABLE_COLLECTION";
                            temp_obj.Value          = 0;
                            obj.Add(temp_obj);
                        }
                    }
                }

                //if any machine fail its transaction dont let continue
                if (obj.Contains(null))
                {
                    return(null);
                }
                else
                {
                    if (obj == null)
                    {
                        return(null);
                    }
                    else
                    {
                        if (obj.Count == 0)
                        {
                            return(null);
                        }
                    }
                }

                return(obj);
            }
            catch
            {
                return(null);
            }
        }
Пример #22
0
    public static string GetLotInProcess(string equipment)
    {
        var lot = EquipmentModels.getLotInProcess(equipment);

        return(lot);
    }
Пример #23
0
        public JsonResult GetEquipmentType()
        {
            var types = EquipmentModels.GetEquipmentType();

            return(Json(types, JsonRequestBehavior.AllowGet));
        }
Пример #24
0
    public static int GetSECSGEMProcessedQtyInUnits(string Equipment)
    {
        var qty = EquipmentModels.getSECSGEMProcessedQTYInUnits(Equipment);

        return(qty);
    }
Пример #25
0
    public static int GetProcessedQty(string Equipment)
    {
        var qty = EquipmentModels.getProcessedQTY(Equipment);

        return(qty);
    }
Пример #26
0
    public static int GetUnbrandedQty(string Equipment)
    {
        var qty = EquipmentModels.getUnbrandedQty(Equipment);

        return(qty);
    }
Пример #27
0
    public static int GetTrackInQty(string Equipment)
    {
        var qty = EquipmentModels.getTrackInQTY(Equipment);

        return(qty);
    }
Пример #28
0
        public JsonResult CheckEquipment(string equipment)
        {
            var result = EquipmentModels.EquipmentExist(equipment);

            return(Json(result.ToString(), JsonRequestBehavior.AllowGet));
        }
Пример #29
0
        public JsonResult GetEquipmentList()
        {
            //create a dictionary that will contain the column + datafied config for the grid
            Dictionary <string, object> result_config = new Dictionary <string, object>();

            //get columns
            Dictionary <string, string> columns = EquipmentModels.GetCols();

            //check for filters
            string where = "";
            Dictionary <string, string> filters = new Dictionary <string, string>();

            if (Request["filterscount"] != null && Int32.Parse(Request["filterscount"]) > 0)
            {
                for (int i = 0; i < Int32.Parse(Request["filterscount"]); i++)
                {
                    filters.Add("filtervalue" + i, Request["filtervalue" + i]);
                    filters.Add("filtercondition" + i, Request["filtercondition" + i]);
                    filters.Add("filterdatafield" + i, Request["filterdatafield" + i]);
                    filters.Add("filteroperator" + i, Request["filteroperator" + i]);
                }
                where = custom_helper.FormatFilterConditions(filters, Int32.Parse(Request["filterscount"]), columns);
            }

            //check for sorting ops
            string sorting = "";

            if (Request["sortdatafield"] != null)
            {
                sorting = Request["sortdatafield"].ToString() + " " + Request["sortorder"].ToString().ToUpper();
            }

            //determine if cols_only
            if (Request["cols_only"] != null && bool.Parse(Request["cols_only"]) == true)
            {
                //get total row count
                int totalRows = EquipmentModels.GetCount(where, ((Request["searchStr"] == null) ? "" : Request["searchStr"].ToString()));

                //prepare column config
                var cols = new List <string>();
                foreach (var item in columns)
                {
                    cols.Add(item.Value);
                }

                Dictionary <string, object> cols_arr = custom_helper.PrepareStaticColumns(cols);
                result_config.Add("column_config", custom_helper.PrepareColumns(cols_arr));
                result_config.Add("TotalRows", totalRows);
            }
            else
            {
                //pagination initialization
                int pagenum  = Request["pagenum"] == null ? 0 : Int32.Parse(Request["pagenum"].ToString());
                int pagesize = Request["pagesize"] == null ? 0 : Int32.Parse(Request["pagesize"].ToString());
                int start    = pagenum * pagesize;

                //get data
                DataTable transactions = new DataTable();
                if (Request["showAll"] != null && bool.Parse(Request["showAll"]) == true)
                {
                    transactions = EquipmentModels.GetData(0, 0, where, sorting, ((Request["searchStr"] == null) ? "" : Request["searchStr"].ToString()));
                }
                else
                {
                    transactions = EquipmentModels.GetData(start, pagesize, where, sorting, ((Request["searchStr"] == null) ? "" : Request["searchStr"].ToString()));
                }

                //convert data into json object
                var data = custom_helper.DataTableToJson(transactions);

                result_config.Add("data", data);

                //prepare column config
                var cols = new List <string>();
                foreach (DataColumn column in transactions.Columns)
                {
                    cols.Add(column.ColumnName);
                }
                Dictionary <string, object> cols_arr = custom_helper.PrepareStaticColumns(cols);
                result_config.Add("column_config", custom_helper.PrepareColumns(cols_arr));
                result_config.Add("TotalRows", EquipmentModels.GetCount(where, ((Request["searchStr"] == null) ? "" : Request["searchStr"].ToString())));
            }
            string temp = Request["searchStr"];

            response.Add("success", true);
            response.Add("error", false);
            response.Add("message", result_config);

            return(Json(response, JsonRequestBehavior.AllowGet));
        }
Пример #30
0
        public JsonResult CheckEquipmentForUpdate(string equipment, int ID)
        {
            var result = EquipmentModels.EquipmentExistForUpdate(equipment, ID);

            return(Json(result.ToString(), JsonRequestBehavior.AllowGet));
        }