/// <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> /// </summary> /// <param name="clientId"></param> /// <param name="dbName"></param> /// <returns></returns> public ClientUpdateDBDto GetLastCloudDBFileUpdDT(int clientId, string dbName) { ClientUpdateDBDto clientUpdate = null; using (var sdaCloudEntities = new SDACloudEntities()) { ClientUpdateDB client = sdaCloudEntities.ClientUpdateDBs .Where(i => i.ClientID == clientId && i.DBFileName == dbName) .SingleOrDefault(); Mapper.CreateMap <ClientUpdateDB, ClientUpdateDBDto>(); if (client != null) { clientUpdate = Mapper.Map <ClientUpdateDB, ClientUpdateDBDto>(client); Mapper.AssertConfigurationIsValid(); } } return(clientUpdate); }