public void DeleteFileUpload(long fileid, string updatedby)
{
using (var context = new EMSDataModel())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
var now = DateTime.Now;
var fileupload = new FILE_UPLOAD();
var Where = context.FILE_UPLOAD.Where(w => w.FILE_ID.Equals(fileid));
if (Where.Count() > 0)
{
fileupload = Where.FirstOrDefault();
fileupload.LASTMODIFIED_BY = updatedby;
fileupload.LASTMODIFIED_DATE = now;
fileupload.IS_ACTIVE = false;
context.SaveChanges();
}
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw this.HandleException("Exception occured on Manufacture License Change Request Delete File. See Inner Exception property to see details", ex);
}
finally
{
transaction.Dispose();
context.Dispose();
}
}
}
}
public bool SaveDocument(int formType, string formId, string url, string user, long?docId = null, bool isGovDocument = false)
{
try
{
var now = new DateTime();
FILE_UPLOAD file = new FILE_UPLOAD()
{
FORM_TYPE_ID = formType,
FORM_ID = formId,
PATH_URL = url,
UPLOAD_DATE = now,
CREATED_BY = user,
LASTMODIFIED_BY = user,
CREATED_DATE = now,
LASTMODIFIED_DATE = now,
DOCUMENT_ID = docId,
IS_GOVERNMENT_DOC = isGovDocument,
IS_ACTIVE = true
};
return(true);
}
catch (Exception ex)
{
throw this.HandleException("Exception occured on SystemReferenceService. See Inner Exception property to see details", ex);
}
}
public void InsertFileUpload(long CRId, string Path, string CreatedBy, long DocId, bool IsGovDoc, string FileName)
{
using (var context = new EMSDataModel())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
var now = DateTime.Now;
var UploadFile = new FILE_UPLOAD();
UploadFile.FORM_TYPE_ID = Convert.ToInt32(Enums.FormList.Change);
UploadFile.FORM_ID = CRId.ToString();
UploadFile.PATH_URL = Path;
UploadFile.UPLOAD_DATE = now;
UploadFile.CREATED_BY = CreatedBy;
UploadFile.CREATED_DATE = now;
UploadFile.LASTMODIFIED_BY = CreatedBy;
UploadFile.LASTMODIFIED_DATE = now;
if (DocId != 0)
{
UploadFile.DOCUMENT_ID = DocId;
}
UploadFile.IS_GOVERNMENT_DOC = IsGovDoc;
UploadFile.IS_ACTIVE = true;
UploadFile.FILE_NAME = FileName;
context.FILE_UPLOAD.Add(UploadFile);
context.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw this.HandleException("Exception occured on Manufacture License Interview Request Detail Upload File. See Inner Exception property to see details", ex);
}
finally
{
transaction.Dispose();
context.Dispose();
}
}
}
}
public FILE_UPLOAD CreateFileUpload(FILE_UPLOAD data)
{
using (var context = new EMSDataModel())
{
using (var transaction = context.Database.BeginTransaction())
{
try
{
context.FILE_UPLOAD.Add(data);
context.SaveChanges();
transaction.Commit();
}
catch (Exception ex)
{
transaction.Rollback();
throw this.HandleException("Exception occured on Brand Registration Service. See Inner Exception property to see details", ex);
}
}
}
return(data);
}
public void Save(FILE_UPLOAD file_upload)
{
_repository.InsertOrUpdate(file_upload);
}
