/// <summary>
/// Delete app record
/// </summary>
/// <param name="AppId"></param>
/// <param name="StatusMsg"></param>
/// <returns></returns>
public static bool DeleteApp(int AppId, out string StatusMsg)
{
using (SqlConnection connection = DB.GetSqlConnection())
{
using (SqlCommand command = connection.CreateCommand())
{
try
{
command.CommandText = @"DeleteApplication";
command.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter parameter1 = new SqlParameter("AppId", System.Data.SqlDbType.VarChar);
parameter1.Value = AppId;
command.Parameters.Add(parameter1);
command.ExecuteNonQuery();
StatusMsg = "Successfully Deleted App";
return(true);
}
catch (SqlException ex)
{
StatusMsg = DB.DisplaySqlErrors(ex);
return(false);
}
catch (Exception e)
{
StatusMsg = e.Message;
return(false);
}
}
}
}
/// <summary>
/// Update Existing bug
/// </summary>
/// <param name="BugID">BugID</param>
/// <param name="BugSignOff">BugSignOff</param>
/// <param name="BugDate">BugDate</param>
/// <param name="BugDesc">BugDesc</param>
/// <param name="BugDetails">BugDetails</param>
/// <param name="RepSteps">RepSteps</param>
/// <param name="FixDate">FixDate</param>
/// <param name="StatusMsg">message that will return from database</param>
/// <returns></returns>
public bool UpdateBug(int BugID, int?BugSignOff, DateTime BugDate,
string BugDesc, string BugDetails, string RepSteps, DateTime?FixDate, out string StatusMsg)
{
using (SqlConnection connection = DB.GetSqlConnection())
{
using (SqlCommand command = connection.CreateCommand())
{
try
{
command.CommandText = @"UpdateBug";
command.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter parameter1 = new SqlParameter("BugId", System.Data.SqlDbType.VarChar);
parameter1.Value = BugID;
command.Parameters.Add(parameter1);
SqlParameter parameter2 = new SqlParameter("BugSignOff", System.Data.SqlDbType.Int);
parameter2.Value = ((object)BugSignOff) ?? DBNull.Value;
command.Parameters.Add(parameter2);
SqlParameter parameter3 = new SqlParameter("BugDate", System.Data.SqlDbType.DateTime);
parameter3.Value = BugDate;
command.Parameters.Add(parameter3);
SqlParameter parameter4 = new SqlParameter("BugDesc", System.Data.SqlDbType.VarChar);
parameter4.Value = BugDesc;
command.Parameters.Add(parameter4);
SqlParameter parameter5 = new SqlParameter("BugDetails", System.Data.SqlDbType.VarChar);
parameter5.Value = BugDetails;
command.Parameters.Add(parameter5);
SqlParameter parameter6 = new SqlParameter("RepSteps", System.Data.SqlDbType.VarChar);
parameter6.Value = RepSteps;
command.Parameters.Add(parameter6);
//null values might throw error?
SqlParameter parameter7 = new SqlParameter("FixDate", System.Data.SqlDbType.DateTime);
parameter7.Value = ((object)FixDate) ?? DBNull.Value;
command.Parameters.Add(parameter7);
command.ExecuteNonQuery();
StatusMsg = "Successfully updated record";
return(true);
}
catch (SqlException ex)
{
StatusMsg = DB.DisplaySqlErrors(ex);
return(false);
}
catch (Exception e)
{
StatusMsg = e.Message;
return(false);
}
}
}
}
/// <summary>
/// Add a new bug log record
/// </summary>
/// <param name="StatusCodeID">StatusCodeID</param>
/// <param name="UserID">UserID</param>
/// <param name="BugLogDesc">BugLogDesc</param>
/// <param name="BugID">BugID</param>
/// <param name="StatusMsg">message that will return from database</param>
/// <returns></returns>
public static bool AddNewBugLog(int StatusCodeID, int UserID, String BugLogDesc, int BugID, out string StatusMsg)
{
using (SqlConnection connection = DB.GetSqlConnection())
{
using (SqlCommand command = connection.CreateCommand())
{
try
{
command.CommandText = @"AddBugLog";
command.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter parameter1 = new SqlParameter("StatusCodeID", System.Data.SqlDbType.Int);
parameter1.Value = StatusCodeID;
command.Parameters.Add(parameter1);
SqlParameter parameter2 = new SqlParameter("UserID", System.Data.SqlDbType.Int);
parameter2.Value = UserID;
command.Parameters.Add(parameter2);
//used for concurrency check (manual)
SqlParameter parameter3 = new SqlParameter("BugLogDesc", System.Data.SqlDbType.VarChar, 100);
parameter3.Value = BugLogDesc;
command.Parameters.Add(parameter3);
SqlParameter parameter4 = new SqlParameter("BugID", System.Data.SqlDbType.Int);
parameter4.Value = BugID;
command.Parameters.Add(parameter4);
command.ExecuteNonQuery();
StatusMsg = "New bug successfully added";
return(true);
}
catch (SqlException ex)
{
StatusMsg = DB.DisplaySqlErrors(ex);
return(false);
}
catch (Exception e)
{
StatusMsg = e.Message;
return(false);
}
}
}
}
/// <summary>
/// update existing app
/// </summary>
/// <param name="AppId">AppId</param>
/// <param name="AppName">AppName</param>
/// <param name="AppVers">AppVers</param>
/// <param name="AppDesc">AppDesc</param>
/// <param name="StatusMsg">message that will return from database</param>
/// <returns></returns>
public bool UpdateApp(int AppId, string AppName, string AppVers, string AppDesc, out string StatusMsg)
{
using (SqlConnection connection = DB.GetSqlConnection())
{
using (SqlCommand command = connection.CreateCommand())
{
try
{
command.CommandText = @"UpdateApplication";
command.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter parameter1 = new SqlParameter("AppId", System.Data.SqlDbType.VarChar);
parameter1.Value = AppId;
command.Parameters.Add(parameter1);
SqlParameter parameter2 = new SqlParameter("AppName", System.Data.SqlDbType.VarChar);
parameter2.Value = AppName;
command.Parameters.Add(parameter2);
SqlParameter parameter3 = new SqlParameter("AppVersion", System.Data.SqlDbType.VarChar);
parameter3.Value = AppVers;
command.Parameters.Add(parameter3);
SqlParameter parameter4 = new SqlParameter("AppDesc", System.Data.SqlDbType.VarChar);
parameter4.Value = AppDesc;
command.Parameters.Add(parameter4);
command.ExecuteNonQuery();
StatusMsg = "App Successfully Updated";
return(true);
}
catch (SqlException ex)
{
StatusMsg = DB.DisplaySqlErrors(ex);
return(false);
}
catch (Exception e)
{
StatusMsg = e.Message;
return(false);
}
}
}
}
/// <summary>
/// Update existing user record
/// </summary>
/// <param name="UserID"></param>
/// <param name="UserName"></param>
/// <param name="UserEmail"></param>
/// <param name="UserTel"></param>
/// <param name="StatusMsg">message that will return from database</param>
/// <returns></returns>
public static bool UpdateUser(int UserID, string UserName, String UserEmail, String UserTel, out string StatusMsg)
{
using (SqlConnection connection = DB.GetSqlConnection())
{
using (SqlCommand command = connection.CreateCommand())
{
try
{
command.CommandText = @"UpdateUser";
command.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter parameter1 = new SqlParameter("UserID", System.Data.SqlDbType.Int);
parameter1.Value = UserID;
command.Parameters.Add(parameter1);
SqlParameter parameter2 = new SqlParameter("UserName", System.Data.SqlDbType.VarChar);
parameter2.Value = UserName;
command.Parameters.Add(parameter2);
SqlParameter parameter3 = new SqlParameter("UserEmail", System.Data.SqlDbType.VarChar);
parameter3.Value = UserEmail;
command.Parameters.Add(parameter3);
SqlParameter parameter4 = new SqlParameter("UserTel", System.Data.SqlDbType.VarChar);
parameter4.Value = UserTel;
command.Parameters.Add(parameter4);
command.ExecuteNonQuery();
StatusMsg = "User Successfully Updated";
return(true);
}
catch (SqlException ex)
{
StatusMsg = DB.DisplaySqlErrors(ex);
return(false);
}
catch (Exception e)
{
StatusMsg = e.Message;
return(false);
}
}
}
}
/// <summary>
/// Add a new Application to Database
/// </summary>
/// <param name="AppName"></param>
/// <param name="AppVersion"></param>
/// <param name="AppDesc"></param>
public static bool AddNewApp(string AppName, String AppVersion, String AppDesc, out string StatusMsg)
{
using (SqlConnection connection = DB.GetSqlConnection())
{
using (SqlCommand command = connection.CreateCommand())
{
try
{
command.CommandText = @"AddApplication";
command.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter parameter1 = new SqlParameter("AppName", System.Data.SqlDbType.VarChar);
parameter1.Value = AppName;
command.Parameters.Add(parameter1);
SqlParameter parameter2 = new SqlParameter("AppVersion", System.Data.SqlDbType.VarChar, 100);
parameter2.Value = AppVersion;
command.Parameters.Add(parameter2);
//used for concurrency check (manual)
SqlParameter parameter3 = new SqlParameter("AppDesc", System.Data.SqlDbType.VarChar, 100);
parameter3.Value = AppDesc;
command.Parameters.Add(parameter3);
command.ExecuteNonQuery();
StatusMsg = "New App Successfully added";
return(true);
}
catch (SqlException ex)
{
StatusMsg = DB.DisplaySqlErrors(ex);
return(false);
}
catch (Exception e)
{
StatusMsg = e.Message;
return(false);
}
}
}
}
/// <summary>
/// Add a new user to datbase
/// </summary>
/// <param name="UserName"></param>
/// <param name="UserEmail"></param>
/// <param name="UserTel"></param>
/// <param name="StatusMsg">message that will return from database</param>
/// <returns></returns>
public static bool AddNewUser(string UserName, String UserEmail, String UserTel, out string StatusMsg)
{
using (SqlConnection connection = DB.GetSqlConnection())
{
using (SqlCommand command = connection.CreateCommand())
{
try
{
command.CommandText = @"AddUser";
command.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter parameter1 = new SqlParameter("UserName", System.Data.SqlDbType.VarChar);
parameter1.Value = UserName;
command.Parameters.Add(parameter1);
SqlParameter parameter2 = new SqlParameter("UserEmail", System.Data.SqlDbType.VarChar, 100);
parameter2.Value = UserEmail;
command.Parameters.Add(parameter2);
//used for concurrency check (manual)
SqlParameter parameter3 = new SqlParameter("UserTel", System.Data.SqlDbType.VarChar, 12);
parameter3.Value = UserTel;
command.Parameters.Add(parameter3);
command.ExecuteNonQuery();
StatusMsg = "Successfully Added New User"; //get SQL Server Message
return(true);
}
catch (SqlException ex)
{
StatusMsg = DB.DisplaySqlErrors(ex);
return(false);
}
catch (Exception e)
{
StatusMsg = e.Message;
return(false);
}
}
}
}
/// <summary>
/// Get a selected app by Id
/// </summary>
/// <param name="AppId">AppId</param>
/// <param name="StatusMsg">message that will return from database</param>
/// <returns></returns>
public static Application GetAppByID(int AppId, string StatusMsg)
{
using (SqlConnection connection = DB.GetSqlConnection())
{
using (SqlCommand command = connection.CreateCommand())
{
try
{
command.CommandText = @"GetApplicationById";
command.CommandType = System.Data.CommandType.StoredProcedure;
SqlParameter parameter1 = new SqlParameter("AppId", System.Data.SqlDbType.Int);
parameter1.Value = AppId;
command.Parameters.Add(parameter1);
SqlDataReader reader = command.ExecuteReader();
Application e = new Application();
while (reader.Read())
{
e.Load(reader);
}
return(e);
}
catch (SqlException ex)
{
StatusMsg = DB.DisplaySqlErrors(ex);
return(null);
}
catch (Exception e)
{
StatusMsg = e.Message;
return(null);
}
}
}
}
/// <summary>
/// Add a new bug record
/// </summary>
/// <param name="AppID">UserID</param>
/// <param name="UserID">UserID</param>
/// <param name="BugDesc">BugDesc</param>
/// <param name="BugDetails">BugDetails</param>
/// <param name="RepSteps">RepSteps</param>
/// <param name="StatusMsg">message that will return from database</param>
/// <returns></returns>
public static bool AddNewBug(int AppID, int UserID, string BugDesc,
String BugDetails, String RepSteps, out string StatusMsg)
{
// Assume all new bugs will be set to unassigned
using (SqlConnection connection = DB.GetSqlConnection())
{
using (SqlCommand command = connection.CreateCommand())
{
try
{
command.CommandText = @"AddBug";
command.CommandType = System.Data.CommandType.StoredProcedure;
command.Parameters.Add("@AppID", System.Data.SqlDbType.Int).Value = AppID;
command.Parameters.Add("@UserID", System.Data.SqlDbType.Int).Value = UserID;
command.Parameters.Add("@BugDesc", System.Data.SqlDbType.VarChar, 255).Value = BugDesc;
command.Parameters.Add("@BugDetails", System.Data.SqlDbType.VarChar, 1000).Value = BugDetails;
command.Parameters.Add("@RepSteps", System.Data.SqlDbType.VarChar, 1000).Value = RepSteps;
command.ExecuteNonQuery();
StatusMsg = "Successfully added bug";
return(true);
}
catch (SqlException ex)
{
StatusMsg = DB.DisplaySqlErrors(ex);
return(false);
}
catch (Exception e)
{
StatusMsg = e.Message;
return(false);
}
}
}
}