public static bool IsValidToken(string token)
{
using (THEntities db = new THEntities())
{
string encryptToken = EncryptString(token);
return(db.sys_user.Any(r => r.user_Deleted == null && r.token == encryptToken));
}
}
//-- Save upload document --//
public static async Task <List <sm_doc> > SaveUploadImage(THEntities db, string documentName, int tableID, int recordID, List <string> base64)
{
List <sm_doc> documents = new List <sm_doc>();
if (base64 != null)
{
foreach (var image in base64)
{
using (MemoryStream ms = new MemoryStream(Convert.FromBase64String(image)))
{
string pathForSavingToDB = "", imageNameForSavingToDB = "";
using (Bitmap bm = new Bitmap(ms))
{
string path = "";
string uploadFolderName = "uploads";
path = HttpContext.Current.Server.MapPath(@"~\" + uploadFolderName);
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
string currentYear = DateTime.Now.Year.ToString();
path += @"\" + currentYear;
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
string currentMonth = DateTime.Now.Month > 9 ? DateTime.Now.Month.ToString() : "0" + DateTime.Now.Month;
path += @"\" + currentMonth;
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
var createImageUniqueName = recordID + "_" + DateTime.Now.ToString("yyyy-MM-dd_HHmmssfff") + ".jpg";
bm.Save(path + @"\" + createImageUniqueName);
imageNameForSavingToDB = documentName + "_" + createImageUniqueName;
pathForSavingToDB = uploadFolderName + "/" + currentYear + "/" + currentMonth + "/" + createImageUniqueName;
}
var document = new sm_doc();
document.name = imageNameForSavingToDB;
document.tableID = tableID;
document.docs_CreatedDate = DateTime.Now;
document.value = recordID.ToString();
document.path = pathForSavingToDB;
db.sm_doc.Add(document);
await db.SaveChangesAsync();
documents.Add(document);
}
}
}
return(documents);
}
public static UserProfileViewDTO GetUserProfile(string token)
{
using (THEntities db = new THEntities())
{
string encryptToken = EncryptString(token);
var user = db.sys_user.FirstOrDefault(x => x.user_Deleted == null && x.token == encryptToken);
UserProfileViewDTO userProfile = MapDBClassToDTO <sys_user, UserProfileViewDTO>(user);
return(userProfile);
}
}
public static async Task <List <sm_doc> > SaveUploadImage(THEntities db, int tableID, int recordID, List <string> base64)
{
List <sm_doc> documents = new List <sm_doc>();
if (base64 != null)
{
foreach (var image in base64)
{
using (MemoryStream ms = new MemoryStream(Convert.FromBase64String(image)))
{
string pathForSavingToDB = "", imageNameForSavingToDB = "";
using (Bitmap bm = new Bitmap(ms))
{
//string path = "";
string year = DateTime.Now.Year.ToString();
string month = DateTime.Now.Month > 9 ? DateTime.Now.Month.ToString() : "0" + DateTime.Now.Month;
/*
* path = ConstantHelper.UPLOAD_FOLDER + @"\" + year + @"\" + month;
* path = HttpContext.Current.Server.MapPath(@"~\" + path);
* if (!Directory.Exists(path))
* Directory.CreateDirectory(path);
* var createImageUniqueName = $"{tableID}_{recordID}_{DateTime.Now.ToString("yyyy-MM-dd_HH-mm-ss-fff")}.jpg";
* bm.Save(path + @"\" + createImageUniqueName);
* bm.Save(@"C:\uploads\" + createImageUniqueName);
*/
var createImageUniqueName = $"{tableID}_{recordID}_{DateTime.Now.ToString("yyyy-MM-dd_HH-mm-ss-fff")}.jpg";
var uploadPath = WebConfigurationManager.AppSettings["uploadPath"].ToString();
uploadPath += ConstantHelper.UPLOAD_FOLDER + @"\" + year + @"\" + month;
if (!Directory.Exists(uploadPath))
{
Directory.CreateDirectory(uploadPath);
}
bm.Save(uploadPath + @"\" + createImageUniqueName);
imageNameForSavingToDB = createImageUniqueName;
pathForSavingToDB = $"{ConstantHelper.UPLOAD_FOLDER}/{year}/{month}/{createImageUniqueName}";
}
var document = new sm_doc();
document.name = imageNameForSavingToDB;
document.tableID = tableID;
document.docs_CreatedDate = DateTime.Now;
document.value = recordID.ToString();
document.path = pathForSavingToDB;
db.sm_doc.Add(document);
await db.SaveChangesAsync();
documents.Add(document);
}
}
}
return(documents);
}
//-> Get Document
public static List <DocumentViewDTO> GetDocuments(THEntities db, int tableID, int value)
{
List <DocumentViewDTO> documentViews = new List <DocumentViewDTO>();
IQueryable <sm_doc> documents = from d in db.sm_doc
where d.docs_Deleted == null && d.tableID == tableID && d.value == value.ToString()
orderby d.id ascending
select d;
foreach (var document in documents)
{
var mappingDTO = MappingHelper.MapDBClassToDTO <sm_doc, DocumentViewDTO>(document);
//documentViews.Add(MappingHelper.MapDBClassToDTO<sm_doc, DocumentViewDTO>(document));
mappingDTO.path = WebConfigurationManager.AppSettings["baseURL"].ToString() + mappingDTO.path;
documentViews.Add(mappingDTO);
}
return(documentViews);
}
public ItemGroupRepository()
{
db = new THEntities();
}
public SaleOrderRepository()
{
db = new THEntities();
}
public UserRepository()
{
db = new THEntities();
}
public SlideShowRepository()
{
db = new THEntities();
}
public CustomerRepository()
{
db = new THEntities();
}
public DocumentRepository()
{
db = new THEntities();
}
public WarehouseRepository()
{
db = new THEntities();
}
public invoiceRepo()
{
db = new THEntities();
}
