public static void CreateMemberDocument(CMSDataContext db, CMSImageDataContext idb, string docname, int orgId, Person person, HttpPostedFileBase file)
{
string docName = $"{docname}_{person.LastName}_{person.FirstName}_{person.PeopleId}";
var document = db.OrgMemberDocuments.SingleOrDefault(o => o.DocumentName == docName & o.PeopleId == person.PeopleId & o.OrganizationId == orgId);
if (document != null)
{
db.OrgMemberDocuments.DeleteOnSubmit(document);
Image.Delete(idb, document.ImageId);
db.SubmitChanges();
}
int imageId = DocumentsData.StoreImageFromDocument(idb, file);
db.OrgMemberDocuments.InsertOnSubmit(new OrgMemberDocument()
{
DocumentName = docName,
ImageId = imageId,
PeopleId = person.PeopleId,
OrganizationId = orgId,
CreatedDate = DateTime.Now
});
db.SubmitChanges();
}
public static void CreateTemporaryDocument(CMSDataContext db, CMSImageDataContext idb, string docname, int orgId, string emailAddress, string lastName, string firstName, HttpPostedFileBase file)
{
var document = db.OrgTemporaryDocuments.SingleOrDefault(o => o.DocumentName == docname & o.LastName == lastName & o.FirstName == firstName & o.EmailAddress == emailAddress);
if (document != null)
{
db.OrgTemporaryDocuments.DeleteOnSubmit(document);
Image.Delete(idb, document.ImageId);
db.SubmitChanges();
}
int imageId = DocumentsData.StoreImageFromDocument(idb, file);
db.OrgTemporaryDocuments.InsertOnSubmit(new OrgTemporaryDocuments()
{
DocumentName = docname,
ImageId = imageId,
LastName = lastName,
FirstName = firstName,
EmailAddress = emailAddress,
OrganizationId = orgId,
CreatedDate = DateTime.Now
});
db.SubmitChanges();
}