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);
}