Пример #1
0
        public JsonResult GetUserTypeName()
        {
            DataControl.CurrentInfo _objcurrentInfo   = new DataControl.CurrentInfo();
            DataControl.BLMaster    _objBlmaster      = new DataControl.BLMaster();
            DivisionUserProducts    objDivUserProduct = new DivisionUserProducts();

            objDivUserProduct.Company_Code = _objcurrentInfo.GetCompanyCode();
            objDivUserProduct.User_Code    = _objcurrentInfo.GetUserCode();
            try
            {
                IEnumerable <DivisionUserProducts> lstDiv = _objBlmaster.GetUserTypeNames(objDivUserProduct);
                var division = (from div in lstDiv.AsEnumerable()
                                select new DivisionUserProducts()
                {
                    User_Type_Code = div.User_Type_Code.ToString(),
                    User_Type_Name = div.User_Type_Name.ToString()
                }).ToList <DivisionUserProducts>();
                return(Json(division));
            }
            catch (Exception ex)
            {
                Dictionary <string, string> dicContext = new Dictionary <string, string>();
                dicContext.Add("Filter:companyCode", objDivUserProduct.Company_Code);
                DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
                return(Json("Sorry an error occured. Please try again later."));
            }
        }
Пример #2
0
        public JsonResult GetAPIServiceID()
        {
            DataControl.CurrentInfo _objcurrentInfo   = new DataControl.CurrentInfo();
            DataControl.BLMaster    _objBlmaster      = new DataControl.BLMaster();
            APICategoryModel        objDroAPICategory = new APICategoryModel();
            string APIId = "";

            try
            {
                IEnumerable <APIServiceModel> lstAPICategory = _objBlmaster.GetAPIServiceDetail(APIId);
                var apiCatlist = (from cat in lstAPICategory.AsEnumerable()
                                  select new APIServiceModel()
                {
                    API_ID = cat.API_ID.ToString(),
                    ServiceId = cat.ServiceId.ToString()
                }).ToList <APIServiceModel>();
                return(Json(apiCatlist));
            }
            catch (Exception ex)
            {
                Dictionary <string, string> dicContext = new Dictionary <string, string>();
                DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
                return(Json("Sorry an error occured. Please try again later."));
            }
        }
