public string InsertTargetDate(ClsTargetDates data) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); try { tblDiscoveryRequestTargetDate oNewRow = new tblDiscoveryRequestTargetDate() { idRequest = (Int32)data.idRequest, TargetDate = (DateTime)data.TargetDate, ChangeReason = data.ChangeReason, CreatedBy = data.CreatedBy, CreatedOn = (DateTime?)data.CreatedOn }; puroTouchContext.GetTable <tblDiscoveryRequestTargetDate>().InsertOnSubmit(oNewRow); // Submit the changes to the database. puroTouchContext.SubmitChanges(); } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
private ClsTargetDates populateObj(UserControl userControl) { ClsTargetDates oRow = new ClsTargetDates(); oRow.ChangeReason = (userControl.FindControl("txtChangeReason") as RadTextBox).Text; return(oRow); }
protected void rgGrid_UpdateCommand(object sender, GridCommandEventArgs e) { try { UserControl userControl = (UserControl)e.Item.FindControl(GridEditFormItem.EditFormUserControlID); Label errorMsg = (Label)userControl.FindControl("lblErrorMessage"); ClsTargetDates oRow = populateObj(userControl); oRow.idTargetDate = Convert.ToInt16((userControl.FindControl("lblTargetDateID") as Label).Text); string updateMsg = ""; if (IsValid) { if (oRow != null) { updateMsg = cls.UpdateChangeReason(oRow); if (updateMsg == "") { pnlsuccess.Visible = true; lblSuccess.Text = "Successfully updated information for " + "'" + oRow.ChangeReason + "'"; } else { errorMsg.Visible = true; errorMsg.Text = updateMsg; e.Canceled = true; } } } else { // display error errorMsg.Visible = true; errorMsg.Text = "Please enter Required fields"; e.Canceled = true; } } catch (Exception ex) { pnlDanger.Visible = true; lblDanger.Text = ex.Message.ToString(); e.Canceled = true; } }
public string UpdateChangeReason(ClsTargetDates data) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); try { if (data.idTargetDate > 0) { // Query the database for the row to be updated. var query = from qdata in puroTouchContext.GetTable <tblDiscoveryRequestTargetDate>() where qdata.idTargetDate == data.idTargetDate select qdata; // Execute the query, and change the column values // you want to change. foreach (tblDiscoveryRequestTargetDate updRow in query) { updRow.ChangeReason = data.ChangeReason; //updRow.TargetDate = data.TargetDate; //updRow.idRequest = data.idRequest; //updRow.CreatedBy = data.CreatedBy; //updRow.CreatedOn = data.CreatedOn; } // Submit the changes to the database. puroTouchContext.SubmitChanges(); } else { errMsg = "There is No Row with ID = " + "'" + data.idTargetDate + "'"; } } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }