public override int UpdateUnivesityCategoryDetails(BO.UniversityCategoryProperty objUniversityCategory, int modifiedBy, out string errmsg) { _objDataWrapper = new DbWrapper(Common.CnnString, CommandType.StoredProcedure); errmsg = ""; try { _objDataWrapper.AddParameter("@UniversityCategoryId", objUniversityCategory.UniversityCategoryId); _objDataWrapper.AddParameter("@UniversityCategoryName", objUniversityCategory.UniversityCategoryName); _objDataWrapper.AddParameter("@CreatedBy", modifiedBy); var objErrMsg = (SqlParameter)(_objDataWrapper.AddParameter("@ErrMsg", "", SqlDbType.VarChar, ParameterDirection.Output, 128)); _i = _objDataWrapper.ExecuteNonQuery("Aj_Proc_InsertUpdateUniversityCategoryDetails"); if (objErrMsg != null && objErrMsg.Value != null) { errmsg = Convert.ToString(objErrMsg.Value); } } catch (Exception ex) { var err = ex.Message; if (ex.InnerException != null) { err = err + " :: Inner Exception :- " + ex.ToString(); } const string addInfo = "Error while executing UpdateUnivesityCategoryDetails in University.cs :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } return(_i); }
// private method to bind The Object List Of The university Categoty object private List <BO.UniversityCategoryProperty> BindUniversityCategoryObject(DataTable datatable) { var objUniversityCategoryList = new List <BO.UniversityCategoryProperty>(); try { if (datatable.Rows.Count > 0) { for (var j = 0; j < datatable.Rows.Count; j++) { var objUniversityCategory = new BO.UniversityCategoryProperty { UniversityCategoryId = Convert.ToInt32(datatable.Rows[j]["AjUniversityCategoryId"]), UniversityCategoryName = Convert.ToString(datatable.Rows[j]["AjUniversityCategoryName"]) }; objUniversityCategoryList.Add(objUniversityCategory); } } } catch (Exception ex) { var err = ex.Message; if (ex.InnerException != null) { err = err + " :: Inner Exception :- " + ex.ToString(); } const string addInfo = "Error while executing BindUniversityCategoryObject in University.cs :: -> "; var objPub = new ClsExceptionPublisher(); objPub.Publish(err, addInfo); } return(objUniversityCategoryList); }
public abstract int UpdateUnivesityCategoryDetails(BO.UniversityCategoryProperty objUniversityCategory, int modifiedBy, out string errmsg);
public abstract int InsertUniversityCategoryDetails(BO.UniversityCategoryProperty objUniversityCategory, int createdBy, out string errmsg);