public void createReleaseStatus(ReleaseStatusModel releaseStatusModel)
{
cmd = new SqlCommand("Insert_Release_Status", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Release_Status", SqlDbType.VarChar).Value = releaseStatusModel.Release_Status;
cmd.Parameters.Add("@Day_of_Release", SqlDbType.Int).Value = releaseStatusModel.day;
cmd.Parameters.Add("@Release_Id", SqlDbType.Int).Value = releaseStatusModel.Release_Id;
cmd.Parameters.Add("@Month", SqlDbType.VarChar).Value = releaseStatusModel.Month;
cmd.Parameters.Add("@Year", SqlDbType.Int).Value = Convert.ToInt32(releaseStatusModel.Year);
cmd.Parameters.Add("@Impacts", SqlDbType.VarChar).Value = releaseStatusModel.Impacts;
cmd.Parameters.Add("@TFS_Url", SqlDbType.VarChar).Value = releaseStatusModel.TFS_Url;
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();
}
}
}
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 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 Boolean deleteReleaseStatus(ReleaseStatusModel releaseStatusModel)
{
cmd = new SqlCommand("Delete_Release_Status", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Release_Status_Id", SqlDbType.Int).Value = releaseStatusModel.Release_Status_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 Boolean updateReleaseStatus(ReleaseStatusModel releaseStatusModel)
{
cmd = new SqlCommand("Update_Release_Status", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Release_Status", SqlDbType.VarChar).Value = releaseStatusModel.Release_Status;
cmd.Parameters.Add("@Day_of_Release", SqlDbType.Int).Value = releaseStatusModel.day;
cmd.Parameters.Add("@Release_Status_Id", SqlDbType.Int).Value = releaseStatusModel.Release_Status_Id;
cmd.Parameters.Add("@Month", SqlDbType.VarChar).Value = releaseStatusModel.Month;
cmd.Parameters.Add("@Year", SqlDbType.Int).Value = Convert.ToInt32(releaseStatusModel.Year);
cmd.Parameters.Add("@Impacts", SqlDbType.VarChar).Value = releaseStatusModel.Impacts;
cmd.Parameters.Add("@TFS_Url", SqlDbType.VarChar).Value = releaseStatusModel.TFS_Url;
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 void CreateReleaseStatus(int releaseId, String status, int day, String Month, String Year, String impacts, String TFSUrl)
{
ReleaseStatusModel releaseStatusModel = new ReleaseStatusModel();
releaseStatusModel.Release_Id = releaseId;
releaseStatusModel.Release_Status = status;
releaseStatusModel.day = day;
releaseStatusModel.Month = Month;
releaseStatusModel.Year = Year;
releaseStatusModel.Impacts = impacts;
releaseStatusModel.TFS_Url = TFSUrl;
ReleaseStatuses releaseStatuses = new ReleaseStatuses();
releaseStatuses.createReleaseStatus(releaseStatusModel);
}
public void CheckDateConflict(int releaseId, int day, String month, int year)
{
ReleaseStatusModel releaseStatus = new ReleaseStatusModel();
releaseStatus.Release_Id = releaseId;
releaseStatus.day = day;
releaseStatus.Year = year + "";
releaseStatus.Month = month;
ReleaseStatuses releaseStatuses = new ReleaseStatuses();
JavaScriptSerializer jss = new JavaScriptSerializer();
string output = jss.Serialize(releaseStatuses.checkDateConflict(releaseStatus));
Response.Write(output);
Response.Flush();
Response.End();
}
public ReleaseStatusModel getReleaseStatus(ReleaseStatusModel releaseStatusModel)
{
SqlCommand command = new SqlCommand("Select_Release_Status", conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@Release_Status_Id", SqlDbType.Int).Value = releaseStatusModel.Release_Status_Id;
SqlDataReader read = null;
try
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
read = command.ExecuteReader();
while (read.Read())
{
releaseStatusModel.Release_Status_Id = Convert.ToInt32(read["Release_Status_Id"].ToString());
releaseStatusModel.Release_Status = read["Release_Status"].ToString();
releaseStatusModel.Release_Id = Convert.ToInt32(read["Release_Id"].ToString());
releaseStatusModel.day = Convert.ToInt32(read["Day_of_Release"].ToString());
releaseStatusModel.Month = read["Month"].ToString();
releaseStatusModel.Year = read["Year"].ToString();
releaseStatusModel.Impacts = read["Impacts"].ToString();
releaseStatusModel.TFS_Url = read["TFS_Url"].ToString();
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
finally
{
if (read != null && read.IsClosed == false)
{
read.Close();
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(releaseStatusModel);
}
public ReleaseStatusModel checkDateConflict(ReleaseStatusModel releaseStatus)
{
cmd = new SqlCommand("Check_Date_Conflict", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader read = null;
cmd.Parameters.Add("@Release_Id", SqlDbType.Int).Value = releaseStatus.Release_Id;
cmd.Parameters.Add("@Month", SqlDbType.VarChar).Value = releaseStatus.Month;
cmd.Parameters.Add("@Year", SqlDbType.Int).Value = Convert.ToInt32(releaseStatus.Year);
cmd.Parameters.Add("@Day_of_Release", SqlDbType.Int).Value = releaseStatus.day;
try
{
if (conn.State != ConnectionState.Open)
{
conn.Open();
}
read = cmd.ExecuteReader();
while (read.Read())
{
releaseStatus.Release_Status = read["Release_Status"].ToString();
releaseStatus.Month = read["Month"].ToString();
releaseStatus.Year = read["Year"].ToString();
releaseStatus.Release_Id = Convert.ToInt32(read["Release_Id"].ToString());
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
finally
{
if (read != null && read.IsClosed == false)
{
read.Close();
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return(releaseStatus);
}
public ReleaseStatusModel checkDateConflict(ReleaseStatusModel releaseStatus)
{
cmd = new SqlCommand("Check_Date_Conflict", conn);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader read = null;
cmd.Parameters.Add("@Release_Id", SqlDbType.Int).Value = releaseStatus.Release_Id;
cmd.Parameters.Add("@Month", SqlDbType.VarChar).Value = releaseStatus.Month;
cmd.Parameters.Add("@Year", SqlDbType.Int).Value = Convert.ToInt32(releaseStatus.Year);
cmd.Parameters.Add("@Day_of_Release", SqlDbType.Int).Value = releaseStatus.day;
try
{
if (conn.State != ConnectionState.Open)
conn.Open();
read = cmd.ExecuteReader();
while (read.Read())
{
releaseStatus.Release_Status = read["Release_Status"].ToString();
releaseStatus.Month = read["Month"].ToString();
releaseStatus.Year = read["Year"].ToString();
releaseStatus.Release_Id = Convert.ToInt32(read["Release_Id"].ToString());
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
finally
{
if (read != null && read.IsClosed == false)
{
read.Close();
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return releaseStatus;
}
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 Boolean deleteReleaseStatus(ReleaseStatusModel releaseStatusModel)
{
cmd = new SqlCommand("Delete_Release_Status", conn);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Add("@Release_Status_Id", SqlDbType.Int).Value = releaseStatusModel.Release_Status_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 DeleteReleaseStatus(int releaseStatusId)
{
ReleaseStatusModel releaseStatusModel = new ReleaseStatusModel();
releaseStatusModel.Release_Status_Id = releaseStatusId;
ReleaseStatuses releaseStatuses = new ReleaseStatuses();
releaseStatuses.deleteReleaseStatus(releaseStatusModel);
}
public ReleaseStatusModel getReleaseStatus(ReleaseStatusModel releaseStatusModel)
{
SqlCommand command = new SqlCommand("Select_Release_Status", conn);
command.CommandType = CommandType.StoredProcedure;
command.Parameters.Add("@Release_Status_Id", SqlDbType.Int).Value = releaseStatusModel.Release_Status_Id;
SqlDataReader read = null;
try
{
if (conn.State != ConnectionState.Open)
conn.Open();
read = command.ExecuteReader();
while (read.Read())
{
releaseStatusModel.Release_Status_Id = Convert.ToInt32(read["Release_Status_Id"].ToString());
releaseStatusModel.Release_Status = read["Release_Status"].ToString();
releaseStatusModel.Release_Id = Convert.ToInt32(read["Release_Id"].ToString());
releaseStatusModel.day = Convert.ToInt32(read["Day_of_Release"].ToString());
releaseStatusModel.Month = read["Month"].ToString();
releaseStatusModel.Year = read["Year"].ToString();
releaseStatusModel.Impacts = read["Impacts"].ToString();
releaseStatusModel.TFS_Url = read["TFS_Url"].ToString();
}
}
catch (SqlException ex)
{
Console.WriteLine(ex.Message);
}
finally
{
if(read != null && read.IsClosed == false){
read.Close();
}
if (conn.State == ConnectionState.Open)
{
conn.Close();
}
}
return releaseStatusModel;
}
public void GetReleaseStatus(int releaseStatusId)
{
ReleaseStatusModel releaseStatusModel = new ReleaseStatusModel();
releaseStatusModel.Release_Status_Id = releaseStatusId;
ReleaseStatuses releaseStatuses = new ReleaseStatuses();
JavaScriptSerializer jss = new JavaScriptSerializer();
string output = jss.Serialize(releaseStatuses.getReleaseStatus(releaseStatusModel));
Response.Write(output);
Response.Flush();
Response.End();
}
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;
}
