public string InsertITBA(ClsITBA data) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); try { tblITBA oNewRow = new tblITBA() { ITBAemail = data.ITBAEmail, idEmployee = data.idEmployee, CreatedBy = data.CreatedBy, CreatedOn = (DateTime?)data.CreatedOn, //UpdatedBy = data.UpdatedBy, //UpdatedOn = (DateTime?)data.UpdatedOn, ActiveFlag = data.ActiveFlag, ReceiveNewReqEmail = data.ReceiveNewReqEmail, login = data.login }; puroTouchContext.GetTable <tblITBA>().InsertOnSubmit(oNewRow); // Submit the changes to the database. puroTouchContext.SubmitChanges(); //newID = oNewRow.idTaskType; } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public string InsertVendorType(ClsVendorType data) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); try { tblVendorType oNewRow = new tblVendorType() { idVendorType = (Int32)data.idVendorType, VendorType = data.VendorType, CreatedBy = data.CreatedBy, CreatedOn = (DateTime?)data.CreatedOn, //UpdatedBy = data.UpdatedBy, //UpdatedOn = (DateTime?)data.UpdatedOn, ActiveFlag = data.ActiveFlag }; puroTouchContext.GetTable <tblVendorType>().InsertOnSubmit(oNewRow); // Submit the changes to the database. puroTouchContext.SubmitChanges(); //newID = oNewRow.idTaskType; } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public string InsertShippingProduct(ClsShippingProducts data) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); try { tblShippingProduct oNewRow = new tblShippingProduct() { ShippingProduct = data.ShippingProduct, idShippingSvc = data.idShippingSvc, CreatedBy = data.CreatedBy, CreatedOn = (DateTime?)data.CreatedOn, //UpdatedBy = data.UpdatedBy, //UpdatedOn = (DateTime?)data.UpdatedOn, ActiveFlag = data.ActiveFlag }; puroTouchContext.GetTable <tblShippingProduct>().InsertOnSubmit(oNewRow); // Submit the changes to the database. puroTouchContext.SubmitChanges(); //newID = oNewRow.idTaskType; } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public static string Insert(clsEDIShipMethod data, out Int32 newID) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); newID = -1; try { List <clsEDIShipMethod> qShipMeth = GetEDIShipMethodTypesByidRequest(data.idRequest, data.idEDIShipMethodType); if (qShipMeth.Count() < 1) { tblEDIShipMethod oNewRow = new tblEDIShipMethod() { idEDIShipMethodType = data.idEDIShipMethodType, idRequest = data.idRequest, ActiveFlag = data.ActiveFlag, CreatedBy = data.CreatedBy, CreatedOn = data.CreatedOn }; puroTouchContext.GetTable <tblEDIShipMethod>().InsertOnSubmit(oNewRow); puroTouchContext.SubmitChanges(); newID = oNewRow.idEDIShipMethod; data.idRequest = newID; } } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public string InsertEDI(ClsDiscoveryRequestEDI data, out Int32 newID) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); newID = -1; try { tblDiscoveryRequestEDI oNewRow = new tblDiscoveryRequestEDI() { idRequest = (Int32)data.idRequest, Solution = data.Solution, FileFormat = data.FileFormat, CommunicationMethod = data.CommunicationMethod, UpdatedBy = data.UpdatedBy, UpdatedOn = data.UpdatedOn, CreatedBy = data.CreatedBy, CreatedOn = data.CreatedOn }; puroTouchContext.GetTable<tblDiscoveryRequestEDI>().InsertOnSubmit(oNewRow); // Submit the changes to the database. puroTouchContext.SubmitChanges(); newID = oNewRow.idDREDI; } catch (Exception ex) { errMsg = ex.Message.ToString(); } return errMsg; }
public string InsertFileUpload(ClsFileUpload data, out Int32 newID) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); newID = -1; try { tblDiscoveryRequestUpload oNewRow = new tblDiscoveryRequestUpload() { idRequest = (Int32)data.idRequest, UploadDate = data.UploadDate, Description = data.Description, FilePath = data.FilePath, CreatedBy = data.CreatedBy, CreatedOn = (DateTime?)data.CreatedOn, ActiveFlag = data.ActiveFlag }; if (oNewRow.idRequest != 0) { puroTouchContext.GetTable <tblDiscoveryRequestUpload>().InsertOnSubmit(oNewRow); puroTouchContext.SubmitChanges(); newID = oNewRow.idFileUpload; } } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public string DeleteEDI(int idRequest) { string errMsg = ""; try { PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); var deleteEDI = from details in puroTouchContext.GetTable<tblDiscoveryRequestEDI>() where details.idRequest == idRequest select details; foreach (var idRequestEDI in deleteEDI) { puroTouchContext.GetTable<tblDiscoveryRequestEDI>().DeleteOnSubmit(idRequestEDI); } try { puroTouchContext.SubmitChanges(); } catch (Exception ex) { errMsg = ex.Message.ToString(); } } catch (Exception ex) { errMsg = ex.Message.ToString(); } return errMsg; }
public string InsertEDISolution(ClsEDISolution data) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); try { tblEDISolution oNewRow = new tblEDISolution() { Solution = data.Solution, CreatedBy = data.CreatedBy, CreatedOn = (DateTime?)data.CreatedOn, //UpdatedBy = data.UpdatedBy, //UpdatedOn = (DateTime?)data.UpdatedOn, ActiveFlag = data.ActiveFlag }; puroTouchContext.GetTable <tblEDISolution>().InsertOnSubmit(oNewRow); // Submit the changes to the database. puroTouchContext.SubmitChanges(); //newID = oNewRow.idTaskType; } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public string InsertEquipment(ClsDiscoveryRequestEquip data, out Int32 newID) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); newID = -1; try { tblDiscoveryRequestEquipment oNewRow = new tblDiscoveryRequestEquipment() { idRequest = (Int32)data.idRequest, EquipmentDesc = data.EquipmentDesc, number = (Int32)data.number, UpdatedBy = data.UpdatedBy, UpdatedOn = data.UpdatedOn, CreatedBy = data.CreatedBy, CreatedOn = data.CreatedOn }; puroTouchContext.GetTable <tblDiscoveryRequestEquipment>().InsertOnSubmit(oNewRow); // Submit the changes to the database. puroTouchContext.SubmitChanges(); newID = oNewRow.idDREquipment; } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public static string InsertEDISpecialist(clsEDISpecialist data) { string errMsg = ""; PuroTouchSQLDataContext o = new PuroTouchSQLDataContext(); try { tblEDISpecialist oNewRow = new tblEDISpecialist() { email = data.email, idEmployee = data.idEmployee, CreatedBy = data.CreatedBy, CreatedOn = DateTime.Now, //UpdatedBy = data.UpdatedBy, //UpdatedOn = (DateTime?)data.UpdatedOn, ActiveFlag = data.ActiveFlag, ReceiveNewReqEmail = data.ReceiveNewReqEmail, login = data.login }; o.GetTable <tblEDISpecialist>().InsertOnSubmit(oNewRow); o.SubmitChanges(); } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public static string Insert(clsContact data, out Int32 newID) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); newID = -1; try { tblContact oNewRow = new tblContact() { idContactType = data.idContactType, idRequest = data.idRequest, Name = data.Name, Title = data.Title, Phone = data.Phone, Email = data.Email, CreatedBy = data.CreatedBy, CreatedOn = data.CreatedOn }; puroTouchContext.GetTable <tblContact>().InsertOnSubmit(oNewRow); puroTouchContext.SubmitChanges(); newID = oNewRow.idContact; data.idRequest = newID; } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public string InsertSolutionType(ClsSolutionType data) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); try { ClsSolutionType oNewRow = new ClsSolutionType() { SolutionType = data.SolutionType, CreatedBy = data.CreatedBy, CreatedOn = (DateTime?)data.CreatedOn, //UpdatedBy = data.UpdatedBy, //UpdatedOn = (DateTime?)data.UpdatedOn, ActiveFlag = data.ActiveFlag }; puroTouchContext.GetTable <ClsSolutionType>().InsertOnSubmit(oNewRow); // Submit the changes to the database. puroTouchContext.SubmitChanges(); } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
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); }
public static string Update(clsContact data) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); try { var contact = puroTouchContext.GetTable <tblContact>().Where(f => f.idContact == data.idContact).FirstOrDefault(); if (contact != null) { contact.Name = data.Name; contact.Title = data.Title; contact.Phone = data.Phone; contact.Email = data.Email; contact.UpdatedBy = data.UpdatedBy; contact.UpdatedOn = data.UpdatedOn; } puroTouchContext.SubmitChanges(); } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public static string UpdateEDIOnboardingPhase(ClsEDIOnboardingPhase data) { string errMsg = ""; PuroTouchSQLDataContext o = new PuroTouchSQLDataContext(); try { if (data.idEDIOnboardingPhase > 0) { var query = from qdata in o.GetTable <tblEDIOnboardingPhase>() where qdata.idEDIOnboardingPhase == data.idEDIOnboardingPhase select qdata; foreach (tblEDIOnboardingPhase updRow in query) { updRow.idEDIOnboardingPhase = data.idEDIOnboardingPhase; updRow.EDIOnboardingPhaseType = data.EDIOnboardingPhaseType; updRow.ActiveFlag = data.ActiveFlag; updRow.UpdatedBy = data.UpdatedBy; updRow.UpdatedOn = DateTime.Now; } o.SubmitChanges(); } else { errMsg = "There is No Shipping Product with ID = " + "'" + data.idEDIOnboardingPhase + "'"; } } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public static string Insert(clsExceptionLogging data, out long newID) { string errMsg = ""; PuroTouchSQLDataContext o = new PuroTouchSQLDataContext(); newID = -1; try { tblExceptionLogging oNewRow = new tblExceptionLogging() { ExceptionMsg = data.ExceptionMsg, Method = data.Method, ExceptionType = data.ExceptionType, ExceptionSource = data.ExceptionSource, ExceptionURL = data.ExceptionURL, CreatedBy = data.CreatedBy, CreatedOn = data.CreatedOn, }; o.GetTable <tblExceptionLogging>().InsertOnSubmit(oNewRow); o.SubmitChanges(); newID = oNewRow.Logid; } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public string InsertServices(ClsDiscoveryRequestSvcs data, out Int32 newID) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); newID = -1; try { tblDiscoveryRequestService oNewRow = new tblDiscoveryRequestService() { idRequest = (Int32)data.idRequest, idShippingSvc = (Int32)data.idShippingSvc, volume = (Int32)data.volume, UpdatedBy = data.UpdatedBy, UpdatedOn = data.UpdatedOn, CreatedBy = data.CreatedBy, CreatedOn = data.CreatedOn }; puroTouchContext.GetTable <tblDiscoveryRequestService>().InsertOnSubmit(oNewRow); // Submit the changes to the database. puroTouchContext.SubmitChanges(); newID = oNewRow.idRequestSvc; } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public static string Remove(int idContact) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); try { var q = puroTouchContext.GetTable <tblContact>().Where(f => f.idContact == idContact).FirstOrDefault(); puroTouchContext.GetTable <tblContact>().DeleteOnSubmit(q); puroTouchContext.SubmitChanges(); } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public string UpdateInductionPoint(ClsInductionPoint data) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); try { if (data.idInduction > 0) { // Query the database for the row to be updated. var query = from qdata in puroTouchContext.GetTable <tblInductionPoint>() where qdata.idInduction == data.idInduction select qdata; // Execute the query, and change the column values // you want to change. foreach (tblInductionPoint updRow in query) { updRow.Description = data.Description; updRow.Address = data.Address; updRow.City = data.City; updRow.State = data.State; updRow.Zip = data.Zip; updRow.Country = data.Country; updRow.ActiveFlag = data.ActiveFlag; updRow.PuroPostFlag = data.PuroPostFlag; updRow.idInduction = data.idInduction; updRow.UpdatedBy = data.UpdatedBy; updRow.UpdatedOn = data.UpdatedOn; } // Submit the changes to the database. puroTouchContext.SubmitChanges(); } else { errMsg = "There is No Induction Point with ID = " + "'" + data.idInduction + "'"; } } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public static string Insert(List <clsContact> contactList, Int32 ID) { string errMsg = ""; PuroTouchSQLDataContext o = new PuroTouchSQLDataContext(); try { foreach (clsContact c in contactList) { tblContact oNewRow = new tblContact() { idContactType = c.idContactType, idRequest = ID, Name = c.Name, Title = c.Title, Phone = c.Phone, Email = c.Email, ActiveFlag = true, CreatedBy = c.CreatedBy, CreatedOn = DateTime.Now }; var contact = o.GetTable <tblContact>().Where(f => f.idContactType == c.idContactType && f.idRequest == ID).FirstOrDefault(); if (contact != null) { contact.Name = c.Name; contact.Title = c.Title; contact.Phone = c.Phone; contact.Email = c.Email; contact.ActiveFlag = true; contact.UpdatedBy = c.CreatedBy; contact.UpdatedOn = DateTime.Now; } else { o.GetTable <tblContact>().InsertOnSubmit(oNewRow); } o.SubmitChanges(); } } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public string UpdateITBA(ClsITBA data) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); try { if (data.idEmployee > 0) { // Query the database for the row to be updated. var query = from qdata in puroTouchContext.GetTable <tblITBA>() where qdata.idEmployee == data.idEmployee select qdata; // Execute the query, and change the column values // you want to change. foreach (tblITBA updRow in query) { updRow.ITBAemail = data.ITBAEmail; updRow.idEmployee = data.idEmployee; updRow.ActiveFlag = data.ActiveFlag; updRow.UpdatedBy = data.UpdatedBy; updRow.UpdatedOn = data.UpdatedOn; updRow.ReceiveNewReqEmail = data.ReceiveNewReqEmail; updRow.login = data.login; } // Submit the changes to the database. puroTouchContext.SubmitChanges(); } else { errMsg = "There is No Shipping Product with ID = " + "'" + data.idEmployee + "'"; } } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public string UpdateNote(ClsNotes data) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); try { if (data.idNote > 0) { // Query the database for the row to be updated. var query = from qdata in puroTouchContext.GetTable <tblDiscoveryRequestNote>() where qdata.idNote == data.idNote select qdata; // Execute the query, and change the column values // you want to change. foreach (tblDiscoveryRequestNote updRow in query) { updRow.noteDate = data.noteDate; updRow.publicNote = data.publicNote; updRow.idTaskType = data.idTaskType; updRow.timeSpent = data.timeSpent; updRow.privateNote = data.privateNote; updRow.UpdatedBy = data.UpdatedBy; updRow.UpdatedOn = data.UpdatedOn; } // Submit the changes to the database. puroTouchContext.SubmitChanges(); } else { errMsg = "There is No Discovery Request Note with idNote = " + "'" + data.idNote + "'"; } } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public string UpdateOnboardingPhase(ClsOnboardingPhase data) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); try { if (data.idOnboardingPhase > 0) { // Query the database for the row to be updated. var query = from qdata in puroTouchContext.GetTable <tblOnboardingPhase>() where qdata.idOnboardingPhase == data.idOnboardingPhase select qdata; // Execute the query, and change the column values // you want to change. foreach (tblOnboardingPhase updRow in query) { updRow.OnboardingPhase = data.OnboardingPhase; updRow.ActiveFlag = data.ActiveFlag; updRow.idOnboardingPhase = data.idOnboardingPhase; updRow.UpdatedBy = data.UpdatedBy; updRow.UpdatedOn = data.UpdatedOn; updRow.SortValue = data.SortValue; } // Submit the changes to the database. puroTouchContext.SubmitChanges(); } else { errMsg = "There is No Onboarding Phase with ID = " + "'" + data.idOnboardingPhase + "'"; } } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public string UpdateShippingProduct(ClsShippingProducts data) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); try { if (data.idShippingSvc > 0) { // Query the database for the row to be updated. var query = from qdata in puroTouchContext.GetTable <tblShippingProduct>() where qdata.idShippingProduct == data.idShippingProduct select qdata; // Execute the query, and change the column values // you want to change. foreach (tblShippingProduct updRow in query) { updRow.ShippingProduct = data.ShippingProduct; updRow.idShippingSvc = data.idShippingSvc; updRow.ActiveFlag = data.ActiveFlag; updRow.idShippingProduct = data.idShippingProduct; updRow.UpdatedBy = data.UpdatedBy; updRow.UpdatedOn = data.UpdatedOn; } // Submit the changes to the database. puroTouchContext.SubmitChanges(); } else { errMsg = "There is No Shipping Product with ID = " + "'" + data.idShippingProduct + "'"; } } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public string UpdateVendor(ClsThirdPartyVendor data) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); try { if (data.idThirdPartyVendor > 0) { // Query the database for the row to be updated. var query = from qdata in puroTouchContext.GetTable <tblThirdPartyVendor>() where qdata.idThirdPartyVendor == data.idThirdPartyVendor select qdata; // Execute the query, and change the column values // you want to change. foreach (tblThirdPartyVendor updRow in query) { updRow.VendorName = data.VendorName; updRow.ActiveFlag = data.ActiveFlag; updRow.idThirdPartyVendor = data.idThirdPartyVendor; updRow.UpdatedBy = data.UpdatedBy; updRow.UpdatedOn = data.UpdatedOn; } // Submit the changes to the database. puroTouchContext.SubmitChanges(); } else { errMsg = "There is No Vendor with ID = " + "'" + data.idThirdPartyVendor + "'"; } } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public string UpdateCommMethod(ClsCommunicationMethod data) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); try { if (data.idCommunicationMethod > 0) { // Query the database for the row to be updated. var query = from qdata in puroTouchContext.GetTable <tblCommunicationMethod>() where qdata.idCommunicationMethod == data.idCommunicationMethod select qdata; // Execute the query, and change the column values // you want to change. foreach (tblCommunicationMethod updRow in query) { updRow.CommunicationMethod = data.CommunicationMethod; updRow.ActiveFlag = data.ActiveFlag; updRow.idCommunicationMethod = data.idCommunicationMethod; updRow.UpdatedBy = data.UpdatedBy; updRow.UpdatedOn = data.UpdatedOn; } // Submit the changes to the database. puroTouchContext.SubmitChanges(); } else { errMsg = "There is No Shipping Channel with ID = " + "'" + data.idCommunicationMethod + "'"; } } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
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); }
public string UpdateFileUpload(ClsFileUpload data) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); try { if (data.idFileUpload > 0) { // Query the database for the row to be updated. var query = from qdata in puroTouchContext.GetTable <tblDiscoveryRequestUpload>() where qdata.idFileUpload == data.idFileUpload select qdata; // Execute the query, and change the column values // you want to change. foreach (tblDiscoveryRequestUpload updRow in query) { updRow.UploadDate = data.UploadDate; updRow.Description = data.Description; updRow.FilePath = data.FilePath; updRow.UpdatedBy = data.UpdatedBy; updRow.UpdatedOn = data.UpdatedOn; updRow.ActiveFlag = data.ActiveFlag; } // Submit the changes to the database. puroTouchContext.SubmitChanges(); } else { errMsg = "There is No File Upload with ID = " + "'" + data.idFileUpload + "'"; } } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
public static string UpdateCollectionSpecialist(clsCollectionSpecialist data) { string errMsg = ""; PuroTouchSQLDataContext o = new PuroTouchSQLDataContext(); try { if (data.idEmployee > 0) { var query = from qdata in o.GetTable <tblCollectionSpecialist>() where qdata.idEmployee == data.idEmployee select qdata; foreach (tblCollectionSpecialist updRow in query) { updRow.email = data.email; updRow.idEmployee = data.idEmployee; updRow.ActiveFlag = data.ActiveFlag; updRow.UpdatedBy = data.UpdatedBy; updRow.UpdatedOn = DateTime.Now; updRow.ReceiveNewReqEmail = data.ReceiveNewReqEmail; updRow.login = data.login; } // Submit the changes to the database. o.SubmitChanges(); } else { errMsg = "There is No Shipping Product with ID = " + "'" + data.idEmployee + "'"; } } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }
//DELETE A REQUEST (set ActiveFlag to false) public string deActivateDiscoveryRequest(Int32 requestID, string userName) { string errMsg = ""; PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); try { if (requestID > 0) { // Query the database for the row to be updated. var query = from qdata in puroTouchContext.GetTable <tblDiscoveryRequest>() where qdata.idRequest == requestID select qdata; // Execute the query, and change the column values // you want to change. foreach (tblDiscoveryRequest updRow in query) { updRow.ActiveFlag = false; updRow.UpdatedBy = userName; updRow.UpdatedOn = DateTime.Now; } // Submit the changes to the database. puroTouchContext.SubmitChanges(); } else { errMsg = "There is No Discovery Request with idRequest = " + "'" + requestID + "'"; } } catch (Exception ex) { errMsg = ex.Message.ToString(); } return(errMsg); }