public LogCMSResponse AddPost([FromBody] LogCMSRequest LogcmsRequest, string id)
{
LogPersistance Logpersistance = new LogPersistance();
LogCMSResponse LogcmsResponse = new LogCMSResponse();
LogcmsResponse.Status = "Fail";
LogcmsResponse.Message = "Fail";
switch (id.ToUpper())
{
/*
* case "BAY":
* {
* //ret = "Hello Authorized API with ID = " + id + "__" + ODDforeGround.Status;
* ODDresponse = ODDpersistance.AddForeGroundBAY(ODDforeGround);
* }
* break;
*/
case "CMS":
{
/*
* ODDForeGroundSCB ODDforeGroundSCB = new ODDForeGroundSCB();
* ODDforeGroundSCB.Reg_ref = ODDforeGround.Reg_ref;
* ODDforeGroundSCB.Response = ODDforeGround.Response;
*/
//ret = "Hello Authorized API with ID = " + ODDforeGround.Response + "__" + ODDforeGroundSCB.Reg_ref;
//ODDresponse.Message = "Hello Authorized API with ID = " + ODDforeGround.Response + "__" + ODDforeGroundSCB.Reg_ref;
LogcmsResponse = Logpersistance.AddCMS(LogcmsRequest);
}
break;
default:
//ret = "Hello Authorized API with ID = " + id + "__" + ODDforeGround.Status;
break;
}
return(LogcmsResponse);
}
public LogCMSResponse AddCMS(LogCMSRequest LogcmsRequest)
{
/*
* OdbcConnection conn = null;
* OdbcCommand command = null;
* OdbcDataReader mySQLReader = null;
*/
SqlConnection conn = null;
SqlCommand command = null;
SqlDataReader mySQLReader = null;
LogCMSResponse LogcmsResponse = new LogCMSResponse();
LogcmsResponse.Status = "Fail";
LogcmsResponse.Message = "Error";
if (!IsValidEmail(LogcmsRequest.User_Email))
{
LogcmsResponse.Message = "Invalid email format.";
return(LogcmsResponse);
}
else if (!ValidateIPv4(LogcmsRequest.Source_IP_Address))
{
LogcmsResponse.Message = "Invalid ip address format.";
return(LogcmsResponse);
}
else if (!ValidateIPv4(LogcmsRequest.Target_IP_Address))
{
LogcmsResponse.Message = "Invalid ip address format.";
return(LogcmsResponse);
}
else if (String.IsNullOrWhiteSpace(LogcmsRequest.Login_Result))
{
LogcmsResponse.Message = "Result can't blank.";
return(LogcmsResponse);
}
else
{
try
{
string myConnectionString = ConfigurationManager.ConnectionStrings["localDB"].ConnectionString;;
//conn = new OleDbConnection(myConnectionString);
conn = new SqlConnection(myConnectionString);
conn.Open();
//command = new OleDbCommand();
command = new SqlCommand();
command.Connection = conn;
command.CommandTimeout = 0;
SqlParameter param = null;
//-------------------------------- Insert CMS Log ----------------
command.CommandType = CommandType.Text;
command.CommandText = "insert into Log_CMS_Cloud(Source_IP_Address,Target_IP_Address,User_Email,Login_Result,Dt_Gen) values(@Source_IP_Address,@Target_IP_Address,@User_Email,@Login_Result,DATEADD(HH,7,GETUTCDATE()))";
command.Parameters.Clear();
param = null;
param = new SqlParameter("@Source_IP_Address", System.Data.SqlDbType.NVarChar, 15); //nvarchar(max)
param.Value = LogcmsRequest.Source_IP_Address == null ? "" : LogcmsRequest.Source_IP_Address.Trim();
param.Direction = ParameterDirection.Input;
command.Parameters.Add(param);
param = new SqlParameter("@Target_IP_Address", System.Data.SqlDbType.NVarChar, 15); //nvarchar(max)
param.Value = LogcmsRequest.Target_IP_Address == null ? "" : LogcmsRequest.Target_IP_Address.Trim();
param.Direction = ParameterDirection.Input;
command.Parameters.Add(param);
param = new SqlParameter("@User_Email", System.Data.SqlDbType.NVarChar, 50); //nvarchar(max)
param.Value = LogcmsRequest.User_Email == null ? "" : LogcmsRequest.User_Email.Trim();
param.Direction = ParameterDirection.Input;
command.Parameters.Add(param);
param = new SqlParameter("@Login_Result", System.Data.SqlDbType.NVarChar, 15); //nvarchar(max)
param.Value = LogcmsRequest.Login_Result == null ? "" : LogcmsRequest.Login_Result.Trim();
param.Direction = ParameterDirection.Input;
command.Parameters.Add(param);
command.ExecuteNonQuery();
//------------------------------- /Insert CMS Log ----------------
LogcmsResponse.Message = "";
LogcmsResponse.Status = "Success";
return(LogcmsResponse);
}
catch (Exception ex)
{
LogcmsResponse.Message = ex.ToString();
LogcmsResponse.Status = "Fail";
return(LogcmsResponse);
}
finally
{
if (mySQLReader != null)
{
mySQLReader.Close();
}
if (conn != null)
{
conn.Close();
}
}
}
} //------------- /AddCMS