public JAFolder[] GetMainFolders(int pFolderType)
{
JDataBase DB = new JDataBase();
try
{
DB.setQuery("SELECT * FROM " + ClassLibrary.JTableNamesAutomation.Folders + " WHERE user_post_code=" + JMainFrame.CurrentPostCode.ToString()
+ " AND foldertype = " + pFolderType.ToString() + " AND (" + Folder.parent_code + "<1 OR " + Folder.parent_code + " IS NULL)");
DB.Query_DataReader();
JAFolder[] Folders = new JAFolder[0];
Array.Resize(ref Folders, DB.RecordCount);
int count = 0;
while (DB.DataReader.Read())
{
JAFolder folder = new JAFolder();
JTable.SetToClassProperty(folder, DB.DataReader);
Folders[count++] = folder;
}
return(Folders);
}
finally
{
DB.Dispose();
}
}
private void Set_form()
{
cmbPosts.DisplayMember = "Full_Title_Slim";
cmbPosts.ValueMember = "code";
DataTable _dt = (new Employment.JEOrganizationChart()).GetParents(JMainFrame.CurrentPostCode);
(_dt as JDataTable).Tidy("Full_Title", "Full_Title_Slim", 38);
cmbPosts.DataSource = _dt;
cmbObject.DisplayMember = "Text";
cmbObject.ValueMember = "Code";
cmbObject.DataSource = JObjects.GetDistinctObjects();
if (_Code != 0)
{
JAFolder tmpFolder = new JAFolder();
tmpFolder.GetData(_Code);
txtKartablName.Text = tmpFolder.Name;
txtObjectType.Text = tmpFolder.Subject;
cmbPosts.SelectedValue = tmpFolder.Sender_User_post_code;
cmbObject.SelectedValue = tmpFolder.Object_type;
}
}
private void FillTree()
{
JAFolder tmpJKartabl = new JAFolder();
DataTable dt = new DataTable();
dt = tmpJKartabl.GetKartablCondition(JMainFrame.CurrentPostCode);
if (dt != null)
{
DataRow dr;
dr = dt.NewRow();
dr["ID"] = "-1";
dr["full_title"] = "کارتابل";
//dr["parentcode"] = "";
dt.Rows.InsertAt(dr, 0);
jDataTreeView1.dtTree = dt.Copy();
jDataTreeView1.Title = "full_title";
jDataTreeView1.Code = "ID";
jDataTreeView1.ParentCode = "parentcode";
jDataTreeView1.CheckBox = false;
jDataTreeView1.CMenu = null;
jDataTreeView1.Refresh();
jDataTreeView1.TreeView.ImageList = JImageIcon.GetImageList(new System.Drawing.Size(24, 24));
jDataTreeView1.TreeView.ImageIndex = (int)JImageIndex.mail_48;
}
}
public void GetFolderRefer(int pFolderCode)
{
JAFolder Folder = new JAFolder(pFolderCode);
if (Folder.FolderType == JAFolderTypeEnum.Inbox.GetHashCode())
{
GetInBoxRefer(pFolderCode);
}
if (Folder.FolderType == JAFolderTypeEnum.SendItem.GetHashCode())
{
GetReferSend(pFolderCode);
}
}
private void JDefineKartabl_Load(object sender, EventArgs e)
{
if (_Code <= 0)
{
return;
}
JAFolder tmpJKartabl = new JAFolder(_Code);
txtKartablName.Text = tmpJKartabl.Name;
_Parent_code = tmpJKartabl.parent_code;
_Folder_Type = tmpJKartabl.FolderType;
txtObjectType.Text = tmpJKartabl.Subject;
chbDeleteFromKaratble.Checked = tmpJKartabl.DeleteFromKartable;
}
public void MoveToFolder(System.Data.DataRow pDR)
{
JFoldersListForm FFL = new JFoldersListForm(CurrentKartable.GetHashCode());
FFL.ShowDialog();
if (FFL.DialogResult == System.Windows.Forms.DialogResult.OK && FFL.CodeSelect > -1)
{
JReferFolder _Folder = new JReferFolder();
_Folder.ReferCode = (int)pDR["Code"];
_Folder.ReferFolderCode = FFL.CodeSelect;
_Folder.Insert();
JAFolder AF = new JAFolder(FFL.CodeSelect);
if (AF.DeleteFromKartable)
{
Nodes.Delete(Nodes.CurrentNode);
}
}
}
private void TsbDelete_Click(object sender, EventArgs e)
{
int i = 0;
SelectedItem = (DataRow)(((System.Windows.Forms.TreeNode)jDataTreeView1.SelectedItem).Tag);
JAFolder tmpJKartabls = new JAFolder();
i = Convert.ToInt32(((System.Data.DataRow)(((System.Windows.Forms.TreeNode)(jDataTreeView1.SelectedItem)).Tag)).ItemArray[0]);
if (i != -1)
{
if (tmpJKartabls.Delete(i))
{
FillTree();
}
else
{
JMessages.Message("Delete Not Completed", "Kartabl", JMessageType.Error);
}
}
}
private void btnConfirm_Click(object sender, EventArgs e)
{
JAFolder tmpJKartabl = new JAFolder();
int code = 0;
tmpJKartabl.Name = txtKartablName.Text;
tmpJKartabl.parent_code = _Parent_code;
tmpJKartabl.User_post_code = JMainFrame.CurrentPostCode;
tmpJKartabl.Create_Date_Time = JMainFrame.GlobalDataBase.GetCurrentDateTime();
tmpJKartabl.FolderType = _Folder_Type;
tmpJKartabl.Subject = txtObjectType.Text;
tmpJKartabl.DeleteFromKartable = chbDeleteFromKaratble.Checked;
if (cmbPosts.Enabled && cmbPosts.SelectedValue != null)
{
tmpJKartabl.Sender_User_post_code = (int)cmbPosts.SelectedValue;
}
else
{
tmpJKartabl.Sender_User_post_code = 0;
}
if (cmbObject.Enabled && cmbObject.SelectedValue != null)
{
tmpJKartabl.Object_type = (string)cmbObject.SelectedValue;
}
else
{
tmpJKartabl.Object_type = "";
}
if (State == JFormState.Insert)
{
code = tmpJKartabl.Insert();
if (code > 0)
{
JMessages.Message("Register Successfully", "Kartabl", JMessageType.Information);
this.Dispose();
}
else
{
JMessages.Message("Register Not Successfully", "Kartabl", JMessageType.Information);
}
}
else if (State == JFormState.Update)
{
tmpJKartabl.Code = _Code;
try
{
if (tmpJKartabl.Update())
{
JMessages.Message("Update Successfully", "Kartabl", JMessageType.Information);
this.Dispose();
}
else
{
JMessages.Message("Update Not Successfully", "Kartabl", JMessageType.Information);
}
}
catch (Exception ex)
{
JSystem.Except.AddException(ex);
JMessages.Message("Update Not Successfully", "Kartabl", JMessageType.Information);
}
}
}