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);