public void SetExceptionLog(string api_key, ExceptionObj objParam, out int ReturnVal, out string ReturnMsg)
{
try
{
List <DBParameter> pList = new List <DBParameter>();
pList.Add(new DBParameter("studio_id", SqlDbType.BigInt, 0, ParameterDirection.Input, objParam.studio_id));
pList.Add(new DBParameter("api_key", SqlDbType.VarChar, 255, ParameterDirection.Input, api_key));
pList.Add(new DBParameter("excp_message", SqlDbType.VarChar, 50000, ParameterDirection.Input, objParam.excp_message));
pList.Add(new DBParameter("excp_source", SqlDbType.VarChar, 50000, ParameterDirection.Input, objParam.excp_source));
pList.Add(new DBParameter("target_site", SqlDbType.VarChar, 50000, ParameterDirection.Input, objParam.target_site));
pList.Add(new DBParameter("stack_trace", SqlDbType.VarChar, 50000, ParameterDirection.Input, objParam.stack_trace));
pList.Add(new DBParameter("inner_exception", SqlDbType.VarChar, 50000, ParameterDirection.Input, objParam.inner_exception));
pList.Add(new DBParameter("form_name", SqlDbType.VarChar, 1000, ParameterDirection.Input, objParam.form_name));
pList.Add(new DBParameter("page_url", SqlDbType.VarChar, 1000, ParameterDirection.Input, objParam.page_url));
pList.Add(new DBParameter("inserted_by_uid", SqlDbType.BigInt, 0, ParameterDirection.Input, objParam.inserted_by_uid));
pList.Add(new DBParameter("ReturnVal", SqlDbType.Int, 0, ParameterDirection.Output, 0));
pList.Add(new DBParameter("ReturnMsg", SqlDbType.VarChar, 50000, ParameterDirection.Output, ""));
objDAO = new DAO(_constr);
objDAO.ExecuteNonQuery("dbo.Set_EXCEPTION_LOG", DAO.QueryType.StoredProcedure, pList, out ReturnVal, out ReturnMsg);
}
catch (Exception)
{
throw;
}
}
public IActionResult Commit([FromRoute] string RegistryKey, [FromRoute] string ApiKey, [FromBody] object ParamJson)
{
IActionResult response;
CommitResponse resp = new CommitResponse();
try
{
#region Call Set_Data
string Parameters = ParamJson == null ? null : ParamJson.ToString();
RoutineDAO ObjResponseDAO = new RoutineDAO(_ConStr);
int ReturnVal;
string ReturnMsg;
string objParams = JsonConvert.SerializeObject(ParamJson);
ObjResponseDAO.SetData(RegistryKey, ApiKey, Parameters, out ReturnVal, out ReturnMsg);
if (ReturnVal == 1)
{
resp.statuscode = (int)Common.ResponseStatusCode.Success;
resp.message = "success";
response = Ok(resp);
}
else
{
resp.statuscode = (int)Common.ResponseStatusCode.SqlException;
resp.message = ReturnMsg;
response = Conflict(resp);
}
#endregion
}
catch (Exception ex)
{
Common c = new Common();
ExceptionObj exobj = c.GetExceptionObjBase(ex);
exobj.form_name = "RoutineController";
exobj.page_url = "api/Routine/Commit";
int ReturnVal;
string ReturnMsg;
ExceptionDAO exd = new ExceptionDAO(_ConStr);
exd.SetExceptionLog(ApiKey, exobj, out ReturnVal, out ReturnMsg);
resp.statuscode = (int)Common.ResponseStatusCode.Exception;
resp.message = ex.Message.ToString();
response = BadRequest(resp);
}
return(response);
}
public IActionResult SetBody([FromRoute] string ApiKey, [FromBody] SetBodyObj Param)
{
IActionResult response;
CommitResponse resp = new CommitResponse();
try
{
#region Call Set_Data
BodyDAO ObjResponseDAO = new BodyDAO(_ConStr);
string parameters = JsonConvert.SerializeObject(Param);
int ReturnVal;
string ReturnMsg;
ObjResponseDAO.SetBody(ApiKey, Param.studio_id, parameters, out ReturnVal, out ReturnMsg);
if (ReturnVal == 1)
{
resp.statuscode = (int)Common.ResponseStatusCode.Success;
resp.message = "success";
response = Ok(resp);
}
else
{
resp.statuscode = (int)Common.ResponseStatusCode.SqlException;
resp.message = ReturnMsg;
response = Conflict(resp);
}
#endregion
}
catch (Exception ex)
{
Common c = new Common();
ExceptionObj exobj = c.GetExceptionObjBase(ex);
exobj.form_name = "BodyController";
exobj.page_url = "api/Body/SetBody";
int ReturnVal;
string ReturnMsg;
ExceptionDAO exd = new ExceptionDAO(_ConStr);
exd.SetExceptionLog(ApiKey, exobj, out ReturnVal, out ReturnMsg);
resp.statuscode = (int)Common.ResponseStatusCode.Exception;
resp.message = ex.Message.ToString();
response = BadRequest(resp);
}
return(response);
}
public IActionResult FetchStudioConfig([FromRoute] string ApiKey, [FromBody] StudioConfigObj Obj)
{
IActionResult response;
StudioConfig resp = new StudioConfig();
StudioDAO ObjResponseDAO = new StudioDAO(_ConStr);
//Func<DataTable> funcGetSettings = () => ObjResponseDAO.FetchStudioConfig();
//DataTable dt = CacheHelper.Get(funcGetSettings, "SITE_SETTING", "100002", "", false);
try
{
DataSet ds = ObjResponseDAO.FetchStudioConfig(ApiKey, Obj);
Studio st = new Studio();
st.studio_id = int.Parse(ds.Tables[0].Rows[0]["studio_id"].ToString());
st.api_key = ds.Tables[0].Rows[0]["studio_id"].ToString();
st.lg_logo_name = ds.Tables[0].Rows[0]["lg_logo_name"].ToString();
st.md_logo_name = ds.Tables[0].Rows[0]["md_logo_name"].ToString();
st.sm_logo_name = ds.Tables[0].Rows[0]["sm_logo_name"].ToString();
st.fav_icon_name = ds.Tables[0].Rows[0]["fav_icon_name"].ToString();
GeneralSetting gs = new GeneralSetting();
gs.studio_id = int.Parse(ds.Tables[1].Rows[0]["studio_id"].ToString());
gs.studio_name = ds.Tables[1].Rows[0]["studio_name"].ToString();
gs.studio_title = ds.Tables[1].Rows[0]["studio_title"].ToString();
resp.statuscode = (int)Common.ResponseStatusCode.Success;
resp.message = "success";
resp.studio = st;
resp.general_setting = gs;
response = Ok(resp);
}
catch (Exception ex)
{
Common c = new Common();
ExceptionObj exobj = c.GetExceptionObjBase(ex);
exobj.form_name = "StudioController";
exobj.page_url = "api/Studio/FetchStudioConfig";
int ReturnVal;
string ReturnMsg;
ExceptionDAO exd = new ExceptionDAO(_ConStr);
exd.SetExceptionLog(ApiKey, exobj, out ReturnVal, out ReturnMsg);
resp.statuscode = (int)Common.ResponseStatusCode.Exception;
resp.message = ex.Message.ToString();
response = BadRequest(resp);
}
return(response);
}
public IActionResult GenerateNewApiToken([FromRoute] string ApiKey, [FromBody] UserObj obj)
{
IActionResult response = Unauthorized();
UserApiTokenResponse resp = new UserApiTokenResponse();
try
{
UserJwt uj = GenerateJSONWebToken();
int ReturnVal;
string ReturnMsg;
UserApiTokenObj utj = new UserApiTokenObj();
utj.user_id = obj.user_id;
utj.api_token = uj.token_String;
utj.token_expiry = uj.expiry;
SetUserApiToken(ApiKey, utj, out ReturnVal, out ReturnMsg);
if (ReturnVal == 1)
{
resp.statuscode = (int)Common.ResponseStatusCode.Success;
resp.message = "success";
resp.api_token = uj.token_String;
response = Ok(resp);
}
else
{
resp.statuscode = (int)Common.ResponseStatusCode.SqlException;
resp.message = ReturnMsg;
response = Conflict(resp);
}
}
catch (Exception ex)
{
Common c = new Common();
ExceptionObj exobj = c.GetExceptionObjBase(ex);
exobj.form_name = "AuthentcationController";
exobj.page_url = "api/Authentication/GenerateNewApiToken";
int ReturnVal;
string ReturnMsg;
ExceptionDAO exd = new ExceptionDAO(_ConStr);
exd.SetExceptionLog(ApiKey, exobj, out ReturnVal, out ReturnMsg);
resp.statuscode = (int)Common.ResponseStatusCode.Exception;
resp.message = ex.Message.ToString();
response = BadRequest(resp);
}
return(response);
}
public ExceptionObj GetExceptionObjBase(Exception ex)
{
ExceptionObj exobj = new ExceptionObj();
exobj.excp_message = ex.Message;
exobj.excp_source = ex.Source == null ? "" : ex.Source;
exobj.stack_trace = ex.StackTrace == null ? "" : ex.StackTrace;
exobj.inner_exception = ex.InnerException == null ? "" : ex.InnerException.Message;
exobj.target_site = ex.TargetSite == null ? "" : ex.TargetSite.Name;
return(exobj);
}
public IActionResult FetchLookup([FromRoute] string ApiKey, [FromBody] LookupObj Param)
{
IActionResult response;
LookupResponse resp = new LookupResponse();
try
{
#region Call Get_Data_Set
LookupDAO ObjResponseDAO = new LookupDAO(_ConStr);
DataSet ds = ObjResponseDAO.FetchLookup(ApiKey, Param);
#endregion
var lookups = (from r in ds.Tables[0].AsEnumerable()
select new Lookup()
{
lookup_id = r.Field <int>("lookup_id"),
lookup_code = r.Field <string>("lookup_code"),
lookup_description = r.Field <string>("lookup_description"),
lookup_name = r.Field <string>("lookup_name")
}).ToList();
resp.statuscode = (int)Common.ResponseStatusCode.Success;
resp.message = "success";
resp.rows = lookups;
response = Ok(resp);
}
catch (Exception ex)
{
Common c = new Common();
ExceptionObj exobj = c.GetExceptionObjBase(ex);
exobj.form_name = "BodyController";
exobj.page_url = "api/Body/List";
int ReturnVal;
string ReturnMsg;
ExceptionDAO exd = new ExceptionDAO(_ConStr);
exd.SetExceptionLog(ApiKey, exobj, out ReturnVal, out ReturnMsg);
resp.statuscode = (int)Common.ResponseStatusCode.Exception;
resp.message = ex.Message.ToString();
response = BadRequest(resp);
}
return(response);
}
public IActionResult FetchBodyList([FromRoute] string ApiKey, [FromBody] BodyListObj Param)
{
IActionResult response;
ListResponse resp = new ListResponse();
try
{
#region Call Get_Data_Set
BodyDAO ObjResponseDAO = new BodyDAO(_ConStr);
string parameters = JsonConvert.SerializeObject(Param);
DataSet ds = ObjResponseDAO.FetchBodyList(ApiKey, Param.studio_id, parameters);
#endregion
resp.statuscode = (int)Common.ResponseStatusCode.Success;
resp.message = "success";
resp.columns = Regex.Unescape(JsonConvert.SerializeObject(ds.Tables[0]).Replace(@"\", ""));
resp.rows = Regex.Unescape(JsonConvert.SerializeObject(ds.Tables[1]).Replace(@"\", ""));
response = Ok(resp);
}
catch (Exception ex)
{
Common c = new Common();
ExceptionObj exobj = c.GetExceptionObjBase(ex);
exobj.form_name = "BodyController";
exobj.page_url = "api/Body/FetchBodyList";
int ReturnVal;
string ReturnMsg;
ExceptionDAO exd = new ExceptionDAO(_ConStr);
exd.SetExceptionLog(ApiKey, exobj, out ReturnVal, out ReturnMsg);
resp.statuscode = (int)Common.ResponseStatusCode.Exception;
resp.message = ex.Message.ToString();
response = BadRequest(resp);
}
return(response);
}
public IActionResult Collection([FromRoute] string RegistryKey, [FromRoute] string ApiKey, [FromBody] object ParamJson)
{
IActionResult response;
ListResponse resp = new ListResponse();
try
{
#region Call Get_Data_Set
string Parameters = ParamJson == null ? null : ParamJson.ToString();
RoutineDAO ObjResponseDAO = new RoutineDAO(_ConStr);
DataSet ds = ObjResponseDAO.GetData(RegistryKey, ApiKey, Parameters);
#endregion
resp.statuscode = (int)Common.ResponseStatusCode.Success;
resp.message = "success";
resp.columns = Regex.Unescape(JsonConvert.SerializeObject(ds.Tables[0]).Replace(@"\", ""));
resp.rows = Regex.Unescape(JsonConvert.SerializeObject(ds.Tables[1]).Replace(@"\", ""));
response = Ok(resp);
}
catch (Exception ex)
{
Common c = new Common();
ExceptionObj exobj = c.GetExceptionObjBase(ex);
exobj.form_name = "RoutineController";
exobj.page_url = "api/Routine/Collection";
int ReturnVal;
string ReturnMsg;
ExceptionDAO exd = new ExceptionDAO(_ConStr);
exd.SetExceptionLog(ApiKey, exobj, out ReturnVal, out ReturnMsg);
resp.statuscode = (int)Common.ResponseStatusCode.Exception;
resp.message = ex.Message.ToString();
response = BadRequest(resp);
}
return(response);
}
public IActionResult AuthorizationToken([FromRoute] string ApiKey, [FromBody] LoginObj obj)
{
IActionResult response = Unauthorized();
UserAuthenticationResponse resp = new UserAuthenticationResponse();
try
{
DataSet ds;
int ReturnVal;
string ReturnMsg;
var IsAuth = AuthenticateApiCaller(ApiKey, obj, out ds, out ReturnVal, out ReturnMsg);
if (IsAuth)
{
var tokenString = "";
if (String.IsNullOrEmpty(ds.Tables[0].Rows[0]["active_api_token"].ToString()))
{
UserJwt uj = GenerateJSONWebToken();
tokenString = uj.token_String;
int ReturnVal_utj;
string ReturnMsg_utj;
UserApiTokenObj utj = new UserApiTokenObj();
utj.user_id = int.Parse(ds.Tables[0].Rows[0]["user_id"].ToString());
utj.api_token = uj.token_String;
utj.token_expiry = uj.expiry;
SetUserApiToken(ApiKey, utj, out ReturnVal_utj, out ReturnMsg_utj);
if (ReturnVal_utj != 1)
{
resp.statuscode = (int)Common.ResponseStatusCode.SqlException;
resp.message = ReturnMsg_utj;
response = Conflict(resp);
return(response);
}
}
else
{
tokenString = ds.Tables[0].Rows[0]["active_api_token"].ToString();
}
resp.statuscode = (int)Common.ResponseStatusCode.Success;
resp.message = "success";
resp.user_id = int.Parse(ds.Tables[0].Rows[0]["user_id"].ToString());
resp.studio_id = int.Parse(ds.Tables[0].Rows[0]["studio_id"].ToString());
resp.full_name = ds.Tables[0].Rows[0]["full_name"].ToString();
resp.api_key = ds.Tables[0].Rows[0]["api_key"].ToString();
resp.api_token = tokenString;
response = Ok(resp);
}
else
{
resp.statuscode = (int)Common.ResponseStatusCode.ValidationException;
resp.message = ReturnMsg;
response = Unauthorized(resp);
}
}
catch (Exception ex)
{
Common c = new Common();
ExceptionObj exobj = c.GetExceptionObjBase(ex);
exobj.form_name = "AuthentcationController";
exobj.page_url = "api/Authentication/AuthorizationToken";
int ReturnVal;
string ReturnMsg;
ExceptionDAO exd = new ExceptionDAO(_ConStr);
exd.SetExceptionLog(ApiKey, exobj, out ReturnVal, out ReturnMsg);
resp.statuscode = (int)Common.ResponseStatusCode.Exception;
resp.message = ex.Message.ToString();
response = BadRequest(resp);
}
return(response);
}
