public int UpdateOppStatusDefault(int clientId, int cdfId) { int result = 0; using (var sdaCloudEntities = new SDACloudEntities()) { using (sdaCloudEntities) { using (var transactionScope = new TransactionScope()) { var collection = sdaCloudEntities.OppStatus.Where(i => i.ClientID == clientId); collection.ToList().ForEach(c => c.Default = "N"); sdaCloudEntities.SaveChanges(); var existingOppStatus = sdaCloudEntities.OppStatus.FirstOrDefault(i => i.ID == cdfId); if (existingOppStatus != null) { existingOppStatus.Default = "Y"; result = sdaCloudEntities.SaveChanges(); } transactionScope.Complete(); } } } return(result); }
public int DeleteInterfaceXRef(ClientDefinedFieldDto clientDefinedField) { int result = 0; using (var sdaCloudEntities = new SDACloudEntities()) { using (var transactionScope = new TransactionScope()) { var existingCDF = sdaCloudEntities.InterfaceXRefs.FirstOrDefault(i => i.InterfaceXRefID == clientDefinedField.InterfaceXRefID); if (existingCDF != null) { //sdaCloudEntities.DeleteObject(existingCDF); } result = sdaCloudEntities.SaveChanges(); if (result >= 0) { var client = sdaCloudEntities.Clients.FirstOrDefault(o => o.ClientID == clientDefinedField.ClientID); if (client != null) { client.CRMXrefUpdDT = DateTime.Now; sdaCloudEntities.SaveChanges(); } } transactionScope.Complete(); } } return(result); }
/// <summary> /// Saves the new user view. /// </summary> /// <param name="userView">The user view.</param> /// <returns></returns> public int SaveNewUserView(UserViewDto userView) { int result; using (var sdaCloudEntities = new SDACloudEntities()) { using (var transactionScope = new TransactionScope()) { var nList = GetUserViewsByUserAndClient(userView.ClientID, userView.UserID); if (nList.Count < 30) { var existName = nList.Where(u => u.ViewName.ToUpper().Equals(userView.ViewName.ToUpper())).FirstOrDefault(); if ((existName == null) && (!userView.ViewName.ToUpper().Equals("DEFAULT"))) { var existingUser = new UserView { UserID = userView.UserID, ClientID = userView.ClientID, View = userView.View, ViewName = userView.ViewName }; sdaCloudEntities.UserViews.AddObject(existingUser); sdaCloudEntities.SaveChanges(); var existingUv = sdaCloudEntities.UserViews.Where(u => u.ClientID == userView.ClientID && u.UserID == userView.UserID && u.ViewName.ToUpper().Equals(userView.ViewName.ToUpper())).FirstOrDefault(); result = existingUv.UserViewID; transactionScope.Complete(); } else if ((existName != null) && (!userView.ViewName.ToUpper().Equals("DEFAULT"))) { var existingUv = sdaCloudEntities.UserViews.Where(u => u.ClientID == userView.ClientID && u.UserID == userView.UserID && u.ViewName.ToUpper().Equals(userView.ViewName.ToUpper())).FirstOrDefault(); existingUv.View = userView.View; sdaCloudEntities.SaveChanges(); result = existingUv.UserViewID; transactionScope.Complete(); } else { result = -2; } } else { result = 0; } } } return(result); }
/// <summary> /// Deletes the user views. /// </summary> /// <param name="uvList">The uv list.</param> /// <returns></returns> public int DeleteUserViews(string uvList) { int result; using (var sdaCloudEntities = new SDACloudEntities()) { List <string> tagIds = uvList.Split(',').ToList(); var userViews = new List <UserView>(); foreach (var uv in tagIds) { int uvId; Int32.TryParse(uv, out uvId); var userView = sdaCloudEntities.UserViews.Where(q => q.UserViewID == uvId).SingleOrDefault(); if (userView != null) { userViews.Add(userView); } } foreach (var userview in userViews) { //sdaCloudEntities.DeleteObject(userview); } result = sdaCloudEntities.SaveChanges(); } return(result); }
public bool AddErrorLogMessage(int userId, int clientId, string errorMessage) { bool result = false; using (var sdaCloudEntities = new SDACloudEntities()) { using (sdaCloudEntities) { using (var transactionScope = new TransactionScope()) { var errorLog = new ErrorLog { ClientID = clientId, UserID = userId, ErrorMessage = errorMessage, ProcessDT = DateTime.UtcNow }; sdaCloudEntities.ErrorLogs.AddObject(errorLog); sdaCloudEntities.SaveChanges(); transactionScope.Complete(); } } } return(result); }
public void Update(DocumentDto documentDto) { try { using (SDACloudEntities sDACloudEntities = new SDACloudEntities()) { using (sDACloudEntities) { using (TransactionScope transactionScope = new TransactionScope()) { Document document = sDACloudEntities.Documents.FirstOrDefault((Document i) => i.ClientID == (int?)documentDto.ClientID && i.LastFileSaveLocation.Equals(documentDto.LastFileSaveLocation)); document.DocumentType = documentDto.DocumentType; document.FilePlatformID = documentDto.FilePlatformID; document.LastFileSaveLocation = documentDto.LastFileSaveLocation; document.LastUpdatedBy = new int?(documentDto.CreatedBy); document.LastUpdatedDT = new DateTime?(DateTime.Now); sDACloudEntities.SaveChanges(); transactionScope.Complete(); } } } } catch (Exception ex) { throw new Exception(ex.Message); } }
/// <summary> /// Updates the user. /// </summary> /// <param name="userDto">The user dto.</param> /// <returns></returns> public int UpdateUser(UserDto userDto) { int result; using (var sdaCloudEntities = new SDACloudEntities()) { using (var transactionScope = new TransactionScope()) { var existingUser = sdaCloudEntities.Users.FirstOrDefault(i => i.UserID == userDto.UserId); if (existingUser != null) { existingUser.Administrator = (userDto.Administrator ? "Y" : "N"); existingUser.FirstName = userDto.FirstName; existingUser.LastName = userDto.LastName; existingUser.LoginID = userDto.LoginID; existingUser.ManagerUserID = userDto.ManagerUserID; existingUser.CloudLastUpdBy = userDto.CloudLastUpdBy; existingUser.CloudLastUpdDT = DateTime.UtcNow; } result = sdaCloudEntities.SaveChanges(); transactionScope.Complete(); } } return(result); }
/// <summary> /// Updates the user manager. /// </summary> /// <param name="userId">The user identifier.</param> /// <param name="newValue">The new value.</param> /// <returns></returns> public int UpdateUserManager(int userId, int newValue) { int result; using (var sdaCloudEntities = new SDACloudEntities()) { using (sdaCloudEntities) { using (var transactionScope = new TransactionScope()) { var existingQuote = sdaCloudEntities.Users.FirstOrDefault(i => i.UserID == userId); if (existingQuote != null) { if (newValue > 0) { existingQuote.ManagerUserID = newValue; } else { existingQuote.ManagerUserID = null; } } result = sdaCloudEntities.SaveChanges(); transactionScope.Complete(); } } } return(result); }
/// <summary> /// Updates the user email sent field. /// </summary> /// <param name="uList">The u list.</param> /// <returns></returns> public string UpdateUserEmailSent(string uList) { string result = string.Empty; using (var sdaCloudEntities = new SDACloudEntities()) { List <string> tagIds = uList.Split(',').ToList(); var users = new List <User>(); foreach (var uv in tagIds) { int uvId; Int32.TryParse(uv, out uvId); var userView = sdaCloudEntities.Users.Where(q => q.UserID == uvId).SingleOrDefault(); if (userView != null) { userView.EmailSent = "Requested"; } else { if (!string.IsNullOrEmpty(result)) { result += ","; } result += uv; } } sdaCloudEntities.SaveChanges(); } return(result); }
/// <summary> /// Deletes the opp statuses. /// </summary> /// <param name="uList">The u list.</param> /// <returns></returns> public string DeleteOppStatuses(string uList) { string result = string.Empty; using (var sdaCloudEntities = new SDACloudEntities()) { List <string> tagIds = uList.Split(',').ToList(); foreach (var uv in tagIds) { int uvId; Int32.TryParse(uv, out uvId); var oppStatus = sdaCloudEntities.OppStatus.Where(q => q.ID == uvId).SingleOrDefault(); if (oppStatus != null) //&& oppStatus.Opportunities.Count == 0 { oppStatus.DeleteInd = "Y"; } else { if (!string.IsNullOrEmpty(result)) { result += ","; } result += uv; } } sdaCloudEntities.SaveChanges(); } return(result); }
/// <summary> /// Adds the user. /// </summary> /// <param name="userDto">The user dto.</param> /// <returns></returns> public int AddUser(UserDto userDto) { int result = 0; using (var sdaCloudEntities = new SDACloudEntities()) { using (var transactionScope = new TransactionScope()) { var existingUser = sdaCloudEntities.Users.FirstOrDefault(i => i.LoginID == userDto.LoginID); if (existingUser == null) { existingUser = new User { ClientID = userDto.ClientId, LoginID = userDto.LoginID, Password = userDto.Password, FirstName = userDto.FirstName, LastName = userDto.LastName, ManagerUserID = userDto.ManagerUserID, Administrator = (userDto.Administrator ? "Y" : "N"), DeleteInd = "N", CloudLastUpdBy = userDto.CloudLastUpdBy, CloudLastUpdDT = DateTime.UtcNow }; sdaCloudEntities.Users.AddObject(existingUser); } else { if (existingUser.DeleteInd.Equals("Y") && existingUser.ClientID == userDto.ClientId) { existingUser.Password = userDto.Password; existingUser.FirstName = userDto.FirstName; existingUser.LastName = userDto.LastName; existingUser.ManagerUserID = userDto.ManagerUserID; existingUser.Administrator = (userDto.Administrator ? "Y" : "N"); existingUser.DeleteInd = "N"; existingUser.CloudLastUpdBy = userDto.CloudLastUpdBy; existingUser.CloudLastUpdDT = DateTime.UtcNow; } else { result = -2; } } sdaCloudEntities.SaveChanges(); if (result != -2) { result = existingUser.UserID; } transactionScope.Complete(); } } return(result); }
public int InsertClientImportOption(int ClientId, string ImportOption, string Status) { int result = 0; try { using (SDACloudEntities SDACloudEntities = new SDACloudEntities()) { using (SDACloudEntities) { using (TransactionScope transactionScope = new TransactionScope()) { var existingEntity = SDACloudEntities.ClientImportOptions.FirstOrDefault(i => i.ClientID == ClientId && i.ImportOption.Equals(ImportOption)); if (existingEntity == null) { ClientImportOption newEntity = new ClientImportOption() { ClientID = ClientId, ImportOption = ImportOption, Status = Status }; SDACloudEntities.ClientImportOptions.AddObject(newEntity); result = SDACloudEntities.SaveChanges(); transactionScope.Complete(); } else { if (!existingEntity.Status.Equals(Status)) { existingEntity.Status = Status; existingEntity.UpdateDT = DateTime.UtcNow; result = SDACloudEntities.SaveChanges(); transactionScope.Complete(); } } } } } } catch (Exception e) { throw new Exception(e.Message + " " + e.InnerException.Message); } return(result); }
public int AddInterfaceXRef(ClientDefinedFieldDto clientDefinedField) { int result; using (var sdaCloudEntities = new SDACloudEntities()) { using (var transactionScope = new TransactionScope()) { var existingCDF = new InterfaceXRef { Txn = "CRMXref", ClientID = clientDefinedField.ClientID, InterfaceTable = clientDefinedField.Table, InterfaceField = clientDefinedField.Field, InterfaceFieldType = (clientDefinedField.Format.Equals("Text")) ? "Varchar" : "Decimal", SDASMTable = clientDefinedField.Table, SDASMField = clientDefinedField.Field, SDASMFieldType = clientDefinedField.Format, SDARangeName = clientDefinedField.SDARangeName }; sdaCloudEntities.InterfaceXRefs.AddObject(existingCDF); sdaCloudEntities.SaveChanges(); result = existingCDF.InterfaceXRefID; if (result > 0) { var client = sdaCloudEntities.Clients.FirstOrDefault(o => o.ClientID == clientDefinedField.ClientID); if (client != null) { client.CRMXrefUpdDT = DateTime.Now; sdaCloudEntities.SaveChanges(); } } transactionScope.Complete(); } } return(result); }
public int AddClientDefinedField(ClientDefinedFieldDto clientDefinedField) { int result; using (var sdaCloudEntities = new SDACloudEntities()) { using (var transactionScope = new TransactionScope()) { var existingCDF = new ClientDefinedField { ClientID = clientDefinedField.ClientID, Table = clientDefinedField.Table, Field = clientDefinedField.Field, ColumnHeader = clientDefinedField.ColumnHeader, Format = clientDefinedField.Format, SDARangeName = clientDefinedField.SDARangeName }; sdaCloudEntities.ClientDefinedFields.AddObject(existingCDF); result = sdaCloudEntities.SaveChanges(); if (result > 0) { InterfaceXRefDL interfaceXrefDL = new InterfaceXRefDL(); var interfaceXrefId = interfaceXrefDL.AddInterfaceXRef(clientDefinedField); if (interfaceXrefId > 0) { existingCDF.InterfaceXRefID = interfaceXrefId; sdaCloudEntities.SaveChanges(); } } result = existingCDF.ClientDefinedFieldID; transactionScope.Complete(); } } return(result); }
/// <summary> /// </summary> /// <param name="UserMachineDataDto"></param> /// <returns></returns> public int AddUserMachineData(UserMachineDataDto UserMachineDataDto) { int result = 0; try { using (var sdaCloudEntities = new SDACloudEntities()) { using (var transactionScope = new TransactionScope()) { var existingEntity = sdaCloudEntities .UserMachineDatas .Where(i => i.ClientID == UserMachineDataDto.ClientID && i.UserID == UserMachineDataDto.UserID && i.WindowsUserName.Equals(UserMachineDataDto.WindowsUserName) && i.MACAddress.Equals(UserMachineDataDto.MACAddress)) .FirstOrDefault(); if (existingEntity == null) { existingEntity = new UserMachineData() { ClientID = UserMachineDataDto.ClientID, UserID = UserMachineDataDto.UserID, WindowsUserName = UserMachineDataDto.WindowsUserName, MACAddress = UserMachineDataDto.MACAddress, VersionDotNet = UserMachineDataDto.VersionDotNet, VersionExcel = UserMachineDataDto.VersionExcel, VersionWord = UserMachineDataDto.VersionWord, VersionSDA = UserMachineDataDto.VersionSDA, VersionSalesManager = UserMachineDataDto.VersionSalesManager, VersionWindows = UserMachineDataDto.VersionWindows, InstallType = UserMachineDataDto.InstallType, UserName = UserMachineDataDto.UserName, Email = UserMachineDataDto.Email, Company = UserMachineDataDto.Company, Title = UserMachineDataDto.Title, Phone = UserMachineDataDto.Phone, UserTimeZone = UserMachineDataDto.UserTimeZone, CreateDT = DateTime.UtcNow, LastUpdDT = DateTime.UtcNow }; sdaCloudEntities.UserMachineDatas.AddObject(existingEntity); result = sdaCloudEntities.SaveChanges(); transactionScope.Complete(); } } } } catch (Exception e) { throw new Exception(e.Message); } return(result); }
public int UpdateInterfaceXRef(ClientDefinedFieldDto clientDefinedField) { int result = 0; using (var sdaCloudEntities = new SDACloudEntities()) { using (var transactionScope = new TransactionScope()) { var existingCDF = sdaCloudEntities.InterfaceXRefs.FirstOrDefault(i => i.InterfaceXRefID == clientDefinedField.InterfaceXRefID); if (existingCDF != null) { existingCDF.InterfaceTable = clientDefinedField.Table; existingCDF.InterfaceField = clientDefinedField.Field; existingCDF.InterfaceFieldType = (clientDefinedField.Format.Equals("Text")) ? "Varchar" : "Decimal"; existingCDF.SDASMTable = clientDefinedField.Table; existingCDF.SDASMField = clientDefinedField.Field; existingCDF.SDASMFieldType = clientDefinedField.Format; existingCDF.SDARangeName = clientDefinedField.SDARangeName; } result = sdaCloudEntities.SaveChanges(); if (result > 0) { var client = sdaCloudEntities.Clients.FirstOrDefault(o => o.ClientID == clientDefinedField.ClientID); if (client != null) { client.CRMXrefUpdDT = DateTime.Now; sdaCloudEntities.SaveChanges(); } } transactionScope.Complete(); } } return(result); }
/// <summary> /// </summary> /// <param name="clientId"></param> /// <param name="fileName"></param> /// <param name="AWSFilePath"></param> /// <param name="AWSFileName"></param> /// <param name="DBFileUpdDT"></param> /// <param name="DBUploadedDt"></param> /// <returns></returns> public ClientUpdateDBDto UpdateClientUpdateDB(int ClientId, string FileName, string AWSID, string AWSFilePath, string AWSFileName, string DBFileUpdDT, string DBUploadedDt, bool BetaVersion, int UploaderClientID, int UploaderUserID, string UploaderUserName) { ClientUpdateDBDto clientBase = null; using (var sdaCloudEntities = new SDACloudEntities()) { using (sdaCloudEntities) { ClientUpdateDB client = sdaCloudEntities.ClientUpdateDBs .Where(i => i.ClientID == ClientId && i.DBFileName == FileName) .FirstOrDefault(); if (client != null) { if (!BetaVersion) { client.AWSFlePath = AWSFilePath; client.AWSFileName = AWSFileName; client.AWSFileID = AWSID; client.DBFileUpdDT = DateTime.Parse(DBFileUpdDT); client.DBUploadedDT = DateTime.Parse(DBUploadedDt); } else { client.BetaAwsFilePath = AWSFilePath; client.BetaAWSFileName = AWSFileName; client.BetaAWSFileID = AWSID; client.BetaDBFileUpdDT = DateTime.Parse(DBFileUpdDT); client.BetaUploaderClientID = UploaderClientID; client.BetaUploaderUserID = UploaderUserID; client.BetaUploaderUserName = UploaderUserName; } client.UploaderClientID = UploaderClientID; client.UploaderUserID = UploaderUserID; client.UploaderUserName = UploaderUserName; Mapper.CreateMap <ClientUpdateDB, ClientUpdateDBDto>(); if (client != null) { clientBase = Mapper.Map <ClientUpdateDB, ClientUpdateDBDto>(client); Mapper.AssertConfigurationIsValid(); } sdaCloudEntities.SaveChanges(); } } } return(clientBase); }
/// <summary> /// Deletes the user. /// </summary> /// <param name="userId">The user identifier.</param> /// <returns></returns> public int DeleteUser(int userId) { int result; using (var sdaCloudEntities = new SDACloudEntities()) { var existinguser = sdaCloudEntities.Users.FirstOrDefault(i => i.UserID == userId); if (existinguser != null) { existinguser.DeleteInd = "Y"; } result = sdaCloudEntities.SaveChanges(); } return(result); }
public string DeleteCDFs(string uList) { string result = string.Empty; using (var sdaCloudEntities = new SDACloudEntities()) { List <string> tagIds = uList.Split(',').ToList(); var clientDefinedFields = new List <ClientDefinedField>(); foreach (var uv in tagIds) { int uvId; Int32.TryParse(uv, out uvId); var clientDefinedField = sdaCloudEntities.ClientDefinedFields.Where(q => q.ClientDefinedFieldID == uvId).SingleOrDefault(); if (clientDefinedField != null) { clientDefinedFields.Add(clientDefinedField); } else { if (!string.IsNullOrEmpty(result)) { result += ","; } result += uv; } } foreach (var cdf in clientDefinedFields) { Mapper.CreateMap <ClientDefinedField, ClientDefinedFieldDto>(); var existingCDF = Mapper.Map <ClientDefinedField, ClientDefinedFieldDto>(cdf); ////Mapper.AssertConfigurationIsValid(); InterfaceXRefDL interfaceXrefDL = new InterfaceXRefDL(); var deleted = interfaceXrefDL.DeleteInterfaceXRef(existingCDF); if (deleted >= 0) { //check this //sdaCloudEntities.DeleteObject(cdf); } } sdaCloudEntities.SaveChanges(); } return(result); }
/// <summary> /// Adds the error message. /// </summary> /// <param name="clientId">The client identifier.</param> /// <param name="errorMessage">The error message.</param> /// <param name="record">The record.</param> public bool AddErrorMessage(int clientId, string errorMessage, string record) { bool result = false; using (var sdaCloudEntities = new SDACloudEntities()) { using (sdaCloudEntities) { using (var transactionScope = new TransactionScope()) { var existingError = sdaCloudEntities.ErrorLogs.FirstOrDefault( i => i.ClientID == clientId && i.ErrorMessage.Trim().ToUpper().Equals(errorMessage.Trim().ToUpper()) && i.Record.Trim().ToUpper().Equals(record.Trim().ToUpper())); if (existingError != null) { existingError.ProcessDT = DateTime.UtcNow; if (!string.IsNullOrEmpty(existingError.NoLongerSend) && existingError.NoLongerSend.Equals("Y")) { result = true; } } else { var errorLog = new ErrorLog { ClientID = clientId, ErrorMessage = errorMessage, Record = record, ProcessDT = DateTime.UtcNow }; sdaCloudEntities.ErrorLogs.AddObject(errorLog); } sdaCloudEntities.SaveChanges(); transactionScope.Complete(); } } } return(result); }
public int UpdateCDFField(int cdfId, string field, string newValue) { int result = 0; using (var sdaCloudEntities = new SDACloudEntities()) { using (sdaCloudEntities) { using (var transactionScope = new TransactionScope()) { var existingCDF = sdaCloudEntities.ClientDefinedFields.FirstOrDefault(i => i.ClientDefinedFieldID == cdfId); if (existingCDF != null) { Type t = existingCDF.GetType(); PropertyInfo info = t.GetProperty(field); if (info == null) { return(-1); } if (!info.CanWrite) { return(-1); } info.SetValue(existingCDF, newValue, null); result = sdaCloudEntities.SaveChanges(); Mapper.CreateMap <ClientDefinedField, ClientDefinedFieldDto>(); var cDF = Mapper.Map <ClientDefinedField, ClientDefinedFieldDto>(existingCDF); ////Mapper.AssertConfigurationIsValid(); InterfaceXRefDL interfaceXrefDL = new InterfaceXRefDL(); var interfaceXrefId = interfaceXrefDL.UpdateInterfaceXRef(cDF); } transactionScope.Complete(); } } } return(result); }
public void UpdateUserLastCheckDT(int userID, int clientID) { using (var sdaCloudEntities = new SDACloudEntities()) { using (var transactionScope = new TransactionScope()) { var existingUsers = sdaCloudEntities.Users.FirstOrDefault(i => i.ClientID == clientID && i.UserID == userID); if (existingUsers != null) { existingUsers.LastCheckDT = DateTime.UtcNow; sdaCloudEntities.SaveChanges(); } transactionScope.Complete(); } } }
/// <summary> /// Deletes the quotes. /// </summary> /// <param name="quoteIdList">The quote identifier list.</param> /// <param name="opportunityIdList">The opportunity identifier list.</param> /// <returns></returns> public int DeleteQuotes(string quoteIdList, ref List <int?> opportunityIdList) { int result; using (var sdaCloudEntities = new SDACloudEntities()) { List <string> tagIds = quoteIdList.Split(',').ToList(); List <Quote> quotes = sdaCloudEntities.Quotes.Where(q => tagIds.Contains(q.QuoteID)).ToList(); foreach (Quote quote in quotes) { opportunityIdList.Add(quote.OppID); quote.DeleteInd = "Y"; } result = sdaCloudEntities.SaveChanges(); } return(result); }
/// <summary> /// Deletes a list of users. /// </summary> /// <param name="uList">The user list.</param> /// <returns></returns> public string DeleteUsers(string uList) { string result = string.Empty; using (var sdaCloudEntities = new SDACloudEntities()) { List <string> tagIds = uList.Split(',').ToList(); var users = new List <User>(); foreach (var uv in tagIds) { int uvId; Int32.TryParse(uv, out uvId); var userView = sdaCloudEntities.Users.Where(q => q.UserID == uvId).SingleOrDefault(); if (userView != null) { var isManager = sdaCloudEntities.Users.Where(q => q.ClientID == userView.ClientID && q.ManagerUserID == uvId && (q.DeleteInd == null || q.DeleteInd != "Y")).ToList(); if (isManager.Count < 1) { userView.DeleteInd = "Y"; } else { if (!string.IsNullOrEmpty(result)) { result += ","; } result += uv; } } else { if (!string.IsNullOrEmpty(result)) { result += ","; } result += uv; } } sdaCloudEntities.SaveChanges(); } return(result); }
/// <summary> /// </summary> /// <param name="UserMachineDataDto"></param> /// <returns></returns> public int UpdateUserMachineData(UserMachineDataDto UserMachineDataDto) { int result = 0; try { using (var sdaCloudEntities = new SDACloudEntities()) { using (var transactionScope = new TransactionScope()) { var existingEntity = sdaCloudEntities .UserMachineDatas .Where(i => i.ClientID == UserMachineDataDto.ClientID && i.UserID == UserMachineDataDto.UserID && i.WindowsUserName.Equals(UserMachineDataDto.WindowsUserName) && i.MACAddress.Equals(UserMachineDataDto.MACAddress)) .FirstOrDefault(); if (existingEntity != null) { existingEntity.VersionDotNet = UserMachineDataDto.VersionDotNet; existingEntity.VersionExcel = UserMachineDataDto.VersionExcel; existingEntity.VersionWord = UserMachineDataDto.VersionWord; existingEntity.VersionSDA = UserMachineDataDto.VersionSDA; existingEntity.VersionSalesManager = UserMachineDataDto.VersionSalesManager; existingEntity.VersionWindows = UserMachineDataDto.VersionWindows; existingEntity.InstallType = UserMachineDataDto.InstallType; existingEntity.UserName = UserMachineDataDto.UserName; existingEntity.Email = UserMachineDataDto.Email; existingEntity.Company = UserMachineDataDto.Company; existingEntity.Title = UserMachineDataDto.Title; existingEntity.Phone = UserMachineDataDto.Phone; existingEntity.UserTimeZone = UserMachineDataDto.UserTimeZone; existingEntity.LastUpdDT = DateTime.UtcNow; result = sdaCloudEntities.SaveChanges(); transactionScope.Complete(); } } } } catch (Exception e) { throw new Exception(e.Message); } return(result); }
/// <summary> /// Reassigns the quotes. /// </summary> /// <param name="quoteIdList">The quote identifier list.</param> /// <param name="newOpportunityID">The new opportunity identifier.</param> /// <param name="newCRMOppID">The new CRM opp identifier.</param> /// <param name="opportunityIdList">The opportunity identifier list.</param> /// <returns></returns> public int ReassignQuotes(int clientId, string quoteIdList, int newOpportunityID, string newCRMOppID, ref List <int?> opportunityIdList) { int result; using (var sdaCloudEntities = new SDACloudEntities()) { List <string> tagIds = quoteIdList.Split(',').ToList(); List <Quote> quotes = sdaCloudEntities.Quotes.Where(q => tagIds.Contains(q.QuoteID) && q.ClientID == clientId).ToList(); foreach (Quote quote in quotes) { opportunityIdList.Add(quote.OppID); quote.OppID = newOpportunityID; quote.CRMOppID = newCRMOppID; } result = sdaCloudEntities.SaveChanges(); } return(result); }
/// <summary> /// Updates the user. /// </summary> /// <param name="userDto">The user dto.</param> /// <returns></returns> public int UpdateUserLastCheckDT(UserDto userDto) { int result; using (var sdaCloudEntities = new SDACloudEntities()) { using (var transactionScope = new TransactionScope()) { //&& i.ClientID == userDto.ClientId maybe not var existingUser = sdaCloudEntities.Users.FirstOrDefault(i => i.UserID == userDto.UserId); if (existingUser != null) { existingUser.CloudLastUpdBy = userDto.UserId; existingUser.LastCheckDT = DateTime.UtcNow; existingUser.CloudLastUpdDT = DateTime.UtcNow; } result = sdaCloudEntities.SaveChanges(); transactionScope.Complete(); } } return(result); }
/// <summary> /// Updates the quote rollup. /// </summary> /// <param name="quoteID">The quote identifier.</param> /// <param name="rollup">The rollup.</param> /// <returns></returns> public int UpdateQuoteRollup(string quoteID, string rollup) { int result; using (var sdaCloudEntities = new SDACloudEntities()) { using (sdaCloudEntities) { using (var transactionScope = new TransactionScope()) { var existingQuote = sdaCloudEntities.Quotes.FirstOrDefault(i => i.QuoteID == quoteID); if (existingQuote != null) { existingQuote.Rollup = rollup; } result = sdaCloudEntities.SaveChanges(); transactionScope.Complete(); } } } return(result); }
/// <summary> /// Updates the user view. /// </summary> /// <param name="userView">The user view.</param> /// <returns></returns> public int UpdateUserView(UserViewDto userView) { int result; using (var sdaCloudEntities = new SDACloudEntities()) { using (var transactionScope = new TransactionScope()) { UserView exist; if (userView.UserViewID != 0) { exist = sdaCloudEntities.UserViews.SingleOrDefault(u => u.UserViewID == userView.UserViewID); } else { exist = sdaCloudEntities.UserViews.SingleOrDefault( i => i.UserID == userView.UserID && i.ClientID == userView.ClientID && i.ViewName.ToUpper().Trim().Equals(userView.ViewName.ToUpper().Trim())); } if (exist != null) { exist.View = userView.View; sdaCloudEntities.SaveChanges(); result = exist.UserViewID; transactionScope.Complete(); } else { result = 0; } } } return(result); }
public int updateEmailRequested(String email) { email = email.ToLower(); int result; using (var sdaCloudEntities = new SDACloudEntities()) { using (var transactionScope = new TransactionScope()) { var existingUser = sdaCloudEntities.Users.FirstOrDefault(i => i.LoginID == email); if (existingUser != null) { existingUser.EmailSent = "Requested"; } result = sdaCloudEntities.SaveChanges(); transactionScope.Complete(); string ServiceName = Utilitary.GetConfigurationVariable("EmailService"); Utilitary.IsServiceIsRunning(ServiceName); } } return(result); }