public static Boolean InsertUpdateLK_TP_Instructor(clsLK_TP_Instructor objLK_TP_Instructor) { bool isAdded = false; string SpName = "usp_InsertUpdateLK_TP_Instructor"; try { using (IDbConnection db = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["databaseConnection"])) { db.Execute(SpName, objLK_TP_Instructor, commandType: CommandType.StoredProcedure); } isAdded = true; } catch (Exception ex) { ErrorHandler.ErrorLogging(ex, false); ErrorHandler.ReadError(); } return(isAdded); }
public static clsLK_TP_Instructor SelectLK_TP_InstructorById(int?TP_InstructorsId) { clsLK_TP_Instructor objLK_TP_Instructor = new clsLK_TP_Instructor(); bool isnull = true; string SpName = "usp_SelectLK_TP_Instructor"; var objPar = new DynamicParameters(); if (String.IsNullOrEmpty(TP_InstructorsId.ToString())) { throw new ArgumentException("Function parameters cannot be blank!"); } else { try { objPar.Add("@TP_InstructorsId", TP_InstructorsId, dbType: DbType.Int32); using (IDbConnection db = new SqlConnection(System.Configuration.ConfigurationManager.AppSettings["databaseConnection"])) { objLK_TP_Instructor = db.Query <clsLK_TP_Instructor>(SpName, objPar, commandType: CommandType.StoredProcedure).SingleOrDefault(); isnull = false; } } catch (Exception ex) { ErrorHandler.ErrorLogging(ex, false); ErrorHandler.ReadError(); } } if (isnull) { return(null); } else { return(objLK_TP_Instructor); } }