protected void btnProceed_Click(object sender, EventArgs e)
{
db = new SMSDataClassesDataContext();
string refNo = Request.QueryString["ref"].Trim();
string winCode = txtWinCode.Text.Trim();
SMS_BayanihanSum d = new SMS_BayanihanSum();
d.bayanihan_ref = "BD" + DateTime.Now.AddDays(1).ToString("Mddyyyy");
d.played = 0;
d.donation = 0;
d.combination_no_win = "-";
d.total_win = 0;
d.total_win_amount = 0;
d.open_started = DateTime.Parse(DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") + " 01:00:00.000");
d.closing_time = DateTime.Parse(DateTime.Now.AddDays(1).ToString("yyyy-MM-dd") + " 18:00:00.000");
d.status = "Open";
sqlServer.Update("UPDATE SMS_Bayanihan SET " +
"status = 'Winner'" +
"WHERE bayanihan_ref = '" + refNo + "' AND combination = '" + winCode + "'");
sqlServer.Update("UPDATE SMS_BayanihanSum SET " +
"combination_no_win = '" + winCode + "', " +
"total_win = '" + totalWon(refNo, winCode) + "', " +
"total_win_amount = '" + wonAllTotalAmount(refNo, winCode) + "', " +
"status = 'Closed' " +
"WHERE bayanihan_ref = '" + refNo + "'");
try
{
db.SMS_BayanihanSums.InsertOnSubmit(d);
db.SubmitChanges();
}
catch (Exception ex)
{
}
Response.Redirect(HelpController.Refresh);
}
partial void UpdateSMS_BayanihanSum(SMS_BayanihanSum instance);
partial void DeleteSMS_BayanihanSum(SMS_BayanihanSum instance);
partial void InsertSMS_BayanihanSum(SMS_BayanihanSum instance);