Пример #3
0
        public string UpdateSalesActivityMapping(string nprojectcode, string nactivityCode, string oprojectcode, string oactivityCode, string startDate, string endDate, string mode, string status)
        {
            try
            {
                DataControl.BLMaster    _objBlMaster = new DataControl.BLMaster();
                DataControl.CurrentInfo _objCurInfo  = new DataControl.CurrentInfo();
                return(_objBlMaster.UpdateSalesActivityMapping(_objCurInfo.GetCompanyCode(), nprojectcode, nactivityCode, oprojectcode, oactivityCode, mode, status, startDate, endDate, _objCurInfo.GetUserName(), DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")));
            }
            catch (Exception ex)
            {
                Dictionary <string, string> dicObj = new Dictionary <string, string>();
                dicObj.Add("NProjectCode", nprojectcode);
                dicObj.Add("NActivityCode", nactivityCode);
                dicObj.Add("OProjectCode", oprojectcode);
                dicObj.Add("OActivityCode", oactivityCode);
                dicObj.Add("Mode", mode);
                dicObj.Add("Status", status);
                dicObj.Add("StartDate", startDate);
                dicObj.Add("EndDate", endDate);

                DataControl.Impl.ExceptionHandler.WriteLog(ex, dicObj);

                return("ERROR: " + ex.Message.ToString());
            }
        }
Пример #4
0
        public string InsertCompanyAppMapping(string appDetails)
        {
            CurrentInfo _objCurr   = new CurrentInfo();
            BLMaster    _objMaster = new DataControl.BLMaster();

            return(_objMaster.UpdateCompanyApp(_objCurr.GetCompanyCode(), appDetails, _objCurr.GetUserCode()));
        }
Пример #5
0
        public string GetUserProjectDetails(int pageNo)
        {
            int       totalPageNo = 1;
            const int PAGESIZE    = 10;

            DataControl.JSONConverter json                = new DataControl.JSONConverter();
            List <UserProjectMapping> lstUserProject      = new List <UserProjectMapping>();
            List <UserProjectMapping> lstUserProjectFiler = new List <UserProjectMapping>();

            DataControl.BLMaster    _objMapping = new DataControl.BLMaster();
            DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
            string        companyCode           = _objCurInfo.GetCompanyCode();
            StringBuilder sbTableContent        = new StringBuilder();

            lstUserProject      = (List <UserProjectMapping>)_objMapping.GetUserProjectMapDetails(companyCode, pageNo, PAGESIZE, ref totalPageNo);
            lstUserProjectFiler = (List <UserProjectMapping>)_objMapping.GetUserProjectMapallDetails(companyCode);
            try
            {
                if (lstUserProject != null && lstUserProject.Count > 0)
                {
                    sbTableContent.Append(Pager.Paging(pageNo, totalPageNo));
                    sbTableContent.Append("<table id='tblUserProject' class='table table-striped' >");
                    sbTableContent.Append("<thead class='active'>");
                    sbTableContent.Append("<tr style='background-color: #428bca'>");
                    sbTableContent.Append("<td>Edit</td>");
                    sbTableContent.Append("<td>Delete</td>");
                    sbTableContent.Append("<td>Project</td>");
                    sbTableContent.Append("<td>User</td>");
                    sbTableContent.Append("<td>Start Date</td>");
                    sbTableContent.Append("<td>End Date</td>");
                    sbTableContent.Append("</tr>");
                    sbTableContent.Append("</thead>");
                    sbTableContent.Append("<tbody>");
                    int i = 0;
                    foreach (var item in lstUserProject)
                    {
                        i++;
                        sbTableContent.Append("<tr><td><a href='#' onclick ='fnEdit(\"" + item.Project_Code.ToString() + "_" + item.User_Code.ToString() + "_" + item.Mapping_Code.ToString() + "_" + item.StartDate.ToString() + "_" + item.EndDate.ToString() + "\");'>Edit</a></td>");
                        sbTableContent.Append("<td><a href='#' onclick ='fnDelete(\"" + item.Project_Code.ToString() + "_" + item.User_Code.ToString() + "_" + item.Mapping_Code.ToString() + "\");'>Delete</a></td>");
                        sbTableContent.Append("<input type='hidden' id='hduserCode_" + i + "' value='" + item.User_Code.ToString() + "' />");
                        sbTableContent.Append("<input type='hidden' id='hdprojectCode_" + i + "' value='" + item.Project_Code.ToString() + "' />");
                        sbTableContent.Append("<td>" + item.Project_Name.ToString() + "</td>");
                        sbTableContent.Append("<td>" + item.User_Name.ToString() + "</td>");
                        sbTableContent.Append("<td>" + item.StartDate.ToString() + "</td>");
                        sbTableContent.Append("<td>" + item.EndDate.ToString() + "</td></tr>");
                    }
                }
                sbTableContent.Append("</tbody>");
                sbTableContent.Append("</table>");

                return(sbTableContent.ToString() + "*" + json.Serialize(lstUserProjectFiler));
            }
            catch (Exception ex)
            {
                Dictionary <string, string> dicContext = new Dictionary <string, string>();
                dicContext.Add("Filter:companyCode", companyCode);
                DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
                return("Sorry an error occured. Please try again later.");
            }
        }
Пример #6
0
        public string InsertProjectActivityMapping(string projectcode, string activityCode, string startDate, string endDate)
        {
            try
            {
                DataControl.CurrentInfo _objCurInfo  = new DataControl.CurrentInfo();
                DataControl.BLMaster    _objBlMaster = new DataControl.BLMaster();

                string createdBy = _objCurInfo.GetUserName();



                return(_objBlMaster.InsertSalesActivityMapping(_objCurInfo.GetCompanyCode(), projectcode, activityCode, startDate, endDate, createdBy, DateTime.Now.ToString("yyyy-MM-dd hh:mm:ss")));
            }
            catch (Exception ex)
            {
                Dictionary <string, string> dicObj = new Dictionary <string, string>();
                dicObj.Add("ProjectCode", projectcode);
                dicObj.Add("ActivityCode", activityCode);
                dicObj.Add("StartDate", startDate);
                dicObj.Add("EndDate", endDate);

                DataControl.Impl.ExceptionHandler.WriteLog(ex, dicObj);
                return("ERROR: " + ex.Message.ToString());
            }
        }
Пример #7
0
 public string RegionChangeStatus(string regionTypeCode, string ChangeStatus)
 {
     try
     {
         string result       = "";
         string statusChange = "0";
         if (ChangeStatus == "0")
         {
             statusChange = "1";
         }
         else
         {
             statusChange = "0";
         }
         DataControl.BLMaster    _objBlmaster    = new DataControl.BLMaster();
         DataControl.CurrentInfo _objCurrentInfo = new DataControl.CurrentInfo();
         string updatedDate = System.DateTime.Now.ToString("yyyy-MM-dd");
         string status      = _objBlmaster.RegionChangeStatus(_objCurrentInfo.GetCompanyCode(), regionTypeCode, statusChange, _objCurrentInfo.GetUserCode(), updatedDate);
         result = status.ToString();
         return(result);
     }
     catch (Exception ex)
     {
         Dictionary <string, string> dicContext = new Dictionary <string, string>();
         dicContext.Add("Filter:RegionTypeCode", regionTypeCode);
         dicContext.Add("Filter:ChangeStatus", ChangeStatus);
         DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
         throw new Exception("Sorry an error occurred. Please try again later");
     }
 }
Пример #8
0
        public JsonResult GetAPIServiceMappedDetail(string APIServiceId)
        {
            DataControl.CurrentInfo _objcurrentInfo = new DataControl.CurrentInfo();
            DataControl.BLMaster    _objBlmaster    = new DataControl.BLMaster();
            string companyCode = _objcurrentInfo.GetCompanyCode();

            try
            {
                IEnumerable <CompanyAccessModel> lstAPICategory = _objBlmaster.GetAPIComapanyMapDetail(APIServiceId, companyCode);
                var apiCatlist = (from cat in lstAPICategory.AsEnumerable()
                                  select new CompanyAccessModel()
                {
                    API_ID = cat.API_ID.ToString(),
                    Company_Code = cat.Company_Code,
                    User_Type_Code = cat.User_Type_Code,
                }).ToList <CompanyAccessModel>();
                return(Json(apiCatlist));
            }
            catch (Exception ex)
            {
                Dictionary <string, string> dicContext = new Dictionary <string, string>();
                DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
                return(Json("Sorry an error occured. Please try again later."));
            }
        }
Пример #9
0
        public int InsertUserProduct(string userCode, string productCode, string minCounts, string maxCounts)
        {
            DataControl.BLMaster    _objMapping = new DataControl.BLMaster();
            DataControl.CurrentInfo objCurInfo  = new DataControl.CurrentInfo();
            string companyCode = objCurInfo.GetCompanyCode();

            userCode = userCode + ',';
            string currentDate = DateTime.Now.ToString("yyyy-MM-dd");

            try
            {
                int result = _objMapping.InsertDivisionUserProductMapping(companyCode, userCode, productCode, minCounts, maxCounts);
                //int result = _objMapping.InsertDivUserProducts(companyCode, userCode, productCode, currentDate);

                return(result);
            }
            catch (Exception ex)
            {
                Dictionary <string, string> dicContext = new Dictionary <string, string>();
                dicContext.Add("Filter:companyCode", companyCode);
                dicContext.Add("Filter:UserCode", userCode);
                dicContext.Add("Filter:ProductCode", productCode);
                DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
                return(0);
            }
        }
Пример #10
0
        public string GetAPIServiceDefinInputDetail(string APIServiceId)
        {
            DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
            string companyCode = _objCurInfo.GetCompanyCode();

            string[] APIparameter;
            try
            {
                DataControl.JSONConverter json           = new DataControl.JSONConverter();
                List <APIServiceModel>    lstServiceMap  = new List <APIServiceModel>();
                DataControl.BLMaster      _objMapping    = new DataControl.BLMaster();
                StringBuilder             sbTableContent = new StringBuilder();
                lstServiceMap = (List <APIServiceModel>)_objMapping.GetAPIServiceDetail(APIServiceId);
                if (lstServiceMap != null && lstServiceMap.Count > 0)
                {
                    int i = 0;
                    sbTableContent.Append("<table id='tblAPIInputs' class='table table-striped' >");
                    sbTableContent.Append("<thead class='active'>");
                    sbTableContent.Append("<tr style='background-color: #428bca'>");
                    sbTableContent.Append("<td>Service Parameters</td>");
                    sbTableContent.Append("<td>Display Order</td>");
                    sbTableContent.Append("<td>Get Session</td>");
                    sbTableContent.Append("<td>Session Key</td>");
                    sbTableContent.Append("<td>Show in UI</td>");
                    sbTableContent.Append("<td>Control type</td>");
                    sbTableContent.Append("<td>Description</td>");
                    sbTableContent.Append("</tr>");
                    sbTableContent.Append("</thead>");
                    sbTableContent.Append("<tbody>");
                    foreach (var item in lstServiceMap)
                    {
                        APIparameter = item.ServiceParams.Split(',');
                        foreach (string splitParam in APIparameter)
                        {
                            i++;
                            sbTableContent.Append("<tr ><td id='ParamName" + i + "'><span id='splitParam_" + i + "'>" + splitParam + "</span></td>");
                            sbTableContent.Append("<td id='textbox " + i + "'><input id='paramOrder_" + i + "'value='" + i + "' type='TextBox'></td>");
                            sbTableContent.Append("<td id='checkboxSession " + i + "'><input type='checkbox' onclick='fnGetSession()' id='Chk_getsession_" + i + "' name='chk_session' /></td>");
                            sbTableContent.Append("<td id='ddl " + i + "'><select id='ddlSessionSelection_" + i + "'><option value='0'>-Select Mode-</option> <option value='Comp_Code'>Comp_Code</option><option value='User_Code'>User_Code</option><option value='Region_Code'>Region_Code</option><option value='User_Type_Code'>User_Type_Code</option></select></td>");
                            sbTableContent.Append("<td id='checkUI " + i + "'><input type='checkbox' onclick='fnGetUI()' id='Chk_UI_" + i + "' Value='Y' name='chk_UI' /></td>");
                            sbTableContent.Append("<td id='ddlControl_ " + i + "'><select id='ddlControl_" + i + "'><option value='0'>-Select Mode-</option> <option value='TEXT'>TEXT</option><option value='DATE'>DATE</option><option value='TEXT_CSV'>TEXT_CSV</option></select></td>");
                            sbTableContent.Append("<td id='textarea " + i + "'><textarea id='Description_" + i + "'></textarea></td>");
                        }
                        sbTableContent.Append("<td></td></tr>");
                    }
                }
                sbTableContent.Append("</tbody>");
                sbTableContent.Append("</table>");

                return(sbTableContent.ToString() + "*" + json.Serialize(lstServiceMap));
            }
            catch (Exception ex)
            {
                Dictionary <string, string> dicContext = new Dictionary <string, string>();
                dicContext.Add("Filter:companyCode", companyCode);
                DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
                return("Sorry an error occured. Please try again later.");
            }
        }
Пример #11
0
        public string GetPrivilegeAccessLogReport(string fromDate, string toDate, string userTypeCodes, string isExcel)
        {
            StringBuilder strContent = new StringBuilder();
            string        blobUrl    = string.Empty;

            strContent.Append("<table><tr><td colspan='7'  class='tblhead'>Privilege Log Report - Log Period  " + fromDate.Split('-')[2]
                              + "/" + fromDate.Split('-')[1] + "/" + fromDate.Split('-')[0] + " to " + toDate.Split('-')[2]
                              + "/" + toDate.Split('-')[1] + "/" + toDate.Split('-')[0] + "</td></tr></table>");
            strContent.Append("<table class='table table-striped'><thead><tr><th>S.No</th><th>Date</th><th>Privilege Name </th><th>Privilege Value Name</th>");
            strContent.Append("<th>User Type Name</th><th>Record Status</th><th>Request from</th><th>Request Date</th><th>Request Reason</th>");
            strContent.Append("<th>Support User Name</th><th>Updated By</th></tr></thead><tbody>");
            try
            {
                DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
                DataControl.BLMaster    objMaster  = new DataControl.BLMaster();
                List <MVCModels.HiDoctor_Master.UserTypePrivilegeMappingModel> lstPrivilege =
                    new List <MVCModels.HiDoctor_Master.UserTypePrivilegeMappingModel>(objMaster.GetPrivilegeLogReport(objCurInfo.GetCompanyCode(),
                                                                                                                       fromDate, toDate, userTypeCodes));
                int i = 0;
                if (lstPrivilege.Count > 0)
                {
                    foreach (var dr in lstPrivilege)
                    {
                        i++;
                        strContent.Append("<tr><td>" + i + "</td>");
                        strContent.Append("<td>" + dr.Mapping_Updated_Date + "</td>");
                        strContent.Append("<td>" + dr.Privilege_Name + "</td>");
                        strContent.Append("<td>" + dr.Privilege_Value_Name + "</td>");
                        strContent.Append("<td>" + dr.User_Type_Name + "</td>");
                        strContent.Append("<td>" + dr.Record_Status + "</td>");
                        strContent.Append("<td>" + dr.Request_From + "</td>");
                        strContent.Append("<td>" + dr.Request_Date + "</td>");
                        strContent.Append("<td>" + dr.Request_Reason + "</td>");
                        strContent.Append("<td>" + dr.Support_User_Name + "</td>");
                        strContent.Append("<td>" + dr.Mapping_Updated_By + "</td></tr>");
                    }
                }
                strContent.Append("</tbody>");
                strContent.Append("</table>");
                if ("Y" == isExcel)
                {
                    DataControl.Abstraction.IConfigProvider iConfigPro   = new DataControl.Impl.ConfigProvider();
                    DataControl.Repository.AzureBlobUpload  objAzureBlob = new DataControl.Repository.AzureBlobUpload();
                    string accKey   = iConfigPro.GetConfigValue("SWAASBLOBACCKEY");
                    string userName = objCurInfo.GetUserName();
                    string compCode = objCurInfo.GetCompanyCode();
                    string fileName = "PRIVILEGELOG_" + "_" + compCode + "_" + userName + ".xls";
                    blobUrl = objAzureBlob.AzureBlobUploadText(strContent.ToString(), accKey, fileName, "bulkdatasvc");
                    strContent.Clear();
                    strContent.Append(blobUrl);
                }
            }
            catch (Exception ex)
            {
                Dictionary <string, string> dicContext = new Dictionary <string, string>();
                DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
            }
            return(strContent.ToString());
        }
Пример #12
0
        //For excell
        public void PutRequestCategoryMasterIntoExcel()
        {
            string        blobUrl        = string.Empty;
            string        error          = string.Empty;
            StringBuilder sbTableContent = new StringBuilder();

            DataControl.CurrentInfo _objCurrentInfo = new DataControl.CurrentInfo();
            string        companyCode = _objCurrentInfo.GetCompanyCode();
            StringBuilder sb          = new StringBuilder();

            DataControl.BLMaster _objBlmaster = new DataControl.BLMaster();
            DataControl.Repository.FileDownload objFileDownload = new DataControl.Repository.FileDownload();
            try
            {
                DataControl.JSONConverter         json          = new DataControl.JSONConverter();
                List <RequestCategoryMasterModel> lstRequestMap = new List <RequestCategoryMasterModel>();
                DataControl.BLMaster _objMapping = new DataControl.BLMaster();

                lstRequestMap = (List <RequestCategoryMasterModel>)_objMapping.GetRequestCategoryDetail(companyCode);
                if (lstRequestMap != null && lstRequestMap.Count > 0)
                {
                    sbTableContent.Append("<table id='tblrequest' class='table table-striped' >");
                    sbTableContent.Append("<thead class='active'>");
                    sbTableContent.Append("<tr style='background-color: #428bca'>");

                    sbTableContent.Append("<td>Request Category Name</td>");
                    sbTableContent.Append("<td>Status</td>");
                    sbTableContent.Append("</tr>");
                    sbTableContent.Append("</thead>");
                    sbTableContent.Append("<tbody>");
                    foreach (var item in lstRequestMap)
                    {
                        sbTableContent.Append("<tr><td>" + item.Request_Category_Name + "</td>");
                        sbTableContent.Append("<td>" + item.Request_Category_Status + "</td></tr>");
                    }
                }
                sbTableContent.Append("</tbody>");
                sbTableContent.Append("</table>");


                DataControl.Abstraction.IConfigProvider iConfigPro   = new DataControl.Impl.ConfigProvider();
                DataControl.Repository.AzureBlobUpload  objAzureBlob = new DataControl.Repository.AzureBlobUpload();
                string accKey = iConfigPro.GetConfigValue("SWAASBLOBACCKEY");

                string userName      = _objCurrentInfo.GetUserName();
                string subdomainName = System.Web.HttpContext.Current.Request.Url.DnsSafeHost;;

                string fileName = "RequestCategoryMaster " + " - " + subdomainName + " - " + userName + ".xls";
                blobUrl = objAzureBlob.AzureBlobUploadText(sbTableContent.ToString(), accKey, fileName, "bulkdatasvc");

                objFileDownload.DownloadFile(blobUrl, fileName, out error);
            }
            catch (Exception ex)
            {
                Dictionary <string, string> dicContext = new Dictionary <string, string>();;
                DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
            }
        }
Пример #13
0
        public JsonResult GetUserProducts(FormCollection collection)
        {
            string userCode = collection["User_Code"].ToString();

            DataControl.BLMaster _objBlmaster = new DataControl.BLMaster();
            List <UserProducts>  obj          = _objBlmaster.GetUserProducts(userCode);

            return(Json(obj, JsonRequestBehavior.AllowGet));
        }
Пример #14
0
        public int UpdateUserProject(string userCode, string projectCode, string startDate, string endDate, string oldprojectCode)
        {
            DataControl.BLMaster    _objMapping = new DataControl.BLMaster();
            DataControl.CurrentInfo objCurInfo  = new DataControl.CurrentInfo();
            string companyCode = objCurInfo.GetCompanyCode();
            int    result      = _objMapping.UpdateUserProject(companyCode, userCode, projectCode, startDate, endDate, oldprojectCode);

            return(result);
        }
Пример #15
0
        //GetRegionTypeDetail

        public JsonResult GetRegionTypeDetail()
        {
            DataControl.BLMaster    _objBlmaster    = new DataControl.BLMaster();
            DataControl.CurrentInfo _objCurrentInfo = new DataControl.CurrentInfo();
            DataSet ds = new DataSet();

            ds = _objBlmaster.GetRegiontypeDetailsAll(_objCurrentInfo.GetCompanyCode());
            DataControl.JSONConverter _objJson = new DataControl.JSONConverter();
            return(Json(_objJson.Serialize(ds), JsonRequestBehavior.AllowGet));
        }
Пример #16
0
        public void PutProjectActivityIntoAzure(FormCollection coll)
        {
            try
            {
                string error = string.Empty;
                DataControl.BLMaster                  _objBlMaster    = new DataControl.BLMaster();
                DataControl.CurrentInfo               _objCurInfo     = new DataControl.CurrentInfo();
                DataControl.Repository.FileDownload   objFileDownload = new DataControl.Repository.FileDownload();
                DataControl.Abstraction.IFileProvider objProvider     = new DataControl.Impl.FileSystemProvider();

                StringBuilder tblBuilder    = new StringBuilder();
                string        companyCode   = _objCurInfo.GetCompanyCode();
                int           rowNum        = 0;
                DataSet       dsProjActMapp = _objBlMaster.GetSalesActivityMapping(companyCode);
                if (dsProjActMapp != null && dsProjActMapp.Tables.Count > 0 && dsProjActMapp.Tables[0].Rows.Count > 0)
                {
                    tblBuilder.Append("<table id='tblSFC' class='table table-striped' cellpadding='0' cellspacing='0'>");
                    tblBuilder.Append("<thead><tr><th>Project Name</th><th>Activity Name</th><th>Start Date</th><th>End Date</th><th>Status</th></tr></thead>");
                    tblBuilder.Append("<tbody>");

                    foreach (DataRow dr in dsProjActMapp.Tables[0].Rows)
                    {
                        rowNum++;
                        tblBuilder.Append("<tr>");
                        tblBuilder.Append("<td>" + dr["Project_Name"].ToString() + "<input type='hidden' id='hdnProjCode_" + rowNum + "' value='" + dr["Project_Code"].ToString() + "' /></td>");
                        tblBuilder.Append("<td>" + dr["Activity_Name"].ToString() + "<input type='hidden' id='hdnActivityCode_" + rowNum + "' value='" + dr["Activity_Code"].ToString() + "' /></td>");
                        tblBuilder.Append("<td id='tdStartDate_" + rowNum + "'>" + dr["StartDate"].ToString() + "</td>");
                        tblBuilder.Append("<td id='tdEndDate_" + rowNum + "'>" + dr["EndDate"].ToString() + "</td>");
                        tblBuilder.Append("<td id='tdStatus_" + rowNum + "'>" + dr["Status"].ToString() + "</td>");
                        tblBuilder.Append("</tr>");
                    }

                    tblBuilder.Append("</tbody>");
                    tblBuilder.Append("</table>");
                }

                DataControl.Abstraction.IConfigProvider iConfigPro   = new DataControl.Impl.ConfigProvider();
                DataControl.Repository.AzureBlobUpload  objAzureBlob = new DataControl.Repository.AzureBlobUpload();
                string accKey = iConfigPro.GetConfigValue("SWAASBLOBACCKEY");

                string userName      = _objCurInfo.GetUserName();
                string subdomainName = HttpContext.Request.Url.DnsSafeHost.ToString();

                string fileName = "ProjectActivityMapping" + " - " + subdomainName + " - " + userName + ".xls";
                string blobUrl  = objAzureBlob.AzureBlobUploadText(tblBuilder.ToString(), accKey, fileName, "bulkdatasvc");

                objFileDownload.DownloadFile(blobUrl, fileName, out error);
            }
            catch (Exception ex)
            {
                Dictionary <string, string> dicObj = new Dictionary <string, string>();
                DataControl.Impl.ExceptionHandler.WriteLog(ex, dicObj);
            }
        }
Пример #17
0
        public JsonResult GetUsers(string userTypeCode, string divisionCode)
        {
            DataControl.BLMaster    _objBlmaster          = new DataControl.BLMaster();
            DataControl.CurrentInfo _objCurInfo           = new DataControl.CurrentInfo();
            List <MVCModels.DivisionUserProducts> lstuser = new List <MVCModels.DivisionUserProducts>();
            string companyCode = _objCurInfo.GetCompanyCode();

            lstuser = (List <MVCModels.DivisionUserProducts>)_objBlmaster.GetUsersByUserTypeAndDivision(companyCode, userTypeCode, divisionCode);
            DataControl.JSONConverter _objJson = new DataControl.JSONConverter();
            return(Json(_objJson.Serialize(lstuser)));
        }
Пример #18
0
        //public string GetDisabledUsers()
        //{
        //    StringBuilder strUsers = new StringBuilder();
        //    DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
        //    DataControl.BLUser objUser = new DataControl.BLUser();
        //    IEnumerable<MVCModels.HiDoctor_Master.UserModel> lstUser = null;
        //    lstUser = objUser.GetDisabledUsers(objCurInfo.GetCompanyCode());
        //    strUsers.Append("<ul>");
        //    if (lstUser != null)
        //    {
        //        foreach (var user in lstUser)
        //        {
        //            strUsers.Append("<li onclick='fnGetUser(\"" + user.User_Code + "\")'>" + user.User_Name + "</li>");
        //        }
        //    }
        //    strUsers.Append("</ul>");
        //    return strUsers.ToString();
        //}

        //public string GetResignedUserLeaveTakenReport()
        //{
        //    StringBuilder strTblContent = new StringBuilder();
        //    DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
        //    DataControl.BLUser objUser = new DataControl.BLUser();
        //    DataControl.BLLeave objLeave = new DataControl.BLLeave();

        //    return strTblContent.ToString();
        //}

        #region get user menu access log report
        public string GetUserMenuAccessLogReport(string fromDate, string toDate, string userTypeCodes, string isExcel)
        {
            StringBuilder strContent = new StringBuilder();
            string        blobUrl    = string.Empty;

            strContent.Append("<table><tr><td colspan='7' class='tblhead'>Menu Access Log Report - Log Period  " + fromDate.Split('-')[2]
                              + "/" + fromDate.Split('-')[1] + "/" + fromDate.Split('-')[0] + " to " + toDate.Split('-')[2]
                              + "/" + toDate.Split('-')[1] + "/" + toDate.Split('-')[0] + "</td></tr></table>");
            strContent.Append("<table class='table table-striped'><thead><tr><th>S.No</th><th>Date</th><th>User Type Name </th><th>Menu Name</th>");
            strContent.Append("<th>Menu URL</th><th>Access</th><th>Changed By</th></tr></thead><tbody>");
            try
            {
                DataControl.CurrentInfo objCurInfo = new DataControl.CurrentInfo();
                DataControl.BLMaster    objMaster  = new DataControl.BLMaster();
                List <MVCModels.UserTypeMenuAccessModel> lstUserMenu =
                    new List <UserTypeMenuAccessModel>(objMaster.GetUserTypeMenuAccessLog(objCurInfo.GetCompanyCode(), fromDate, toDate, userTypeCodes));
                int i = 0;
                if (lstUserMenu.Count > 0)
                {
                    foreach (var dr in lstUserMenu)
                    {
                        i++;
                        strContent.Append("<tr><td>" + i + "</td>");
                        strContent.Append("<td>" + dr.Updated_Date + "</td>");
                        strContent.Append("<td>" + dr.User_Type_Name + "</td>");
                        strContent.Append("<td>" + dr.Menu_Text + "</td>");
                        strContent.Append("<td>" + dr.Menu_URL + "</td>");
                        strContent.Append("<td>" + dr.Access + "</td>");
                        strContent.Append("<td>" + dr.Updated_By + "</td></tr>");
                    }
                }
                strContent.Append("</tbody>");
                strContent.Append("</table>");
                if ("Y" == isExcel)
                {
                    DataControl.Abstraction.IConfigProvider iConfigPro   = new DataControl.Impl.ConfigProvider();
                    DataControl.Repository.AzureBlobUpload  objAzureBlob = new DataControl.Repository.AzureBlobUpload();
                    string accKey   = iConfigPro.GetConfigValue("SWAASBLOBACCKEY");
                    string userName = objCurInfo.GetUserName();
                    string compCode = objCurInfo.GetCompanyCode();
                    string fileName = "MENUACCESSLOG_" + "_" + compCode + "_" + userName + ".xls";
                    blobUrl = objAzureBlob.AzureBlobUploadText(strContent.ToString(), accKey, fileName, "bulkdatasvc");
                    strContent.Clear();
                    strContent.Append(blobUrl);
                }
            }
            catch (Exception ex)
            {
                Dictionary <string, string> dicContext = new Dictionary <string, string>();
                DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
            }

            return(strContent.ToString());
        }
Пример #19
0
        public ActionResult DFCExcelBulkAddResult(HttpPostedFileBase file)
        {
            string result = "";

            DataControl.BLMaster    _objMast    = new DataControl.BLMaster();
            DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
            string subDomain = _objCurInfo.GetSubDomain();

            result            = _objMast.InsertDFCExcelBulkUpload(subDomain, _objCurInfo.GetCompanyCode(), Guid.NewGuid().ToString(), file, _objCurInfo.GetUserCode());
            ViewBag.ErrorCode = result;
            return(View("DFCExcelBulkAddResult"));
        }
Пример #20
0
        public JsonResult GetPrivileges(string userTypeCode)
        {
            DataControl.BLMaster    _objBlmaster          = new DataControl.BLMaster();
            DataControl.CurrentInfo _objCurInfo           = new DataControl.CurrentInfo();
            List <MVCModels.DivisionUserProducts> lstuser = new List <MVCModels.DivisionUserProducts>();
            string companyCode   = _objCurInfo.GetCompanyCode();
            string privilageName = "DCR_PRODUCTS_BRING_TYPE";

            lstuser = (List <MVCModels.DivisionUserProducts>)_objBlmaster.Getprivilagevalues(companyCode, userTypeCode, privilageName);
            DataControl.JSONConverter _objJson = new DataControl.JSONConverter();
            return(Json(_objJson.Serialize(lstuser)));
        }
Пример #21
0
 /// <summary>
 /// Method to Get the Project , Activity Details for prefilling
 /// </summary>
 /// <param name="coll"></param>
 /// <returns></returns>
 ///
 public JsonResult GetProjectActivityDetails(FormCollection coll)
 {
     try
     {
         DataControl.BLMaster    _objBlMaster = new DataControl.BLMaster();
         DataControl.CurrentInfo _objCurInfo  = new DataControl.CurrentInfo();
         DataSet dsProjAct = _objBlMaster.GetSalesActivity(_objCurInfo.GetCompanyCode());
         return(Json(_objJson.Serialize(dsProjAct)));
     }
     catch (Exception ex)
     {
         Dictionary <string, string> dicObj = new Dictionary <string, string>();
         DataControl.Impl.ExceptionHandler.WriteLog(ex, dicObj);
         return(null);
     }
 }
Пример #22
0
        public string GetAPIServiceUserType()
        {
            DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
            string companyCode = _objCurInfo.GetCompanyCode();

            try
            {
                DataControl.JSONConverter json           = new DataControl.JSONConverter();
                List <UserTypeModel>      lstuserType    = new List <UserTypeModel>();
                DataControl.BLMaster      _objMapping    = new DataControl.BLMaster();
                StringBuilder             sbTableContent = new StringBuilder();
                lstuserType = (List <UserTypeModel>)_objMapping.GetAPIUserTypeDetail(companyCode);
                if (lstuserType != null && lstuserType.Count > 0)
                {
                    sbTableContent.Append("<table id='tblAPIUserType' class='table table-striped' >");
                    sbTableContent.Append("<thead class='active'>");
                    sbTableContent.Append("<tr style='background-color: #428bca'>");
                    sbTableContent.Append("<td>UserType Name</td>");
                    sbTableContent.Append("<td><input type='checkbox' id='bulkcheck'name='bulkchk_User' onclick='fnselectall()'/>Service Access</td>");
                    sbTableContent.Append("</tr>");
                    sbTableContent.Append("</thead>");
                    sbTableContent.Append("<tbody>");
                    int i = 0;
                    foreach (var item in lstuserType)
                    {
                        i++;
                        sbTableContent.Append("<tr ><td><span id='userTypeName_" + i + "'>" + item.User_Type_Name + "</span></td>");
                        sbTableContent.Append("<td id='checkboxAccess " + i + "'><input type='checkbox'  id='Chk_Access_" + i + "'name='chk_Access' /></td>");
                        sbTableContent.Append("<td style='display:none'><span id='userTypeCode_" + i + "'>" + item.User_Type_Code + "</span></td>");
                        sbTableContent.Append("<td style='display:none'><span id='companyCode_" + i + "'>" + item.Company_Code + "</span></td>");
                        sbTableContent.Append("</tr>");
                    }
                }
                sbTableContent.Append("</tbody>");
                sbTableContent.Append("</table>");

                return(sbTableContent.ToString() + "*" + json.Serialize(lstuserType));
            }
            catch (Exception ex)
            {
                Dictionary <string, string> dicContext = new Dictionary <string, string>();
                dicContext.Add("Filter:companyCode", companyCode);
                DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
                return("Sorry an error occured. Please try again later.");
            }
        }
Пример #23
0
        public JsonResult GetKIRegionType(string RegionTypeName)
        {
            KI_RegionTypeModel obj = new KI_RegionTypeModel();

            try
            {
                CurrentInfo _objCurrInfo = new CurrentInfo();
                BLMaster    _objBlmaster = new DataControl.BLMaster();
                string      companyCode  = _objCurrInfo.GetCompanyCode();
                obj = _objBlmaster.GetKIRegionType(companyCode, RegionTypeName);
                return(Json(obj, JsonRequestBehavior.AllowGet));
            }
            catch (Exception ex)
            {
                throw;
            }
        }
Пример #24
0
        public bool GetRefKey_2(string refKey, string Regionclassificationname, string mode)
        {
            bool result = false;

            try
            {
                DataControl.BLMaster _objBlmaster = new DataControl.BLMaster();
                CurrentInfo          objCurInfo   = new CurrentInfo();
                string companyCode = objCurInfo.GetCompanyCode();
                result = _objBlmaster.GetRefKey_2(companyCode, refKey, Regionclassificationname, mode);
            }
            catch (Exception ex)
            {
                throw (ex);
            }
            return(result);
        }
Пример #25
0
        /// <summary>
        /// Method to get the Project - Activity Mapping details for the Grid
        /// </summary>
        /// <param name="coll"></param>
        /// <returns></returns>
        public string GetProjectActivityMappingDetails(FormCollection coll)
        {
            try
            {
                DataControl.BLMaster    _objBlMaster = new DataControl.BLMaster();
                DataControl.CurrentInfo _objCurInfo  = new DataControl.CurrentInfo();
                StringBuilder           tblBuilder   = new StringBuilder();
                string  companyCode   = _objCurInfo.GetCompanyCode();
                int     rowNum        = 0;
                DataSet dsProjActMapp = _objBlMaster.GetSalesActivityMapping(companyCode);
                if (dsProjActMapp != null && dsProjActMapp.Tables.Count > 0 && dsProjActMapp.Tables[0].Rows.Count > 0)
                {
                    tblBuilder.Append("<table id='tblSFC' class='table table-striped' cellpadding='0' cellspacing='0'>");
                    tblBuilder.Append("<thead><tr><th class='Clstextleft'>Edit</th><th class='Clstextleft'>Change Status</th><th class='Clstextleft'>Project Name</th><th class='Clstextleft'>Activity Name</th><th class='Clstextleft'>Start Date</th><th class='Clstextleft'>End Date</th><th class='Clstextleft'>Status</th></tr></thead>");
                    tblBuilder.Append("<tbody>");

                    foreach (DataRow dr in dsProjActMapp.Tables[0].Rows)
                    {
                        rowNum++;
                        tblBuilder.Append("<tr>");
                        tblBuilder.Append("<td> <a href='#' style='cursor:pointer' onclick='fnEditProjAct(" + rowNum + ")'>Edit</a></td>");
                        tblBuilder.Append("<td> <a href='#' style='cursor:pointer' onclick='fnchangeStatus(" + rowNum + ")'>Change Status</a></td>");

                        tblBuilder.Append("<td>" + dr["Project_Name"].ToString() + "<input type='hidden' id='hdnProjCode_" + rowNum + "' value='" + dr["Project_Code"].ToString() + "' /></td>");
                        tblBuilder.Append("<td>" + dr["Activity_Name"].ToString() + "<input type='hidden' id='hdnActivityCode_" + rowNum + "' value='" + dr["Activity_Code"].ToString() + "' /></td>");
                        tblBuilder.Append("<td id='tdStartDate_" + rowNum + "'>" + dr["StartDate"].ToString() + "</td>");
                        tblBuilder.Append("<td id='tdEndDate_" + rowNum + "'>" + dr["EndDate"].ToString() + "</td>");
                        tblBuilder.Append("<td id='tdStatus_" + rowNum + "'>" + dr["Status"].ToString() + "</td>");

                        tblBuilder.Append("</tr>");
                    }

                    tblBuilder.Append("</tbody>");
                    tblBuilder.Append("</table>");
                }

                return(tblBuilder.ToString());
            }
            catch (Exception ex)
            {
                Dictionary <string, string> dicObj = new Dictionary <string, string>();
                DataControl.Impl.ExceptionHandler.WriteLog(ex, dicObj);
                return(ex.Message.ToString());
            }
        }
Пример #26
0
        public string GetCategoryDetail()
        {
            DataControl.CurrentInfo _objCurInfo = new DataControl.CurrentInfo();
            string companyCode = _objCurInfo.GetCompanyCode();

            try
            {
                DataControl.JSONConverter json           = new DataControl.JSONConverter();
                List <APICategoryModel>   lstCategoryMap = new List <APICategoryModel>();
                DataControl.BLMaster      _objMapping    = new DataControl.BLMaster();
                StringBuilder             sbTableContent = new StringBuilder();
                lstCategoryMap = (List <APICategoryModel>)_objMapping.GetAPICategoryDetail();
                if (lstCategoryMap != null && lstCategoryMap.Count > 0)
                {
                    sbTableContent.Append("<table id='tblAPIcategory' class='table table-striped' >");
                    sbTableContent.Append("<thead class='active'>");
                    sbTableContent.Append("<tr style='background-color: #428bca'>");
                    sbTableContent.Append("<td>Edit</td>");
                    sbTableContent.Append("<td>API Category Name</td>");
                    sbTableContent.Append("<td>API Category Description</td>");
                    sbTableContent.Append("<td>Status</td>");
                    sbTableContent.Append("</tr>");
                    sbTableContent.Append("</thead>");
                    sbTableContent.Append("<tbody>");
                    foreach (var item in lstCategoryMap)
                    {
                        sbTableContent.Append("<tr><td><a href='#' style='color:blue' onclick ='fnEdit(\"" + item.API_Category_Code.ToString() + "_" + item.API_Category_Name.ToString() + "_" + item.API_Category_Description.ToString() + "_" + item.API_Category_Status.ToString() + "\");'>Edit</a></td>");
                        sbTableContent.Append("<td>" + item.API_Category_Name + "</td>");
                        sbTableContent.Append("<td>" + item.API_Category_Description + "</td>");
                        sbTableContent.Append("<td>" + item.API_Category_Status + "</td></tr>");
                    }
                }
                sbTableContent.Append("</tbody>");
                sbTableContent.Append("</table>");

                return(sbTableContent.ToString() + "*" + json.Serialize(lstCategoryMap));
            }
            catch (Exception ex)
            {
                Dictionary <string, string> dicContext = new Dictionary <string, string>();
                dicContext.Add("Filter:companyCode", companyCode);
                DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
                return("Sorry an error occured. Please try again later.");
            }
        }
Пример #27
0
 public int DeleteUserProject(string projectCode)
 {
     try
     {
         DataControl.BLMaster    _objMapping = new DataControl.BLMaster();
         DataControl.CurrentInfo objCurInfo  = new DataControl.CurrentInfo();
         string companyCode = objCurInfo.GetCompanyCode();
         int    result      = _objMapping.UpdateUserProjectMapping(companyCode, projectCode);
         return(result);
     }
     catch (Exception ex)
     {
         Dictionary <string, string> dicContext = new Dictionary <string, string>();
         dicContext.Add("Filter:ProjectCode", projectCode);
         DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
         return(2);
     }
 }
Пример #28
0
        public int GetRefKey2(string Refkey2)
        {
            string companyCode = null;
            int    result;

            try
            {
                DataControl.BLMaster    _objBlmaster    = new DataControl.BLMaster();
                DataControl.CurrentInfo _objCurrentInfo = new DataControl.CurrentInfo();
                companyCode = _objCurrentInfo.GetCompanyCode();
                result      = _objBlmaster.GetRefKey2(companyCode, Refkey2);
                return(result);
            }
            catch (Exception ex)
            {
                throw ex;
            }
        }
Пример #29
0
        //REQUEST CATEGORY MASTER-SRI//
        public int InsertRequestCategory(string requestCategoryName, string status)
        {
            DataControl.BLMaster    _objMapping = new DataControl.BLMaster();
            DataControl.CurrentInfo objCurInfo  = new DataControl.CurrentInfo();
            string companyCode = objCurInfo.GetCompanyCode();

            try
            {
                int result = _objMapping.InsertRequestCategory(companyCode, requestCategoryName, status);
                return(result);
            }
            catch (Exception ex)
            {
                Dictionary <string, string> dicContext = new Dictionary <string, string>();
                dicContext.Add("Filter:companyCode", companyCode);
                dicContext.Add("Filter:RequestCategoryName", requestCategoryName);
                dicContext.Add("Filter:Status", status);
                DataControl.Impl.ExceptionHandler.WriteLog(ex, dicContext);
                return(2);
            }
        }
Пример #30
0
        public string SaveUserProduct(FormCollection collection)
        {
            string User_Code           = collection["User_Code"].ToString();
            string Product_Code        = collection["Product_Code"].ToString();
            int    minCount            = collection["minCount"].ToString() == "" ? 0 : Convert.ToInt32(collection["minCount"].ToString());
            int    maxCount            = collection["maxCount"].ToString() == "" ? 0 : Convert.ToInt32(collection["maxCount"].ToString());;
            string User_Product_Status = collection["status"].ToString();

            DataControl.BLMaster _objMapping = new DataControl.BLMaster();
            string result = "";

            try
            {
                result = _objMapping.SaveUserProduct(User_Code, Product_Code, minCount, maxCount, User_Product_Status);
            }
            catch (Exception ex)
            {
                throw ex;
            }
            return(result);
        }