public ReleaseModel updateRelease(ReleaseModel releaseModel) { cmd = new SqlCommand("Update_Release", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Release_Id", SqlDbType.Int).Value = releaseModel.Release_Id; cmd.Parameters.Add("@Release_Name", SqlDbType.VarChar).Value = releaseModel.Release_Name; cmd.Parameters.Add("@Application_Id", SqlDbType.Int).Value = releaseModel.Application_Id; try { if (conn.State != ConnectionState.Open) { conn.Open(); } cmd.ExecuteNonQuery(); } catch (SqlException ex) { Console.WriteLine(ex.Message); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } return(releaseModel); }
public Boolean deleteRelease(ReleaseModel releaseModel) { cmd = new SqlCommand("Delete_Release", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Release_Id", SqlDbType.Int).Value = releaseModel.Release_Id; Boolean status = false; try { if (conn.State != ConnectionState.Open) { conn.Open(); } status = cmd.ExecuteNonQuery() == 1; } catch (SqlException ex) { Console.WriteLine(ex.Message); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } return(status); }
public void createRelease(ReleaseModel releaseModel, ReleaseStatusModel releaseStatusModel) { cmd = new SqlCommand("Insert_Release", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Release_Name", SqlDbType.VarChar).Value = releaseModel.Release_Name; cmd.Parameters.Add("@Application_Id", SqlDbType.Int).Value = releaseModel.Application_Id; try { if (conn.State != ConnectionState.Open) { conn.Open(); } if (cmd.ExecuteNonQuery() != 0) { releaseModel = getReleaseModel(); if (releaseModel != null) { ReleaseStatuses releaseStatuses = new ReleaseStatuses(); releaseStatusModel.Release_Id = releaseModel.Release_Id; releaseStatuses.createReleaseStatus(releaseStatusModel); } } } catch (SqlException ex) { Console.WriteLine(ex.Message); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } }
public Boolean deleteRelease(ReleaseModel releaseModel) { cmd = new SqlCommand("Delete_Release", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Release_Id", SqlDbType.Int).Value = releaseModel.Release_Id; Boolean status = false; try { if (conn.State != ConnectionState.Open) conn.Open(); status = cmd.ExecuteNonQuery() == 1; } catch (SqlException ex) { Console.WriteLine(ex.Message); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } return status; }
public void CreateRelease() { ReleaseModel releaseModel = new ReleaseModel(); ReleaseStatusModel releaseStatusModel = new ReleaseStatusModel(); String releaseName = Request.Params["releaseName"]; String month = Request.Params["month"]; String year = Request.Params["year"]; String appName = Request.Params["applicationName"]; int day = Convert.ToInt32(Request.Params["day"]); String releaseStatus = Request.Params["releaseStatus"]; String Impacts = Request.Params["Impacts"]; String TFS_Url = Request.Params["TFS_Url"]; if (releaseName != null && month != null && year != null && appName != null) { releaseModel.Release_Name = releaseName; releaseModel.Application_Id = Convert.ToInt32(appName); Releases releases = new Releases(); releaseStatusModel.Month = month; releaseStatusModel.Year = year; releaseStatusModel.day = day; releaseStatusModel.Release_Status = releaseStatus; releaseStatusModel.Impacts = Impacts; releaseStatusModel.TFS_Url = TFS_Url; releases.createRelease(releaseModel, releaseStatusModel); Response.Write(releaseName + month + year + appName); } }
public void createRelease(ReleaseModel releaseModel, ReleaseStatusModel releaseStatusModel) { cmd = new SqlCommand("Insert_Release", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Release_Name", SqlDbType.VarChar).Value = releaseModel.Release_Name; cmd.Parameters.Add("@Application_Id", SqlDbType.Int).Value = releaseModel.Application_Id; try { if (conn.State != ConnectionState.Open) conn.Open(); if (cmd.ExecuteNonQuery() != 0) { releaseModel = getReleaseModel(); if (releaseModel != null) { ReleaseStatuses releaseStatuses = new ReleaseStatuses(); releaseStatusModel.Release_Id = releaseModel.Release_Id; releaseStatuses.createReleaseStatus(releaseStatusModel); } } } catch (SqlException ex) { Console.WriteLine(ex.Message); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } }
public ReleaseModel getReleaseModel() { cmd = new SqlCommand("Select_Release", conn); cmd.CommandType = CommandType.StoredProcedure; ReleaseModel releaseModel = new ReleaseModel(); SqlDataReader reader = null; try { if (conn.State != ConnectionState.Open) { conn.Open(); } reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { releaseModel.Release_Name = reader["Release_Name"].ToString(); releaseModel.Release_Id = Convert.ToInt32(reader["Release_Id"].ToString()); releaseModel.Application_Id = Convert.ToInt32(reader["Application_Id"]); } } } catch (SqlException ex) { Console.WriteLine(ex.Message); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } return(releaseModel); }
public List <ApplicationModel> searchReleases(int applicationId, int allReleases) { List <ApplicationModel> applicationsList = new List <ApplicationModel>(); List <ApplicationModel> applicationsList2 = new List <ApplicationModel>(); ApplicationModel appModel = new ApplicationModel(); appModel.Application_Id = 200001; appModel.Application_Name = "A - Amgen VirMedica"; applicationsList.Add(appModel); appModel = new ApplicationModel(); appModel.Application_Id = 200002; appModel.Application_Name = "A - Novartis"; applicationsList.Add(appModel); appModel = new ApplicationModel(); appModel.Application_Id = 200003; appModel.Application_Name = "A - Clinical PPRP"; applicationsList.Add(appModel); appModel = new ApplicationModel(); appModel.Application_Id = 200004; appModel.Application_Name = "A - Genzyme"; applicationsList.Add(appModel); appModel = new ApplicationModel(); appModel.Application_Id = 200005; appModel.Application_Name = "A - PANF Portal"; applicationsList.Add(appModel); appModel = new ApplicationModel(); appModel.Application_Id = 200006; appModel.Application_Name = "A - eBR"; applicationsList.Add(appModel); appModel = new ApplicationModel(); appModel.Application_Id = 200007; appModel.Application_Name = "A - RxRescue"; applicationsList.Add(appModel); appModel = new ApplicationModel(); appModel.Application_Id = 200008; appModel.Application_Name = "A - Provider Portal"; applicationsList.Add(appModel); appModel = new ApplicationModel(); appModel.Application_Id = 200009; appModel.Application_Name = "A - Reporting Portal"; applicationsList.Add(appModel); appModel = new ApplicationModel(); appModel.Application_Id = 200010; appModel.Application_Name = "A - Web Configuration Tool"; applicationsList.Add(appModel); appModel = new ApplicationModel(); appModel.Application_Id = 200011; appModel.Application_Name = "A - Site Locator"; applicationsList.Add(appModel); appModel = new ApplicationModel(); appModel.Application_Id = 200012; appModel.Application_Name = "A - Patient Plus"; applicationsList.Add(appModel); Boolean flag = false; // List<ReleaseModel> allReleasesList = new List<ReleaseModel>(); if (conn.State != ConnectionState.Open) { conn.Open(); } foreach (ApplicationModel applicationModel in applicationsList) { if (applicationModel.Application_Id == applicationId || allReleases != 0) { ApplicationModel appMod = new ApplicationModel(); appMod.Application_Id = applicationModel.Application_Id; appMod.Application_Name = applicationModel.Application_Name; cmd = new SqlCommand("Select_Release_Application", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Application_Id", SqlDbType.Int).Value = applicationModel.Application_Id; cmd.Parameters.Add("@All_Releases", SqlDbType.Int).Value = applicationModel.Application_Id; SqlDataReader reader = null; SqlDataReader read = null; try { read = null; reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { ReleaseModel releaseModel = new ReleaseModel(); releaseModel.Application_Id = Convert.ToInt32(reader["Application_Id"].ToString()); releaseModel.Release_Name = reader["Release_Name"].ToString(); releaseModel.Release_Id = Convert.ToInt32(reader["Release_Id"]); SqlCommand command = new SqlCommand("Search_All_Release_Statuses_Release_Id", conn); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@Release_Id", SqlDbType.Int).Value = releaseModel.Release_Id; try { read = null; read = command.ExecuteReader(); if (read.HasRows) { while (read.Read()) { flag = true; ReleaseStatusModel releaseStatus = new ReleaseStatusModel(); releaseStatus.Release_Status_Id = Convert.ToInt32(read["Release_Status_Id"].ToString()); releaseStatus.Release_Status = read["Release_Status"].ToString(); releaseStatus.Release_Id = Convert.ToInt32(read["Release_Id"].ToString()); releaseStatus.day = Convert.ToInt32(read["Day_of_Release"].ToString()); releaseStatus.Month = read["Month"].ToString(); releaseStatus.Year = read["Year"].ToString(); releaseStatus.Impacts = read["Impacts"].ToString(); releaseStatus.TFS_Url = read["TFS_Url"].ToString(); releaseModel.releaseStatuses.Add(releaseStatus); } } } catch (SqlException ex) { Console.WriteLine(ex.Message); } appMod.releasesList.Add(releaseModel); } } } catch (SqlException ex) { Console.WriteLine(ex.Message); } finally { if (read != null && read.IsClosed == false) { read.Close(); } if (reader != null && reader.IsClosed == false) { reader.Close(); } } if (flag) { applicationsList2.Add(appMod); flag = false; } } } if (conn.State == ConnectionState.Open) { conn.Close(); } return(applicationsList2); }
//public JsonResult GetRelease(int releaseId) //{ // ReleaseModel releaseModel = new ReleaseModel(); // Releases releases = new Releases(); // return Json(releases.getReleaseModel(releaseModel)); //} public void DeleteRelease(int releaseId) { ReleaseModel releaseModel = new ReleaseModel(); releaseModel.Release_Id = releaseId; Releases releases = new Releases(); releases.deleteRelease(releaseModel); }
public void UpdateRelease(String releaseName, String month, int year, int applicationId, int releaseId) { ReleaseModel releaseModel = new ReleaseModel(); releaseModel.Application_Id = applicationId; releaseModel.Release_Name = releaseName; releaseModel.Release_Id = releaseId; Releases releases = new Releases(); releases.updateRelease(releaseModel); }
public List<ApplicationModel> getAllReleaseModels(String month, int year) { List<ApplicationModel> applicationsList = new List<ApplicationModel>(); List<ApplicationModel> applicationsList2 = new List<ApplicationModel>(); ApplicationModel appModel = new ApplicationModel(); appModel.Application_Id = 200001; appModel.Application_Name = "A - Amgen VirMedica"; applicationsList.Add(appModel); appModel = new ApplicationModel(); appModel.Application_Id = 200002; appModel.Application_Name = "A - Novartis"; applicationsList.Add(appModel); appModel = new ApplicationModel(); appModel.Application_Id = 200003; appModel.Application_Name = "A - Clinical PPRP"; applicationsList.Add(appModel); appModel = new ApplicationModel(); appModel.Application_Id = 200004; appModel.Application_Name = "A - Genzyme"; applicationsList.Add(appModel); appModel = new ApplicationModel(); appModel.Application_Id = 200005; appModel.Application_Name = "A - PANF Portal"; applicationsList.Add(appModel); appModel = new ApplicationModel(); appModel.Application_Id = 200006; appModel.Application_Name = "A - eBR"; applicationsList.Add(appModel); appModel = new ApplicationModel(); appModel.Application_Id = 200007; appModel.Application_Name = "A - RxRescue"; applicationsList.Add(appModel); appModel = new ApplicationModel(); appModel.Application_Id = 200008; appModel.Application_Name = "A - Provider Portal"; applicationsList.Add(appModel); appModel = new ApplicationModel(); appModel.Application_Id = 200009; appModel.Application_Name = "A - Reporting Portal"; applicationsList.Add(appModel); appModel = new ApplicationModel(); appModel.Application_Id = 200010; appModel.Application_Name = "A - Web Configuration Tool"; applicationsList.Add(appModel); appModel = new ApplicationModel(); appModel.Application_Id = 200011; appModel.Application_Name = "A - Site Locator"; applicationsList.Add(appModel); appModel = new ApplicationModel(); appModel.Application_Id = 200012; appModel.Application_Name = "A - Patient Plus"; applicationsList.Add(appModel); Boolean flag = false; if (conn.State != ConnectionState.Open) conn.Open(); // List<ReleaseModel> allReleasesList = new List<ReleaseModel>(); foreach (ApplicationModel applicationModel in applicationsList) { ApplicationModel appMod = new ApplicationModel(); appMod.Application_Id = applicationModel.Application_Id; appMod.Application_Name = applicationModel.Application_Name; cmd = new SqlCommand("Select_All_Releases_Month_Year", conn); cmd.Parameters.Clear(); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Application_Id", SqlDbType.Int).Value = applicationModel.Application_Id; SqlDataReader reader = null; SqlDataReader read = null; try { reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { ReleaseModel releaseModel = new ReleaseModel(); releaseModel.Application_Id = Convert.ToInt32(reader["Application_Id"].ToString()); releaseModel.Release_Name = reader["Release_Name"].ToString(); releaseModel.Release_Id = Convert.ToInt32(reader["Release_Id"]); SqlCommand command = new SqlCommand("Select_All_Release_Statuses_Release_Id", conn); command.CommandType = CommandType.StoredProcedure; command.Parameters.Add("@Release_Id", SqlDbType.Int).Value = releaseModel.Release_Id; command.Parameters.Add("@Month", SqlDbType.VarChar).Value = month; command.Parameters.Add("@Year", SqlDbType.VarChar).Value = year + ""; try { read = command.ExecuteReader(); if (read.HasRows) { while (read.Read()) { flag = true; ReleaseStatusModel releaseStatus = new ReleaseStatusModel(); releaseStatus.Release_Status_Id = Convert.ToInt32(read["Release_Status_Id"].ToString()); releaseStatus.Release_Status = read["Release_Status"].ToString(); releaseStatus.Release_Id = Convert.ToInt32(read["Release_Id"].ToString()); releaseStatus.day = Convert.ToInt32(read["Day_of_Release"].ToString()); releaseStatus.Month = read["Month"].ToString(); releaseStatus.Year = read["Year"].ToString(); releaseModel.releaseStatuses.Add(releaseStatus); } } } catch (SqlException ex) { Console.WriteLine(ex.Message); } appMod.releasesList.Add(releaseModel); } } } catch (SqlException ex) { Console.WriteLine(ex.Message); } finally { if (read != null && read.IsClosed == false) { read.Close(); } if (reader != null && reader.IsClosed == false) { reader.Close(); } } if (flag) { applicationsList2.Add(appMod); flag = false; } } if (conn.State == ConnectionState.Open) { conn.Close(); } return applicationsList2; }
public ReleaseModel updateRelease(ReleaseModel releaseModel) { cmd = new SqlCommand("Update_Release", conn); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Release_Id", SqlDbType.Int).Value = releaseModel.Release_Id; cmd.Parameters.Add("@Release_Name", SqlDbType.VarChar).Value = releaseModel.Release_Name; cmd.Parameters.Add("@Application_Id", SqlDbType.Int).Value = releaseModel.Application_Id; try { if (conn.State != ConnectionState.Open) conn.Open(); cmd.ExecuteNonQuery(); } catch (SqlException ex) { Console.WriteLine(ex.Message); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } return releaseModel; }
public ReleaseModel getReleaseModel() { cmd = new SqlCommand("Select_Release", conn); cmd.CommandType = CommandType.StoredProcedure; ReleaseModel releaseModel = new ReleaseModel(); SqlDataReader reader = null; try { if (conn.State != ConnectionState.Open) conn.Open(); reader = cmd.ExecuteReader(); if (reader.HasRows) { while (reader.Read()) { releaseModel.Release_Name = reader["Release_Name"].ToString(); releaseModel.Release_Id = Convert.ToInt32(reader["Release_Id"].ToString()); releaseModel.Application_Id = Convert.ToInt32(reader["Application_Id"]); } } } catch (SqlException ex) { Console.WriteLine(ex.Message); } finally { if (conn.State == ConnectionState.Open) { conn.Close(); } } return releaseModel; }