private void InsertIntoUnitRegister(string ipAddress, string serialNumber, string name, string emailAddress, string phoneNumber, out string errorMessage) { errorMessage = string.Empty; using (MyDataClassesDataContext myDb = new MyDataClassesDataContext()) { UnitRegister n = new UnitRegister(); n.IPAddress = ipAddress; n.SerialNumber = serialNumber; n.Name = name; n.EmailAddress = emailAddress; n.PhoneNumber = phoneNumber; try { myDb.UnitRegisters.InsertOnSubmit(n); myDb.SubmitChanges(); } catch (Exception ex) { errorMessage = String.Format("Exception caught in SendEmail(): {0}", ex.ToString()); } } }
protected void RemoveEmailAddress_Click(object sender, EventArgs e) { // remove email address // add to RemoveEmailAddress Database using (MyDataClassesDataContext myDb = new MyDataClassesDataContext()) { EmailAddressOptOut optOut = new EmailAddressOptOut(); optOut.EmailAddress = this.EmailAddressLabel.Text; myDb.EmailAddressOptOuts.InsertOnSubmit(optOut); myDb.SubmitChanges(); } // on success, goto Thank You Page Response.Redirect("/EmailOptOutThankYou.aspx"); }
private void InsertLogFile(int loginId, string ipAddress, string type, string log) { using (MyDataClassesDataContext myDb = new MyDataClassesDataContext()) { LogFile newLog = new LogFile(); newLog.UserId = loginId; newLog.IPAddress = ipAddress; newLog.Type = type; newLog.Log = log; newLog.DateTime = DateTime.Now.AddHours(-4); myDb.LogFiles.InsertOnSubmit(newLog); myDb.SubmitChanges(); } }