public static string AssignedToMe(string cgi) { try { CryptoJS objcryptoJS = new CryptoJS(); string ContractorAppId = string.Empty; ContractorAppId = cgi.ToString() == null ? string.Empty : cgi.ToString(); if (GlobalMethods.ValueIsNull(ContractorAppId).Length > 0) { ContractorAppId = objcryptoJS.AES_decrypt(HttpUtility.UrlEncode(cgi), AppConstants.secretKey, AppConstants.initVec).ToString(); } clsRiskAssessor_Approval objRiskApp = new clsRiskAssessor_Approval(); objRiskApp.InspectorRiskAssId = Convert.ToInt32(ContractorAppId); objRiskApp.MDE_Owner_AuthorisedUserId = Convert.ToInt32(HttpContext.Current.Session["UserAuthId"]); //objRiskApp.CreateDate = DateTime.Now; //objRiskApp.CreatedBy = HttpContext.Current.Session["UserAuthId"].ToString(); //objRiskApp.UpdatedDate = Convert.ToDateTime("1/1/1900"); //objRiskApp.UpdatedBy = ""; objRiskApp.Notes = ""; objRiskApp.IsActive = 1; if (!RiskAssessor_ApprovalDAL.InsertRiskAssessor_Approval(objRiskApp)) { } } catch (Exception) { ErrorHandler.ErrorPage(); } return("MDE_RiskApps.aspx?riskapps=active"); }
public static Boolean InsertUpdateRiskAssessor_Approval(clsRiskAssessor_Approval objRiskAssessor_Approval) { bool isAdded = false; string SpName = "usp_InsertUpdateRiskAssessor_Approval"; try { using (IDbConnection db = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["databaseConnection"])) { db.Execute(SpName, objRiskAssessor_Approval, commandType: CommandType.StoredProcedure); } isAdded = true; } catch (Exception ex) { ErrorHandler.ErrorLogging(ex, false); ErrorHandler.ReadError(); } return(isAdded); }
public static clsRiskAssessor_Approval SelectRiskAssessor_ApprovalById(int?MDEInspRiskAssApprovalId) { clsRiskAssessor_Approval objRiskAssessor_Approval = new clsRiskAssessor_Approval(); bool isnull = true; string SpName = "usp_SelectRiskAssessor_Approval"; var objPar = new DynamicParameters(); if (String.IsNullOrEmpty(MDEInspRiskAssApprovalId.ToString())) { throw new ArgumentException("Function parameters cannot be blank!"); } else { try { objPar.Add("@MDEInspRiskAssApprovalId", MDEInspRiskAssApprovalId, dbType: DbType.Int32); using (IDbConnection db = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["databaseConnection"])) { objRiskAssessor_Approval = db.Query <clsRiskAssessor_Approval>(SpName, objPar, commandType: CommandType.StoredProcedure).SingleOrDefault(); isnull = false; } } catch (Exception ex) { ErrorHandler.ErrorLogging(ex, false); ErrorHandler.ReadError(); } } if (isnull) { return(null); } else { return(objRiskAssessor_Approval); } }