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 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 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 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 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 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 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 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 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 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 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 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 static List <ClsFileType> GetFileTypes(bool bNonCourierEDI) { List <ClsFileType> qFileTypes = new List <ClsFileType>(); PuroTouchSQLDataContext o = new PuroTouchSQLDataContext(); if (bNonCourierEDI) { qFileTypes = o.GetTable <tblFileType>() .Where(p => p.ActiveFlag == true) .Select(p => new ClsFileType() { idFileType = p.idFileType, FileType = p.FileType, NonCourierEDI = p.NonCourierEDI, ActiveFlag = p.ActiveFlag, CreatedBy = p.CreatedBy, CreatedOn = p.CreatedOn, UpdatedBy = p.UpdatedBy, UpdatedOn = p.UpdatedOn }) .ToList(); } else { qFileTypes = o.GetTable <tblFileType>() .Where(p => p.ActiveFlag == true && p.NonCourierEDI == false) .Select(p => new ClsFileType() { idFileType = p.idFileType, FileType = p.FileType, NonCourierEDI = p.NonCourierEDI, ActiveFlag = p.ActiveFlag, CreatedBy = p.CreatedBy, CreatedOn = p.CreatedOn, UpdatedBy = p.UpdatedBy, UpdatedOn = p.UpdatedOn }) .ToList(); } return(qFileTypes); }
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 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 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 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 List <clsEDISpecialist> GetEDISpecialistView() { PuroTouchSQLDataContext o = new PuroTouchSQLDataContext(); List <clsEDISpecialist> qEDISpecialisth = o.GetTable <vw_EDISpecialist>() .Select(p => new clsEDISpecialist() { ActiveDirectoryName = p.ActiveDirectoryName, Name = p.Name, idEDISpecialist = p.idEDISpecialist, idEmployee = p.idEmployee, login = p.login, email = p.email, ReceiveNewReqEmail = p.ReceiveNewReqEmail, ActiveFlag = p.ActiveFlag, CreatedBy = p.CreatedBy, CreatedOn = p.CreatedOn, UpdatedBy = p.UpdatedBy, UpdatedOn = p.UpdatedOn }) .ToList(); return(qEDISpecialisth); }
public static List <clsCollectionSpecialist> GetCollectionSpecialist() { PuroTouchSQLDataContext o = new PuroTouchSQLDataContext(); List <clsCollectionSpecialist> qEDISpecialisth = o.GetTable <tblCollectionSpecialist>() .Select(p => new clsCollectionSpecialist() { idCollectionSpecialist = p.idCollectionSpecialist, idEmployee = p.idEmployee, login = p.login, email = p.email, ReceiveNewReqEmail = p.ReceiveNewReqEmail, ActiveFlag = p.ActiveFlag, CreatedBy = p.CreatedBy, CreatedOn = p.CreatedOn, UpdatedBy = p.UpdatedBy, UpdatedOn = p.UpdatedOn }) .ToList(); return(qEDISpecialisth); }
public static clsEDITransactionType GetOneEDITransactionType(int idEDITranscationType) { PuroTouchSQLDataContext o = new PuroTouchSQLDataContext(); clsEDITransactionType qEDITransType = o.GetTable <tblEDITranscationType>() .Select(p => new clsEDITransactionType() { idEDITranscationType = p.idEDITranscationType, EDITranscationType = p.EDITranscationType, Category = p.Category, CategoryID = p.CategoryID, ActiveFlag = p.ActiveFlag, CreatedBy = p.CreatedBy, CreatedOn = p.CreatedOn, UpdatedBy = p.UpdatedBy, UpdatedOn = p.UpdatedOn }) .Where(f => f.idEDITranscationType == idEDITranscationType) .FirstOrDefault(); return(qEDITransType); }
public static ClsContactType GetContactsTypeByID(int idContactType) { PuroTouchSQLDataContext o = new PuroTouchSQLDataContext(); ClsContactType qContactType = o.GetTable <tblContactType>() .Where(p => p.ActiveFlag == true && p.idContactType == idContactType) .Select(p => new ClsContactType() { idContactType = p.idContactType, ContactType = p.ContactType, ActiveFlag = p.ActiveFlag, CreatedBy = p.CreatedBy, CreatedOn = p.CreatedOn, UpdatedBy = p.UpdatedBy, UpdatedOn = p.UpdatedOn }) .FirstOrDefault(); return(qContactType); }
public static List <clsEDITransactionType> GetEDITransactionTypes(int idEDITranscationType) { PuroTouchSQLDataContext o = new PuroTouchSQLDataContext(); List <clsEDITransactionType> qShipMeth = o.GetTable <tblEDITranscationType>() .Select(p => new clsEDITransactionType() { idEDITranscationType = p.idEDITranscationType, EDITranscationType = p.EDITranscationType, Category = p.Category, CategoryID = p.CategoryID, ActiveFlag = p.ActiveFlag, CreatedBy = p.CreatedBy, CreatedOn = p.CreatedOn, UpdatedBy = p.UpdatedBy, UpdatedOn = p.UpdatedOn }) .Where(f => f.idEDITranscationType == idEDITranscationType) .ToList(); return(qShipMeth); }
public List <clsvwDiscoveryRequest> getallRequests() { PuroTouchSQLDataContext puroDB = new PuroTouchSQLDataContext(); List <clsvwDiscoveryRequest> lst = new List <clsvwDiscoveryRequest>(); lst = (from d in puroDB.vw_DiscoveryRequests select new clsvwDiscoveryRequest { idRequest = d.idRequest, SalesRepName = d.SalesRepName }).ToList(); return(lst); }
public static clsEDISpecialist GetEDISpecialistByIDView(int idEDISpecialist) { PuroTouchSQLDataContext o = new PuroTouchSQLDataContext(); clsEDISpecialist qEDISpecialisth = o.GetTable <vw_EDISpecialist>() .Where(p => p.idEDISpecialist == idEDISpecialist) .Select(p => new clsEDISpecialist() { ActiveDirectoryName = p.ActiveDirectoryName, Name = p.Name, idEDISpecialist = p.idEDISpecialist, idEmployee = p.idEmployee, login = p.login, email = p.email, ReceiveNewReqEmail = p.ReceiveNewReqEmail, ActiveFlag = p.ActiveFlag, CreatedBy = p.CreatedBy, CreatedOn = p.CreatedOn, UpdatedBy = p.UpdatedBy, UpdatedOn = p.UpdatedOn }) .FirstOrDefault(); return(qEDISpecialisth); }
public static List <ClsEDIOnboardingPhase> GetEDIOnboardingPhase() { PuroTouchSQLDataContext o = new PuroTouchSQLDataContext(); List <ClsEDIOnboardingPhase> qEDISpecialisth = o.GetTable <tblEDIOnboardingPhase>() .Where(p => p.idEDIOnboardingPhase != 0) .Select(p => new ClsEDIOnboardingPhase() { idEDIOnboardingPhase = p.idEDIOnboardingPhase, EDIOnboardingPhaseType = p.EDIOnboardingPhaseType, ActiveFlag = p.ActiveFlag, CreatedBy = p.CreatedBy, CreatedOn = p.CreatedOn, UpdatedBy = p.UpdatedBy, UpdatedOn = p.UpdatedOn }) .ToList(); return(qEDISpecialisth); }
public static List <clsEDIShipMethod> GetEDIShipMethodTypesByidRequest(int idRequest) { PuroTouchSQLDataContext o = new PuroTouchSQLDataContext(); List <clsEDIShipMethod> qShipMeth = o.GetTable <tblEDIShipMethod>() .Where(p => p.idRequest == idRequest) .Select(p => new clsEDIShipMethod() { idEDIShipMethod = p.idEDIShipMethod, idRequest = p.idRequest, MethodType = p.tblEDIShipMethodType.MethodType, idEDIShipMethodType = p.idEDIShipMethodType, ActiveFlag = p.ActiveFlag, CreatedBy = p.CreatedBy, CreatedOn = p.CreatedOn, UpdatedBy = p.UpdatedBy, UpdatedOn = p.UpdatedOn }) .ToList(); return(qShipMeth); }
public static List <ClsCommunicationMethod> GetCommunicationMethods() { PuroTouchSQLDataContext o = new PuroTouchSQLDataContext(); List <ClsCommunicationMethod> qCommMeth = o.GetTable <tblCommunicationMethod>() .Where(p => p.ActiveFlag == true) .Select(p => new ClsCommunicationMethod() { idCommunicationMethod = p.idCommunicationMethod, CommunicationMethod = p.CommunicationMethod, ActiveFlag = p.ActiveFlag, CreatedBy = p.CreatedBy, CreatedOn = p.CreatedOn, UpdatedBy = p.UpdatedBy, UpdatedOn = p.UpdatedOn }) .ToList(); return(qCommMeth); }
public List <ClsUserRoles> GetListClsAppUsers(string appname) { PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); List <ClsUserRoles> oAppUserlist = (from data in puroTouchContext.GetTable <vw_UserRole>() where data.ApplicationName == appname orderby data.UserName select new ClsUserRoles { UserName = data.UserName, ActiveDirectoryName = data.ActiveDirectoryName, RoleName = data.RoleName }).ToList(); return(oAppUserlist); }
public ClsUserRoles GetAppUserWithPassword(string appname, string username) { PuroTouchSQLDataContext puroTouchContext = new PuroTouchSQLDataContext(); ClsUserRoles oAppUser = (from data in puroTouchContext.GetTable <vw_UserRole>() where data.ApplicationName == appname where data.ActiveDirectoryName == username orderby data.UserName select new ClsUserRoles { UserName = data.UserName, ActiveDirectoryName = data.ActiveDirectoryName, RoleName = data.RoleName, EncryptedPassword = data.EncryptedPassword }).SingleOrDefault <ClsUserRoles>(); return(oAppUser); }