/// <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); }