public static void UpdateRequest(string email, string primaryRole, string secondaryRole = null)
{
try
{
System.Diagnostics.Debug.WriteLine(email);
System.Diagnostics.Debug.WriteLine(primaryRole);
System.Diagnostics.Debug.WriteLine(secondaryRole);
string constr = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
using (con)
{
SqlCommand sc = new SqlCommand("dbo.spEditManagement", con)
{
CommandType = CommandType.StoredProcedure
};
sc.Parameters.AddWithValue("@Action", "EDIT");
sc.Parameters.AddWithValue("@Email", email);
sc.Parameters.AddWithValue("@PrimaryRole", primaryRole);
sc.Parameters.AddWithValue("@SecondaryRole", secondaryRole);
con.Open();
sc.ExecuteNonQuery();
con.Close();
}
}
catch (Exception ex)
{
System.Web.Services.WebService wsError = new System.Web.Services.WebService();
wsError.Context.Response.StatusCode = 500;
wsError.Context.Response.AppendHeader("error", ex.Message);
}
}
public static void RejectRequests(string email)
{
try
{
System.Diagnostics.Debug.WriteLine(email);
string constr = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
SqlConnection con = new SqlConnection(constr);
using (con)
{
SqlCommand sc = new SqlCommand("dbo.spPendingRegistration", con)
{
CommandType = CommandType.StoredProcedure
};
sc.Parameters.AddWithValue("@Action", "DELETE");
sc.Parameters.AddWithValue("@Email", email);
con.Open();
sc.ExecuteNonQuery();
con.Close();
}
}
catch (Exception ex)
{
System.Web.Services.WebService wsError = new System.Web.Services.WebService();
wsError.Context.Response.StatusCode = 500;
wsError.Context.Response.AppendHeader("error", ex.Message);
}
}
