public static OfficerCheckResponse GetUserOfficerCheck(OfficerCheckRequest request)
{
Service client = new Service();
OfficerCheckResponse response = client.GetUserOfficerCheck(request);
return(response);
}
public static OfficerCheckResponse GetUserOfficerCheck(OfficerCheckRequest request)
{
OfficerCheckResponse response = new OfficerCheckResponse();
using (SqlConnection con = new SqlConnection(Variables.PaymentSystemDBConnection))
{
try
{
con.Open();
using (SqlCommand cmd = new SqlCommand(SQLConstants.SP_GET_USER_OFFICER_CHECK, con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@USER_CODE", request.UserCode);
cmd.Parameters.AddWithValue("@USER_PASSWORD", request.UserPassword);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = cmd;
DataTable table = new DataTable();
adapter.Fill(table);
if (table.Rows.Count > 0)
{
response.OfficerId = Convert.ToInt32(table.Rows[0]["OFFICER_ID"]);
response.UserCode = table.Rows[0]["USER_CODE"].ToString();
response.Name = table.Rows[0]["NAME"].ToString();
response.Surname = table.Rows[0]["SURNAME"].ToString();
response.InsertUser = table.Rows[0]["INSERT_USER"].ToString();
response.InsertDate = Convert.ToDateTime(table.Rows[0]["INSERT_DATE"].ToString());
response.UpdateUser = table.Rows[0]["UPDATE_USER"].ToString();
if (!String.IsNullOrEmpty(table.Rows[0]["UPDATE_DATE"].ToString()))
{
response.UpdateDate = Convert.ToDateTime(table.Rows[0]["UPDATE_DATE"].ToString());
}
}
}
}
catch (Exception ex)
{
throw;
}
}
return(response);
}
public OfficerCheckResponse GetUserOfficerCheck(OfficerCheckRequest request)
{
return(DBLayer.GetUserOfficerCheck(request));
}
