public response Delete(int _id)
{
//DocumentScanat item = JsonConvert.DeserializeObject<DocumentScanat>(Find(_id).Message);
DocumentScanat item = (DocumentScanat)(Find(_id).Result);
return(item.Delete());
}
public static void DeleteThumbNail(Models.DocumentScanat d)
{
try {
if (File.Exists(Path.Combine(AppContext.BaseDirectory, "scans", d.DENUMIRE_FISIER.Replace(d.EXTENSIE_FISIER, "_Custom.jpg"))))
{
File.Delete(Path.Combine(AppContext.BaseDirectory, "scans", d.DENUMIRE_FISIER.Replace(d.EXTENSIE_FISIER, "_Custom.jpg")));
}
} catch { }
try
{
if (File.Exists(Path.Combine(AppContext.BaseDirectory, "scans", d.DENUMIRE_FISIER.Replace(d.EXTENSIE_FISIER, "_Medium.jpg"))))
{
File.Delete(Path.Combine(AppContext.BaseDirectory, "scans", d.DENUMIRE_FISIER.Replace(d.EXTENSIE_FISIER, "_Medium.jpg")));
}
}
catch { }
try
{
if (File.Exists(Path.Combine(AppContext.BaseDirectory, "scans", d.DENUMIRE_FISIER.Replace(d.EXTENSIE_FISIER, "_Small.jpg"))))
{
File.Delete(Path.Combine(AppContext.BaseDirectory, "scans", d.DENUMIRE_FISIER.Replace(d.EXTENSIE_FISIER, "_Small.jpg")));
}
}
catch { }
}
public response GetAll()
{
try
{
DataAccess da = new DataAccess(authenticatedUserId, connectionString, CommandType.StoredProcedure, "DOCUMENTE_SCANATEsp_select", new object[] {
new MySqlParameter("_SORT", null),
new MySqlParameter("_ORDER", null),
new MySqlParameter("_FILTER", null),
new MySqlParameter("_LIMIT", null)
});
ArrayList aList = new ArrayList();
MySqlDataReader r = da.ExecuteSelectQuery();
while (r.Read())
{
DocumentScanat a = new DocumentScanat(authenticatedUserId, connectionString, (IDataRecord)r);
aList.Add(a);
}
r.Close(); r.Dispose();
DocumentScanat[] toReturn = new DocumentScanat[aList.Count];
for (int i = 0; i < aList.Count; i++)
{
toReturn[i] = (DocumentScanat)aList[i];
}
return(new response(true, JsonConvert.SerializeObject(toReturn, CommonFunctions.JsonSerializerSettings), toReturn, null, null));
}
catch (Exception exp) { LogWriter.Log(exp); return(new response(false, exp.ToString(), null, null, new System.Collections.Generic.List <Error>()
{
new Error(exp)
})); }
}
public response RestoreOrphanDocument(int _id)
{
DocumentScanat item = (DocumentScanat)(Find(_id).Result);
bool toReturn = FileManager.RestoreFileFromDb(item);
return(new response(toReturn, "", toReturn, null, null));
}
public response Update(string fieldValueCollection)
{
DocumentScanat tmpItem = JsonConvert.DeserializeObject <DocumentScanat>(fieldValueCollection);
//return JsonConvert.DeserializeObject<DocumentScanat>(Find(Convert.ToInt32(tmpItem.ID)).Message).Update(fieldValueCollection);
return(((DocumentScanat)(Find(Convert.ToInt32(tmpItem.ID)).Result)).Update(fieldValueCollection));
}
public response Update(int id, string fieldValueCollection)
{
//DocumentScanat item = JsonConvert.DeserializeObject<DocumentScanat>(Find(id).Message);
DocumentScanat item = (DocumentScanat)(Find(id).Result);
return(item.Update(fieldValueCollection));
}
public response Update(int id, string fieldValueCollection, object file)
{
DocumentScanat item = JsonConvert.DeserializeObject <DocumentScanat>(Find(id).Message);
byte[] f = GetBytesFromParameter(file);
item.FILE_CONTENT = f;
item.DIMENSIUNE_FISIER = item.FILE_CONTENT.Length;
return(item.Update(fieldValueCollection));
}
public response Update(string fieldValueCollection, object file)
{
DocumentScanat tmpItem = JsonConvert.DeserializeObject <DocumentScanat>(fieldValueCollection);
//DocumentScanat item = JsonConvert.DeserializeObject<DocumentScanat>(Find(Convert.ToInt32(tmpItem.ID)).Message);
DocumentScanat item = (DocumentScanat)(Find(Convert.ToInt32(tmpItem.ID)).Result);
byte[] f = GetBytesFromParameter(file);
item.FILE_CONTENT = f;
item.DIMENSIUNE_FISIER = item.FILE_CONTENT.Length;
return(item.Update(fieldValueCollection));
}
public response Find(int _id)
{
try
{
DocumentScanat item = new DocumentScanat(authenticatedUserId, connectionString, _id);
return(new response(true, JsonConvert.SerializeObject(item, CommonFunctions.JsonSerializerSettings), item, null, null));;
}
catch (Exception exp) { LogWriter.Log(exp); return(new response(false, exp.ToString(), null, null, new System.Collections.Generic.List <Error>()
{
new Error(exp)
})); }
}
public static bool RestoreFileFromDb(Models.DocumentScanat ds)
{
try
{
FileStream fs = new FileStream(Path.Combine(CommonFunctions.GetScansFolder(), ds.CALE_FISIER), FileMode.Create, FileAccess.ReadWrite);
fs.Write(ds.FILE_CONTENT, 0, ds.FILE_CONTENT.Length);
fs.Flush();
fs.Dispose();
return(true);
// to do - restore thumbnails
}catch (Exception exp) { LogWriter.Log(exp); return(false); }
}
public response GetFiltered(string _sort, string _order, string _filter, string _limit)
{
try
{
try
{
string newFilter = Filtering.GenerateFilterFromJsonObject(typeof(DocumentScanat), _filter, authenticatedUserId, connectionString);
_filter = newFilter == null ? _filter : newFilter;
}
catch { }
DataAccess da = new DataAccess(authenticatedUserId, connectionString, CommandType.StoredProcedure, "DOCUMENTE_SCANATEsp_select", new object[] {
new MySqlParameter("_SORT", _sort),
new MySqlParameter("_ORDER", _order),
new MySqlParameter("_FILTER", _filter),
new MySqlParameter("_LIMIT", _limit)
});
/*
* ArrayList aList = new ArrayList();
* MySqlDataReader r = da.ExecuteSelectQuery();
* while (r.Read())
* {
* DocumentScanat a = new DocumentScanat(authenticatedUserId, connectionString, (IDataRecord)r);
* aList.Add(a);
* }
* r.Close(); r.Dispose(); da.CloseConnection();
* DocumentScanat[] toReturn = new DocumentScanat[aList.Count];
* for (int i = 0; i < aList.Count; i++)
* toReturn[i] = (DocumentScanat)aList[i];
* return new response(true, JsonConvert.SerializeObject(toReturn, CommonFunctions.JsonSerializerSettings), toReturn, null, null);
*/
List <DocumentScanat> aList = new List <DocumentScanat>();
MySqlDataReader r = da.ExecuteSelectQuery();
while (r.Read())
{
DocumentScanat a = new DocumentScanat(authenticatedUserId, connectionString, (IDataRecord)r);
aList.Add(a);
}
r.Close(); r.Dispose(); da.CloseConnection();
return(new response(true, JsonConvert.SerializeObject(aList.ToArray(), CommonFunctions.JsonSerializerSettings), aList.ToArray(), null, null));
}
catch (Exception exp) { LogWriter.Log(exp); return(new response(false, exp.ToString(), null, null, new System.Collections.Generic.List <Error>()
{
new Error(exp)
})); }
}
public static byte[] GenerateImgThumbNail(Models.DocumentScanat _documentScanat, ThumbNailSizes s)
{
MemoryStream ms = new MemoryStream(_documentScanat.FILE_CONTENT);
Image image = Image.FromStream(ms);
string tmp_file = "tmp_" + DateTime.Now.ToString();
response r = SaveThumbNail(ThumbNailType.Custom.ToString(), Path.Combine(AppContext.BaseDirectory, "scans"), tmp_file, image, s.Width, s.Height);
FileStream fs = new FileStream(Path.Combine(AppContext.BaseDirectory, "scans", r.Message), FileMode.Open, FileAccess.Read);
byte[] b = new byte[fs.Length];
fs.Read(b, 0, (int)fs.Length);
fs.Dispose();
try
{
File.Delete(Path.Combine(AppContext.BaseDirectory, "scans", tmp_file));
}
catch { }
return(b);
}
/// <summary>
/// Metoda pentru stergerea Documentului scanat curent
/// </summary>
/// <returns>SOCISA.response = new object(bool = status, string = error message, int = id-ul cheie returnat)</returns>
public response Delete()
{
DocumentScanat tmp = new DocumentScanat(authenticatedUserId, connectionString, Convert.ToInt32(this.ID));
response toReturn = new response(false, "", null, null, new List <Error>());;
ArrayList _parameters = new ArrayList();
_parameters.Add(new MySqlParameter("_ID", this.ID));
DataAccess da = new DataAccess(authenticatedUserId, connectionString, CommandType.StoredProcedure, "DOCUMENTE_SCANATEsp_soft_delete", _parameters.ToArray());
toReturn = da.ExecuteDeleteQuery();
/*
* if (toReturn.Status && _deleteFile)
* FileManager.DeleteFile(this.CALE_FISIER, this.DENUMIRE_FISIER, this.EXTENSIE_FISIER);
*/
if (toReturn.Status)
{
try
{
ThumbNails.DeleteThumbNail(tmp);
tmp = null;
}
catch { }
}
if (toReturn.Status)
{
/*
* try
* {
* if (System.Web.HttpContext.Current.Request.Params["SEND_MESSAGE"] != null && Convert.ToBoolean(System.Web.HttpContext.Current.Request.Params["SEND_MESSAGE"]))
* Mesaje.GenerateAndSendMessage(this.ID, DateTime.Now, "Document sters", Convert.ToInt32(System.Web.HttpContext.Current.Session["AUTHENTICATED_ID"]), (int)Mesaje.Importanta.Low);
* }
* catch { }
*/
try
{
Dosar d = new Dosar(authenticatedUserId, connectionString, this.ID_DOSAR);
d.UpdateCounterDocumente(-1);
}
catch (Exception exp) { LogWriter.Log(exp); }
}
return(toReturn);
}
public response Update(int id, string fieldValueCollection, object file, ThumbNailSizes[] tSizes)
{
//DocumentScanat item = JsonConvert.DeserializeObject<DocumentScanat>(Find(id).Message);
DocumentScanat item = (DocumentScanat)(Find(id).Result);
byte[] f = GetBytesFromParameter(file);
item.FILE_CONTENT = f;
item.DIMENSIUNE_FISIER = item.FILE_CONTENT.Length;
response r = item.Update(fieldValueCollection);
if (r.Status)
{
r = item.Update(tSizes);
return(r);
}
else
{
return(r);
}
}
public response RestoreOrphanDocument(int _id)
{
DocumentScanat item = (DocumentScanat)(Find(_id).Result);
return(FileManager.RestoreFileFromDb(item));
}
public response GenerateThumbNails(DocumentScanat item, ThumbNailSizes[] tSizes)
{
return(item.GenerateImgThumbNails(tSizes));
}
public response GetChildren(DocumentScanat item, string tableName, int childrenId)
{
return(item.GetChildren(tableName, childrenId));
}
public response GetChildrens(DocumentScanat item, string tableName)
{
return(item.GetChildrens(tableName));
}
public response Update(DocumentScanat item)
{
return(item.Update());
}
public response Insert(DocumentScanat item)
{
return(item.Insert());
}
public response Insert(DocumentScanat item, ThumbNailSizes[] tSizes)
{
return(item.Insert(tSizes));
}
public response Insert(DocumentScanat item, object file)
{
item.FILE_CONTENT = GetBytesFromParameter(file);
item.DIMENSIUNE_FISIER = item.FILE_CONTENT.Length;
return(item.Insert());
}
public response Update(DocumentScanat item, object file, ThumbNailSizes[] tSizes)
{
item.FILE_CONTENT = GetBytesFromParameter(file);
item.DIMENSIUNE_FISIER = item.FILE_CONTENT.Length;
return(item.Update(tSizes));
}
public response Update(DocumentScanat item, ThumbNailSizes[] tSizes)
{
return(item.Update(tSizes));
}
public static byte[] GenerateImgThumbNail(int _authenticatedUserId, string _connectionString, int _idDocumentScanat, ThumbNailSizes s)
{
Models.DocumentScanat d = (Models.DocumentScanat)(new Models.DocumenteScanateRepository(_authenticatedUserId, _connectionString).Find(_idDocumentScanat).Result);
return(GenerateImgThumbNail(d, s));
}
public response Delete(DocumentScanat item)
{
return(item.Delete());
}
public static void CreateArhiveEntryWithSignature(Models.DocumentScanat ds)
{
}
public response Insert(DocumentScanat item, object file, ThumbNailSizes[] tSizes)
{
item.FILE_CONTENT = GetBytesFromParameter(file);
return(item.Insert(tSizes));
}