public HttpResponseMessage AssignDelRoles(CompanyRoles r)
{
SqlConnection conn = new SqlConnection();
try
{
//connect to database
// connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password";
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["EES_DB_ConnectionString"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsUpdDelCompanyRoles";
cmd.Connection = conn;
conn.Open();
SqlParameter gsa = new SqlParameter();
gsa.ParameterName = "@active";
gsa.SqlDbType = SqlDbType.Int;
gsa.Value = r.Active;
cmd.Parameters.Add(gsa);
SqlParameter gsn = new SqlParameter();
gsn.ParameterName = "@roleid";
gsn.SqlDbType = SqlDbType.Int;
gsn.Value = r.RoleId;
cmd.Parameters.Add(gsn);
SqlParameter gsab = new SqlParameter();
gsab.ParameterName = "@companyid";
gsab.SqlDbType = SqlDbType.Int;
gsab.Value = r.CompanyId;
cmd.Parameters.Add(gsab);
SqlParameter f = new SqlParameter();
f.ParameterName = "@insupdflag";
f.SqlDbType = SqlDbType.Int;
f.Value = r.insdelflag;
cmd.Parameters.Add(f);
SqlParameter gsac = new SqlParameter("@Id", SqlDbType.Int);
gsac.Value = r.Id;
gsac.SqlDbType = SqlDbType.Int;
cmd.Parameters.Add(gsac);
cmd.ExecuteScalar();
conn.Close();
//Logger.Trace(LogCategory.WebApp, "InsUpdDelCompanyRoles stored procedure is successfully exeucted", LogLevel.Information, null);
return(new HttpResponseMessage(HttpStatusCode.OK));
}
catch (Exception ex)
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
string str = ex.Message;
//Logger.Error(ex, LogCategory.WebApp, "An error occured in saveAssignDelRoles() procedure", LogLevel.Error, null);
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex));
}
}
public HttpResponseMessage AssignDelRoles(CompanyRoles r)
{
LogTraceWriter traceWriter = new LogTraceWriter();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "saveAssignDelRoles credentials....");
SqlConnection conn = new SqlConnection();
try
{
//connect to database
// connetionString = "Data Source=ServerName;Initial Catalog=DatabaseName;User ID=UserName;Password=Password";
conn.ConnectionString = System.Configuration.ConfigurationManager.ConnectionStrings["btposdb"].ToString();
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "InsUpdDelCompanyRoles";
cmd.Connection = conn;
conn.Open();
SqlParameter gsa = new SqlParameter();
gsa.ParameterName = "@active";
gsa.SqlDbType = SqlDbType.Int;
gsa.Value = r.Active;
cmd.Parameters.Add(gsa);
SqlParameter gsn = new SqlParameter();
gsn.ParameterName = "@roleid";
gsn.SqlDbType = SqlDbType.Int;
gsn.Value = r.RoleId;
cmd.Parameters.Add(gsn);
SqlParameter gsab = new SqlParameter();
gsab.ParameterName = "@companyid";
gsab.SqlDbType = SqlDbType.Int;
gsab.Value = r.CompanyId;
cmd.Parameters.Add(gsab);
SqlParameter f = new SqlParameter();
f.ParameterName = "@insupdflag";
f.SqlDbType = SqlDbType.Int;
f.Value = r.insdelflag;
cmd.Parameters.Add(f);
SqlParameter gsac = new SqlParameter("@Id", SqlDbType.Int);
gsac.Value = r.Id;
gsac.SqlDbType = SqlDbType.Int;
cmd.Parameters.Add(gsac);
cmd.ExecuteScalar();
conn.Close();
traceWriter.Trace(Request, "0", TraceLevel.Info, "{0}", "saveAssignDelRoles Credentials completed.");
return(new HttpResponseMessage(HttpStatusCode.OK));
}
catch (Exception ex)
{
if (conn != null && conn.State == ConnectionState.Open)
{
conn.Close();
}
string str = ex.Message;
traceWriter.Trace(Request, "1", TraceLevel.Info, "{0}", "Error in saveAssignDelRoles:" + ex.Message);
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, ex));
}
}
