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, 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 void DeleteReleaseStatus(int releaseStatusId)
{
ReleaseStatusModel releaseStatusModel = new ReleaseStatusModel();
releaseStatusModel.Release_Status_Id = releaseStatusId;
ReleaseStatuses releaseStatuses = new ReleaseStatuses();
releaseStatuses.deleteReleaseStatus(releaseStatusModel);
}
public void GetReleaseStatusReleaseId(int releaseId)
{
ReleaseStatuses releaseStatuses = new ReleaseStatuses();
JavaScriptSerializer jss = new JavaScriptSerializer();
string output = jss.Serialize(releaseStatuses.getReleaseStatusReleaseId(releaseId));
Response.Write(output);
Response.Flush();
Response.End();
}
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();
}
