internal Credit_Cards Get_Credit_Card_Details_By_Credit_Card_Id(
int p_Credit_Card_Id,
int p_User_Id_Credit_Card_Owner,
int p_User_Id_Searching_For_Credit_Card
)
{
Credit_Cards Credit_Card_To_Return = new Credit_Cards();
SqlParameter spCredit_Card_Id = new SqlParameter("@Credit_Card_Id", SqlDbType.Int);
SqlParameter spUser_Id = new SqlParameter("@User_Id", SqlDbType.Int);
SqlParameter spUser_Id_Searching_For_Credit_Card = new SqlParameter("@User_Id_Searching_For_Credit_Card", SqlDbType.Int);
spCredit_Card_Id.Value = p_Credit_Card_Id;
spUser_Id.Value = p_User_Id_Credit_Card_Owner;
spUser_Id_Searching_For_Credit_Card.Value = p_User_Id_Searching_For_Credit_Card;
var dataSet = SQLHelper.SelectUsingStoredProcedure_WithDefaultAppConfigConnectionString("p_TLBoard_Get_Credit_Card_Details",
new List <SqlParameter>()
{
spCredit_Card_Id, spUser_Id, spUser_Id_Searching_For_Credit_Card
});
if (dataSet != null && dataSet.Tables[0].Rows.Count > 0)
{
Credit_Card_To_Return = Create_Credit_Card_Details_From_Data_Row(dataSet.Tables[0].Rows[0]);
}
return(Credit_Card_To_Return);
}
internal Credit_Cards Insert_New_Credit_Card_Details(
int p_User_Id_Owner,
int p_Bank_Account_Id,
string p_Card_Name,
string p_Four_Ending_Digits,
DateTime?p_Expiration_Date,
bool p_Is_Active,
int p_Creating_User_Id)
{
Credit_Cards new_Registered_Credit_Card_To_Return = null;
SqlParameter spBank_Account_Id = new SqlParameter("@Bank_Account_Id", SqlDbType.Int);
SqlParameter spUser_Id_Owner = new SqlParameter("@User_Id_Owner", SqlDbType.Int);
SqlParameter spCard_Name = new SqlParameter("@Card_Name", SqlDbType.NVarChar, 40);
SqlParameter spFour_Ending_Digits = new SqlParameter("@Four_Ending_Digits", SqlDbType.NVarChar, 4);
SqlParameter spExpiration_Date = new SqlParameter("@Expiration_Date", SqlDbType.SmallDateTime);
SqlParameter spIs_Active = new SqlParameter("@Is_Active", SqlDbType.Bit);
SqlParameter spCreating_User_Id = new SqlParameter("@Creating_User_Id", SqlDbType.Int);
spBank_Account_Id.Value = p_Bank_Account_Id;
spUser_Id_Owner.Value = p_User_Id_Owner;
spCard_Name.Value = p_Card_Name;
spFour_Ending_Digits.Value = p_Four_Ending_Digits;
if (p_Expiration_Date.HasValue)
{
spExpiration_Date.Value = p_Expiration_Date;
}
else
{
spExpiration_Date.Value = DBNull.Value;
}
spIs_Active.Value = p_Is_Active;
spCreating_User_Id.Value = p_Creating_User_Id;
object new_Credit_Card_Id = SQLHelper.ExecuteStoredProcedure_ReturnDataObjectResult("p_TLBoard_Insert_Credit_Card_Details",
new List <SqlParameter>()
{
spBank_Account_Id,
spUser_Id_Owner,
spCard_Name,
spFour_Ending_Digits,
spExpiration_Date,
spIs_Active,
spCreating_User_Id
});
if (new_Credit_Card_Id != null)
{
int Credit_Card_Id_Registered = Convert.ToInt32(new_Credit_Card_Id);
if (Credit_Card_Id_Registered > 0)
{
new_Registered_Credit_Card_To_Return = Get_Credit_Card_Details_By_Credit_Card_Id(
Credit_Card_Id_Registered, p_User_Id_Owner, p_Creating_User_Id);
}
}
return(new_Registered_Credit_Card_To_Return);
}
private Credit_Cards Create_Credit_Card_Details_From_Data_Row(DataRow dbRow)
{
Credit_Cards Credit_Card_To_Return = new Credit_Cards();
Credit_Card_To_Return.Credit_Card_Id = Convert.ToInt32(dbRow["Credit_Card_Id"]);
Credit_Card_To_Return.Bank_Account_Id = Convert.ToInt32(dbRow["Bank_Account_Id"]);
if (dbRow.Table.Columns.IndexOf("Bank_Account_Name") > -1 &&
dbRow["Bank_Account_Name"] != DBNull.Value)
{
Credit_Card_To_Return.Bank_Account_Name = dbRow["Bank_Account_Name"].ToString();
}
Credit_Card_To_Return.User_Id = Convert.ToInt32(dbRow["User_Id"]);
Credit_Card_To_Return.Card_Name = dbRow["Card_Name"].ToString();
Credit_Card_To_Return.Four_Ending_Digits = dbRow["Four_Ending_Digits"].ToString();
if (dbRow["Expiration_Date"] != DBNull.Value)
{
Credit_Card_To_Return.Expiration_Date = (DateTime)dbRow["Expiration_Date"];
}
Credit_Card_To_Return.Is_Active = (bool)dbRow["Is_Active"];
if (dbRow.Table.Columns.IndexOf("Record_Creation_DateTime_UTC") > -1)
{
Credit_Card_To_Return.Record_Created_By_User_Id = Convert.ToInt32(dbRow["Record_Created_By_User_Id"]);
Credit_Card_To_Return.Record_Created_By_User_Details = new Users();
Credit_Card_To_Return.Record_Created_By_User_Details.User_Id = Credit_Card_To_Return.Record_Created_By_User_Id;
if (dbRow.Table.Columns.IndexOf("Created_By_First_Name") > -1)
{
Credit_Card_To_Return.Record_Created_By_User_Details.First_Name = dbRow["Created_By_First_Name"].ToString();
Credit_Card_To_Return.Record_Created_By_User_Details.Last_Name = dbRow["Created_By_Last_Name"].ToString();
}
Credit_Card_To_Return.Record_Creation_DateTime_UTC = (DateTime)dbRow["Record_Creation_DateTime_UTC"];
Credit_Card_To_Return.Record_Last_Updated_By_User_Id = Convert.ToInt32(dbRow["Record_Last_Updated_By_User_Id"]);
Credit_Card_To_Return.Record_Last_Updated_By_User_Details = new Users();
Credit_Card_To_Return.Record_Last_Updated_By_User_Details.User_Id = Credit_Card_To_Return.Record_Last_Updated_By_User_Id;
if (dbRow.Table.Columns.IndexOf("Last_Updated_By_First_Name") > -1)
{
Credit_Card_To_Return.Record_Last_Updated_By_User_Details.First_Name = dbRow["Last_Updated_By_First_Name"].ToString();
Credit_Card_To_Return.Record_Last_Updated_By_User_Details.Last_Name = dbRow["Last_Updated_By_Last_Name"].ToString();
}
Credit_Card_To_Return.Record_Last_Updated_DateTime_UTC = (DateTime)dbRow["Record_Last_Updated_DateTime_UTC"];
}
Credit_Card_To_Return.Is_Deleted = (bool)dbRow["Is_Deleted"];
return(Credit_Card_To_Return);
}
private void Set_Page_FormControls_Values()
{
int credit_Card_Id = int.Parse(this.Request.QueryString["id"]);
int user_Id_Owner = base.Authenticated_User_ID;
Credit_Cards creditCardDetails = Business_Logic_Layer_Facade.Instance.CreditCards_Get_Credit_Card_Details(
credit_Card_Id,
user_Id_Owner,
base.Authenticated_User_ID,
base.Authenticated_Permission_Type);
if (creditCardDetails != null)
{
Common_Tools.Set_ComboBox_Selected_Value_And_Label_Text(
creditCardDetails.Bank_Account_Id.ToString(),
this.dropdown_Bank_Account,
this.label_Bank_Account);
this.textbox_Card_Name.Text = creditCardDetails.Card_Name;
this.label_Card_Name.Text = creditCardDetails.Card_Name;
this.textbox_Four_Ending_Digits.Text = creditCardDetails.Four_Ending_Digits;
this.label_Four_Ending_Digits.Text = creditCardDetails.Four_Ending_Digits;
if (creditCardDetails.Expiration_Date.HasValue)
{
DateTime date_Expiration_For_Display = creditCardDetails.Expiration_Date.Value.AddMonths(-1);
this.dropdown_Expiration_Date_Month.SelectedValue = date_Expiration_For_Display.Month.ToString("00");
this.dropdown_Expiration_Date_Year.SelectedValue = date_Expiration_For_Display.Year.ToString();
this.label_Expiration_Date.Text = date_Expiration_For_Display.ToString("MM / yyyy ");
}
this.checkbox_Is_Active.Checked = creditCardDetails.Is_Active;
this.label_Is_Active.Text = creditCardDetails.Is_Active ? "Yes" : "No";
this.label_Record_Created_By_User.Text = creditCardDetails.Record_Created_By_User_Details.FullName_With_Email;
this.label_Record_Creation_DateTime_UTC.Text = creditCardDetails.Record_Creation_DateTime_UTC.ToString("dd/MM/yyyy HH:mm:ss UTC");
this.label_Record_Last_Updated_By_User.Text = creditCardDetails.Record_Last_Updated_By_User_Details.FullName_With_Email.ToString();
this.label_Record_Last_Updated_DateTime_UTC.Text = creditCardDetails.Record_Last_Updated_DateTime_UTC.ToString("dd/MM/yyyy HH:mm:ss UTC");
}
}
