public int UpdateModuleAccess(ModuleAccess newModuleAccess, out string savingReport) { try { SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@spModuleAccessID", newModuleAccess.ModuleAccessID); param[1] = new SqlParameter("@ModuleID", newModuleAccess.ModuleID); param[2] = new SqlParameter("@UserID", newModuleAccess.UserID); param[3] = new SqlParameter("@Doneby", newModuleAccess.Doneby); param[4] = new SqlParameter("@DoneDate", newModuleAccess.DoneDate); param[5] = new SqlParameter("@Viewing", newModuleAccess.Viewing); savingReport = " Data Has been Saved."; return(clsSqlHelper.executeNonQuery_SP("sp_updateModuleAccess", param)); } catch (Exception ex) { savingReport = ex.Message; return(0); } }
public int SaveModuleAccess(ModuleAccess newModuleAccess, out string savingReport) { try { SqlParameter[] param = new SqlParameter[6]; param[0] = new SqlParameter("@ModuleAccessID", newModuleAccess.ModuleAccessID); param[1] = new SqlParameter("@ModuleID", newModuleAccess.ModuleID); param[2] = new SqlParameter("@UserID", newModuleAccess.UserID); param[3] = new SqlParameter("@Doneby", newModuleAccess.Doneby); param[4] = new SqlParameter("@DoneDate", newModuleAccess.DoneDate); param[5] = new SqlParameter("@Viewing", newModuleAccess.Viewing); savingReport = " Data Has been Saved."; clsSqlHelper.executeNonQuery_SP("sp_addModuleAccess", param); return(int.Parse(clsSqlHelper.ExecuteScalar(" select Max(ModuleAccessID) as ModuleAccessID from ModuleAccess ").ToString())); } catch (Exception ex) { savingReport = ex.Message; return(0); } }