public ProcessMasterModel Process_InsertUpdate(ArrayList paramList)
        {
            string             strResult     = "";
            string             strReturnCode = "000";
            string             strReturnMsg  = "UnDefined";
            ProcessMasterModel apiObject     = new ProcessMasterModel();

            apiObject = Newtonsoft.Json.JsonConvert.DeserializeObject <ProcessMasterModel>(paramList[0].ToString());
            string crCnString  = UtilityLib.GetConnectionString();
            int    Processinfo = DL_ProcessMaster.ProcessInsert(crCnString, apiObject.ProcessId, apiObject.ProcessName, apiObject.PackingFlag, apiObject.PackingFlag, apiObject.ProcessDuration, apiObject.ProcessVolume, apiObject.WastageFlag, apiObject.ProcessUnit, apiObject.CompanyId, apiObject.ByProduct);

            if (Processinfo == 0)
            {
                apiObject.ReturnCode    = Processinfo;
                apiObject.ReturnMessage = "Process Added Successfully";
            }
            else if (Processinfo == 1)
            {
                apiObject.ReturnCode    = Processinfo;
                apiObject.ReturnMessage = "Process already exists";
            }
            else if (Processinfo == 101)
            {
                apiObject.ReturnCode    = Processinfo;
                apiObject.ReturnMessage = "Process updated successfully";
            }
            else if (Processinfo == 2)
            {
                apiObject.ReturnCode    = Processinfo;
                apiObject.ReturnMessage = "record is already updated by someone else";
            }
            else
            {
                apiObject.ReturnCode    = Processinfo;
                apiObject.ReturnMessage = "Fail-Record Not Inserted";
            }
            strResult = strReturnCode + "|" + strReturnMsg;
            return(apiObject);
        }
        private IList <ProcessMasterModel> fnProcessMaster_List(ProcessMasterModel apiObject, ref string strResult)
        {
            string strReturnCode = "000";
            string strReturnMsg  = "UnDefined";
            string crCnString    = UtilityLib.GetConnectionString();
            IList <ProcessMasterModel> objFieldClassModelList = new List <ProcessMasterModel>();
            DataSet usersInfoDS = DL_ProcessMaster.Process_List(crCnString, apiObject.RequestType, apiObject.SearchBy, apiObject.SearchString,
                                                                apiObject.ProcessId, apiObject.CompanyId, apiObject.ItemsPerPage, apiObject.RequestPageNo, apiObject.CurrentPageNo);
            DataTable usersInfoDT = usersInfoDS.Tables[0];

            if (usersInfoDT != null && usersInfoDT.Rows.Count > 0)
            {
                strReturnCode = "001";
                strReturnMsg  = "Success";
                foreach (DataRow dr in usersInfoDT.Rows)
                {
                    apiObject                 = new ProcessMasterModel();
                    apiObject.ProcessId       = UtilityLib.FormatNumber(dr["ProcessId"].ToString());
                    apiObject.ProcessName     = (string)dr["ProcessName"];
                    apiObject.QuantityFlag    = UtilityLib.FormatBoolean(dr["QuantityFlag"].ToString());
                    apiObject.ByProduct       = UtilityLib.FormatBoolean(dr["ByProduct"].ToString());
                    apiObject.WastageFlag     = UtilityLib.FormatBoolean(dr["WastageFlag"].ToString());
                    apiObject.QuantityFlag    = UtilityLib.FormatBoolean(dr["QuantityFlag"].ToString());
                    apiObject.IsDelete        = UtilityLib.FormatBoolean(dr["IsDelete"].ToString());
                    apiObject.ProcessDuration = UtilityLib.FormatDate(dr["ProcessDuration"]).ToString();
                    apiObject.ProcessVolume   = UtilityLib.FormatFloat(dr["ProcessVolume"]);
                    //apiObject.CompanyId = (Guid)(dr["CompanyId"]);
                    objFieldClassModelList.Add(apiObject);
                }
            }
            else
            {
                strReturnCode = "002";
                strReturnMsg  = "Fail-Record Not Found";
            }
            strResult = strReturnCode + "|" + strReturnMsg;
            return(objFieldClassModelList);
        }
        public ProcessMasterModel DeleteProcess(ArrayList paramList)
        {
            string             strResult     = "";
            string             strReturnCode = "000";
            string             strReturnMsg  = "UnDefined";
            ProcessMasterModel apiObject     = new ProcessMasterModel();

            apiObject = Newtonsoft.Json.JsonConvert.DeserializeObject <ProcessMasterModel>(paramList[0].ToString());
            string crCnString  = UtilityLib.GetConnectionString();
            int    Processinfo = DL_ProcessMaster.Delete_Process(crCnString, apiObject.ProcessId);

            if (Processinfo == 101)
            {
                apiObject.ReturnCode    = Processinfo;
                apiObject.ReturnMessage = "Process delete successfully";
            }
            else
            {
                apiObject.ReturnCode    = Processinfo;
                apiObject.ReturnMessage = "Fail-Record Not Delete";
            }
            strResult = strReturnCode + "|" + strReturnMsg;
            return(apiObject);
        }