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