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)); }