public Response <List <CustomerCardDetails> > ViewCustomerCard(CustomerCardDetails model, string UserId)
{
Response <List <CustomerCardDetails> > returnModel = new Response <List <CustomerCardDetails> >();
try
{
using (SqlConnection DB = new SqlConnection(SiteKey.ConnectionString))
{
returnModel.result = DB.QuerySql <CustomerCardDetails>("Select * from customer_payment_card where user_id = @user_id ", new
{
user_id = UserId
}).ToList();
returnModel.status = (int)EnumClass.ResponseState.Success;
returnModel.msg = "Card List";
returnModel.success = true;
}
return(returnModel);
}
catch (Exception ex)
{
returnModel.msg = ex.Message;
returnModel.status = (int)EnumClass.ResponseState.ResposityError;
LoggingRepository.SaveException(ex);
returnModel.success = false;
return(returnModel);
}
}
public Response <CustomerCardDetails> DeleteCustomerCard(CustomerCardDetails model)
{
Response <CustomerCardDetails> returnModel = new Response <CustomerCardDetails>();
try
{
using (SqlConnection DB = new SqlConnection(SiteKey.ConnectionString))
{
DB.ExecuteSql("delete from customer_payment_card where id = @id",
new
{ id = model.id });
returnModel.msg = "Card Delete Successfully!.";
returnModel.status = (int)EnumClass.ResponseState.Success;
returnModel.success = false;
return(returnModel);
}
}
catch (Exception ex)
{
returnModel.msg = ex.Message;
returnModel.status = (int)EnumClass.ResponseState.Failure;
returnModel.success = false;
return(returnModel);
}
}
public Response <CustomerCardDetails> InsertCustomerCard(CustomerCardDetails model, string UserId)
{
Response <CustomerCardDetails> returnModel = new Response <CustomerCardDetails>();
try
{
using (SqlConnection DB = new SqlConnection(SiteKey.ConnectionString))
{
DB.ExecuteSql("insert into customer_payment_card values(@id,@user_id,@expiry_month,@card_last_digit,@status,@created,@modified,@expiry_year,@card_ref_number) ",
new
{
id = Guid.NewGuid().ToString(),
user_id = UserId,
expiry_month = model.expiry_month,
card_last_digit = model.card_last_digit,
status = 1,
created = DateTime.Now,
modified = DateTime.Now,
expiry_year = model.expiry_year,
card_ref_number = model.card_ref_number
});
returnModel.msg = "Card Added Successfully!.";
returnModel.status = (int)EnumClass.ResponseState.Success;
returnModel.success = false;
return(returnModel);
}
}
catch (Exception ex)
{
returnModel.msg = ex.Message;
returnModel.status = (int)EnumClass.ResponseState.Failure;
returnModel.success = false;
return(returnModel);
}
}
public ActionResult DeleteCustomerCard([FromBody] CustomerCardDetails Model)
{
Response <CustomerCardDetails> Result = new UserRepository().DeleteCustomerCard(Model);
return(Ok(Result));
}
public ActionResult ViewCustomerCard(CustomerCardDetails Model)
{
Response <List <CustomerCardDetails> > Result = new UserRepository().ViewCustomerCard(Model, GetUserId());
return(Ok(Result));
}
public ActionResult CustomerCardInsert([FromBody] CustomerCardDetails Model)
{
return(Ok());
}
public ActionResult InsertCustomerCard([FromBody] CustomerCardDetails Model)
{
Response <CustomerCardDetails> Result = new UserRepository().InsertCustomerCard(Model, GetUserId());
return(Ok(Result));
}