/// <summary>
/// حذف
/// </summary>
/// <returns></returns>
public bool Delete()
{
if (JPermission.CheckPermission("ArchivedDocuments.JRequestArchiveFile.Delete"))
{
JDataBase Db = new JDataBase();
JRequestArchiveFileTable PDT = new JRequestArchiveFileTable();
try
{
PDT.SetValueProperty(this);
if (PDT.Delete(Db))
{
return(true);
}
return(false);
}
catch (Exception ex)
{
JSystem.Except.AddException(ex);
return(false);
}
finally
{
PDT.Dispose();
Db.Dispose();
}
}
return(false);
}
/// <summary>
/// ویرایش
/// </summary>
/// <returns></returns>
public bool Update(JDataBase Db, bool Send)
{
if (JPermission.CheckPermission("ArchivedDocuments.JRequestArchiveFile.Update"))
{
JRequestArchiveFileTable PDT = new JRequestArchiveFileTable();
try
{
Db.beginTransaction("RequestArchiveFile");
PDT.SetValueProperty(this);
if (PDT.Update(Db))
{
if (Send)
{
if (!(SendConfirm(Db, 999)))
{
Db.Rollback("RequestArchiveFile");
JMessages.Error("Send Not Successfuly ", "");
}
else
{
if (Db.Commit())
{
//Nodes.DataTable.Merge(JVacationHours.GetDataTable(Code));
return(true);
}
}
}
else
{
if (Db.Commit())
{
return(true);
}
else
{
Db.Rollback("RequestArchiveFile");
return(false);
}
}
}
Db.Rollback("RequestArchiveFile");
return(false);
}
catch (Exception ex)
{
JSystem.Except.AddException(ex);
Db.Rollback("RequestArchiveFile");
return(false);
}
finally
{
if ((Send))
{
Db.Dispose();
}
PDT.Dispose();
}
}
return(false);
}
/// <summary>
/// وضعیت
/// </summary>
//public int Status { get; set; }
#endregion
#region method
/// <summary>
/// درج
/// </summary>
/// <returns></returns>
public int Insert(DataTable pArchiveList)
{
if (JPermission.CheckPermission("ArchivedDocuments.JRequestArchiveFile.Insert"))
{
JDataBase tempDb = new JDataBase();
JRequestArchiveFileTable JLT = new JRequestArchiveFileTable();
JRequestArchiveList tmpRequestArchiveList = new JRequestArchiveList();
JArchiveDocument tmpArchiveDocument = new JArchiveDocument();
try
{
tempDb.beginTransaction("JRequestArchiveFile");
JLT.SetValueProperty(this);
Code = JLT.Insert(tempDb);
if (Code > 0)
{
foreach (DataRow dr in pArchiveList.Rows)
{
tmpRequestArchiveList.RequestCode = Code;
tmpRequestArchiveList.ArchiveCode = Convert.ToInt32(dr["ArchiveCode"]);
if (dr["Confirm_Post_Code"].ToString() != "")
{
tmpRequestArchiveList.Confirm_Post_Code = Convert.ToInt32(dr["Confirm_Post_Code"].ToString());
}
tmpRequestArchiveList.Confirm_Full_Title = dr["Confirm_Full_Title"].ToString();
if (dr["Confirm_User_Code"].ToString() != "")
{
tmpRequestArchiveList.Confirm_User_Code = Convert.ToInt32(dr["Confirm_User_Code"].ToString());
}
tmpRequestArchiveList.Status = ClassLibrary.Domains.Employment.JVacationStatus.Request;// Convert.ToInt32(dr["Status"].ToString());
//if (dr["StartDate"].ToString() != "")
// tmpRequestArchiveList.StartDate = Convert.ToDateTime(dr["StartDate"]);
//if (dr["EndDate"].ToString() != "")
// tmpRequestArchiveList.EndDate = Convert.ToDateTime(dr["EndDate"]);
//tmpRequestArchiveList.Description = dr["Description"].ToString();
if (tmpRequestArchiveList.Insert(tempDb) < 1)
{
tempDb.Rollback("JRequestArchiveFile");
return(0);
}
tmpArchiveDocument.GetData(tmpRequestArchiveList.ArchiveCode);
if (tmpArchiveDocument.PlaceCode == 0)
{
tempDb.Rollback("JRequestArchiveFile");
JMessages.Error("مکان آرشیو این فایل تعیین نشده است ", "");
return(0);
}
if (!(SendConfirm(tempDb, tmpArchiveDocument.PlaceCode)))
{
tempDb.Rollback("JRequestArchiveFile");
JMessages.Error("Send Not Successfuly ", "");
return(0);
}
}
if (tempDb.Commit())
{
return(Code);
}
else
{
tempDb.Rollback("JRequestArchiveFile");
return(0);
}
}
else
{
return(0);
}
}
catch (Exception ex)
{
JSystem.Except.AddException(ex);
tempDb.Rollback("JRequestArchiveFile");
return(0);
}
finally
{
tempDb.Dispose();
JLT.Dispose();
tmpRequestArchiveList.Dispose();
tmpArchiveDocument.Dispose();
}
}
return(0);
}