public static SubscriberCheckResponse GetUserSubscriberCheck(SubscriberCheckRequest request)
{
Service client = new Service();
SubscriberCheckResponse response = client.GetUserSubscriberCheck(request);
return(response);
}
public static SubscriberCheckResponse GetUserSubscriberCheck(SubscriberCheckRequest request)
{
SubscriberCheckResponse response = new SubscriberCheckResponse();
using (SqlConnection con = new SqlConnection(Variables.PaymentSystemDBConnection))
{
try
{
con.Open();
using (SqlCommand cmd = new SqlCommand(SQLConstants.SP_GET_USER_SUBSCRIBER_CHECK, con))
{
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.Clear();
cmd.Parameters.AddWithValue("@IDENTIFICATION_TAX_NUMBER", request.IdentificationTaxNumber);
cmd.Parameters.AddWithValue("@USER_PASSWORD", request.UserPassword);
cmd.Parameters.AddWithValue("@SUBSCRIBER_TYPE_ID", request.SubscriberTypeId);
SqlDataAdapter adapter = new SqlDataAdapter();
adapter.SelectCommand = cmd;
DataTable table = new DataTable();
adapter.Fill(table);
if (table.Rows.Count > 0)
{
response.SubscriberId = Convert.ToInt32(table.Rows[0]["SUBSCRIBER_ID"]);
response.Name = table.Rows[0]["NAME"].ToString();
response.Surname = table.Rows[0]["SURNAME"].ToString();
response.SubscriberTypeId = Convert.ToInt32(table.Rows[0]["SUBSCRIBER_TYPE_ID"]);
response.IdentificationTaxNumber = table.Rows[0]["IDENTIFICATION_TAX_NUMBER"].ToString();
response.SubscriptionId = Convert.ToInt32(table.Rows[0]["SUBSCRIPTION_ID"]);
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 SubscriberCheckResponse GetUserSubscriberCheck(SubscriberCheckRequest request)
{
return(DBLayer.GetUserSubscriberCheck(request));
}
