// public string GetClientIdFromInt(string clientInt)
// {
// string result = clientInt.ToString(CultureInfo.InvariantCulture);
// if (result.Length == 1)
// {
// result = "00" + result;
// }
// else if (result.Length == 2)
// {
// result = Options.OptionsInstance().UsualClient + result;
// }
// return result;
// }
public void CreateNewClient(string clientId, string name, string email, DateTime birthday, string phone,
string activationdate, double personalDiscount, double playedSum)
{
// string clientID = GetClientIdFromInt(clientId);
if (CheckClientIdOnRepeat(clientId))
{
var c = new client_info_t
{
client_id = clientId,
activation_date = DateTime.Parse(activationdate),
email = email,
birthday = birthday,
name = name,
pers_discount = personalDiscount,
phone = phone,
played_sum = playedSum
};
DataBaseClass.Instancedb().AddNewClient(c);
MessageBox.Show(@"Succesfully created!");
}
else
{
MessageBox.Show(@"This id is already created, choose another one!");
}
}
partial void Deleteclient_info_t(client_info_t instance);
partial void Updateclient_info_t(client_info_t instance);
partial void Insertclient_info_t(client_info_t instance);
public void UpdateClientInfo(client_info_t cInfo)
{
var db = new dbDataContext();
lock (db)
{
for (int i = 0; i < 5; i++)
{
try
{
var matchedRecord = (from c in db.GetTable<client_info_t>()
where c.client_id == cInfo.client_id
select c).SingleOrDefault();
if (matchedRecord != null)
{
matchedRecord.name = cInfo.name;
matchedRecord.birthday = cInfo.birthday;
matchedRecord.email = cInfo.email;
matchedRecord.phone = cInfo.phone;
}
db.SubmitChanges();
break;
}
catch (Exception)
{
if (i <= 0)
{
MessageBox.Show(ErrorsAndWarningsMessages.ErrorsAndWarningsInstance()
.GetErrorWithLine(1, 88));
}
}
}
}
}
public void AddNewClient(client_info_t clientInfo)
{
var db = new dbDataContext();
lock (db)
{
Table<client_info_t> personalInfoTable = db.GetTable<client_info_t>();
client_info_t user = clientInfo;
personalInfoTable.InsertOnSubmit(user);
db.SubmitChanges();
AddNewSaVingsForClient(user.client_id);
}
}