public IEnumerable <CreditCard> GetAllCards()
{
using (SQLDataContext data = new SQLDataContext())
{
List <CreditCard> list = (from i in data.CreditCard select i).ToList();
return(list);
}
}
public void UpdateCardType(string CardNumber, string CardType)
{
using (SQLDataContext data = new SQLDataContext())
{
CreditCard old = data.CreditCard.SingleOrDefault(i => i.CardNumber == CardNumber);
old.CardType = CardType;
data.SubmitChanges();
}
}
public object GetCard(string CardNumber)
{
using (SQLDataContext data = new SQLDataContext())
{
Object card = (from i in data.CreditCard
where i.CardNumber == CardNumber
select i).FirstOrDefault();
return(card);
}
}
private void frmIncidentAssignment_Load(object sender, EventArgs e)
{
SQLDataContext.SetConnectionString(ConfigurationManager.
ConnectionStrings["SportsPro.Properties.Settings.TechSupportConnectionString"].
ConnectionString);
techSupport = SQLDataContext.GetTechSupportDataContext();
InitializeUI();
}
private void frmCustomerIncidents_Load(object sender, EventArgs e)
{
SQLDataContext.SetConnectionString(ConfigurationManager.
ConnectionStrings["SportsPro.Properties.Settings.TechSupportConnectionString"].
ConnectionString);
techSupport = SQLDataContext.GetTechSupportDataContext();
LoadCustomerList();
nameComboBox.SelectedIndex = 0;
}
private void frmUnassignedIncidents_Load(object sender, EventArgs e)
{
SQLDataContext.SetConnectionString(ConfigurationManager.
ConnectionStrings["SportsPro.Properties.Settings.TechSupportConnectionString"].
ConnectionString);
techSupport = SQLDataContext.GetTechSupportDataContext();
LoadUnassignedIncidents();
//set up currency control
cm = (CurrencyManager)sQLIncidentDataGridView.BindingContext[incidentList];
}
public void UpdateCardExpDate(string CardNumber, int ExpMonth, int ExpYear)
{
byte value = Convert.ToByte(ExpMonth);
short shortExpYear = Convert.ToInt16(ExpYear);
using (SQLDataContext data = new SQLDataContext())
{
var old = data.CreditCard.SingleOrDefault(i => i.CardNumber == CardNumber);
old.ExpMonth = value;
old.ExpYear = shortExpYear;
data.SubmitChanges();
}
}
public void DeleteCard(String CardNumber)
{
using (SQLDataContext data = new SQLDataContext())
{
CreditCard creCard = data.CreditCard.SingleOrDefault(i => i.CardNumber == CardNumber);
if (creCard != null)
{
data.CreditCard.DeleteOnSubmit(creCard);
data.SubmitChanges();
}
}
}
public void AddCard(string CardType, string CardNumber, int ExpMonth, int ExpYear, DateTime modifiedDate)
{
byte value = Convert.ToByte(ExpMonth);
short shortExpYear = Convert.ToInt16(ExpYear);
using (SQLDataContext data = new SQLDataContext())
{
CreditCard creditCard = new CreditCard();
creditCard.CardType = CardType;
creditCard.CardNumber = CardNumber;
creditCard.ExpMonth = value;
creditCard.ExpYear = shortExpYear;
creditCard.ModifiedDate = modifiedDate;
data.CreditCard.InsertOnSubmit(creditCard);
data.SubmitChanges();
}
}
public override void Create(string filename)
{
base.Create(filename);
DataContext = new SQLDataContext(@"VAIO\SqlExpress", "prime");
}
public SQLController(SQLDataContext sqlDataContext)
{
_sqlDataContext = sqlDataContext;
}
