private void GetExpensess()
{
dgvPrecuremenExp.Rows.Clear();
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtExpDate = cnn.GetDataTable("select p.swid," +
" p.people_id ,(select p_name from people where swid=p.people_id) people_name," +
" p.expenses_item_id,(select expenses_name from expenses_item where swid= expenses_item_id) ExpensessName," +
" expenses_value,MAIN_VALUE,STOCK_VALUE, " +
" journal_id, notes, document_no, add_to_cost," +
"(select curr_name from currency c where c.swid=p.EXP_CURRENCY_ID) exp_currency " +
" from procurement_expenses p " +
" where issued_id= " + txtISSUED_ID.Text +
" and issued_type='" + txtISSUED_TYPE.Text + "' ");
for (int i = 0; i < dtExpDate.Rows.Count; i++)
{
dgvPrecuremenExp.Rows.Add();
dgvPrecuremenExp[clmSwid.Index, dgvPrecuremenExp.Rows.Count - 1].Value = dtExpDate.Rows[i]["swid"].ToString();
dgvPrecuremenExp[clmPeopleId.Index, dgvPrecuremenExp.Rows.Count - 1].Value = dtExpDate.Rows[i]["people_id"].ToString();
dgvPrecuremenExp[clmPeopleName.Index, dgvPrecuremenExp.Rows.Count - 1].Value = dtExpDate.Rows[i]["people_name"].ToString();
dgvPrecuremenExp[clmExpensessId.Index, dgvPrecuremenExp.Rows.Count - 1].Value = dtExpDate.Rows[i]["expenses_item_id"].ToString();
dgvPrecuremenExp[clmExpensessName.Index, dgvPrecuremenExp.Rows.Count - 1].Value = dtExpDate.Rows[i]["ExpensessName"].ToString();
dgvPrecuremenExp[clmMainValue.Index, dgvPrecuremenExp.Rows.Count - 1].Value = dtExpDate.Rows[i]["MAIN_VALUE"].ToString();
dgvPrecuremenExp[clmStockValue.Index, dgvPrecuremenExp.Rows.Count - 1].Value = dtExpDate.Rows[i]["STOCK_VALUE"].ToString();
dgvPrecuremenExp[clmExpValue.Index, dgvPrecuremenExp.Rows.Count - 1].Value = dtExpDate.Rows[i]["expenses_value"].ToString();
dgvPrecuremenExp[clmAddToCost.Index, dgvPrecuremenExp.Rows.Count - 1].Value = dtExpDate.Rows[i]["add_to_cost"].ToString();
dgvPrecuremenExp[clmDoc_no.Index, dgvPrecuremenExp.Rows.Count - 1].Value = dtExpDate.Rows[i]["document_no"].ToString();
dgvPrecuremenExp[clmNote.Index, dgvPrecuremenExp.Rows.Count - 1].Value = dtExpDate.Rows[i]["notes"].ToString();
dgvPrecuremenExp[clmExpCurrency.Index, dgvPrecuremenExp.Rows.Count - 1].Value = dtExpDate.Rows[i]["exp_currency"].ToString();
}
for (int i = 0; i < dgvPrecuremenExp.Rows.Count; i++)
{
if (dgvPrecuremenExp[clmSwid.Index, i].Value.ToString() != "")
{
for (int y = 0; y < dgvPrecuremenExp.Rows[i].Cells.Count; y++)
{
dgvPrecuremenExp.Rows[i].Cells[y].Style.BackColor = System.Drawing.Color.LawnGreen;
}
}
}
}
public static bool checkEmail(string email)
{
ConnectionToDB connection = new ConnectionToDB();
String sql = "select * from users where email='" + email + "'";
DataTable dt = connection.Retrieve(sql);
if (dt.Rows.Count > 0)
{
User.userId = Convert.ToInt32(dt.Rows[0][0]);
return(true);
}
else
{
return(false);
}
}
private void FillHafzDept()
{
ConnectionToDB myconn = new ConnectionToDB();
DataTable MyDataTable;
MyDataTable = myconn.GetDataTable("Select OTHERDEPTNO,OTHERDEPTNAME From OTHERDEPT order by OTHERDEPTNO");
if (MyDataTable != null)
{
lstOTHERDEPTID.ItemsSource = MyDataTable.DefaultView;
lstOTHERDEPTID.SelectedValuePath = "OTHERDEPTNO";
lstOTHERDEPTID.DisplayMemberPath = "OTHERDEPTNAME";
lstOTHERDEPTID.SelectedIndex = -1;
}
}
private void FillOfficialdept()
{
ConnectionToDB myconn = new ConnectionToDB();
DataTable MyDataTable;
MyDataTable = myconn.GetDataTable("Select offdeptno,offdeptname From officialdept order by offdeptno");
if (MyDataTable != null)
{
lstOFFDEPTID.ItemsSource = MyDataTable.DefaultView;
lstOFFDEPTID.SelectedValuePath = "OFFDEPTNO".ToUpper();
lstOFFDEPTID.DisplayMemberPath = "OFFDEPTNAME".ToUpper();
lstOFFDEPTID.SelectedIndex = -1;
}
}
private void FillTempletTree()
{
tvTempletTree.Nodes.Clear();
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtTemplet = cnn.GetDataTable("select distinct sub_form,form_type " +
" from TEMPLET_HEADER t");
foreach (DataRow row in dtTemplet.Rows)
{
TreeNodeAdv node = new TreeNodeAdv();
node.Text = row["sub_form"].ToString();
tvTempletTree.Nodes.Add(node);
AddFormNode((string)row["form_type"], node);
}
}
private void FillCurrency(string strAccid)
{
dgCurrency.Rows.Clear();
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtCurrency = cnn.GetDataTable("select c.swid,c.curr_name,a.acc_id,a.swid CurrAccid from currency c " +
" left outer JOIN acc_curr a on(c.swid = a.curr_id and a.acc_id = " + strAccid + ") order by c.swid");
for (int i = 0; i < dtCurrency.Rows.Count; i++)
{
dgCurrency.Rows.Add();
dgCurrency[0, dgCurrency.Rows.Count - 1].Value = dtCurrency.Rows[i]["CurrAccid"].ToString();
dgCurrency[1, dgCurrency.Rows.Count - 1].Value = (dtCurrency.Rows[i]["CurrAccid"].ToString() != "" ? true : false);
dgCurrency[2, dgCurrency.Rows.Count - 1].Value = dtCurrency.Rows[i]["swid"].ToString();
dgCurrency[3, dgCurrency.Rows.Count - 1].Value = dtCurrency.Rows[i]["curr_name"].ToString();
}
}
private void FillCostCenterType()
{
dgvCostCenter.Rows.Clear();
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtCostCenter = cnn.GetDataTable("select swid,type_name,branch,administration,note from COST_CENTER_TYPES");
for (int i = 0; i < dtCostCenter.Rows.Count; i++)
{
dgvCostCenter.Rows.Add();
dgvCostCenter[clmCostCenterSwid.Index, i].Value = dtCostCenter.Rows[i]["swid"].ToString();
dgvCostCenter[clmCostName.Index, i].Value = dtCostCenter.Rows[i]["type_name"].ToString();
dgvCostCenter[clmCostNote.Index, i].Value = dtCostCenter.Rows[i]["note"].ToString();
dgvCostCenter[clmBranch.Index, i].Value = (dtCostCenter.Rows[i]["branch"].ToString() == "1" ? true : false);
dgvCostCenter[clmAdministration.Index, i].Value = (dtCostCenter.Rows[i]["administration"].ToString() == "1" ? true : false);
}
}
private void FillCurrencyName()
{
ConnectionToDB myconn = new ConnectionToDB();
DataTable MyDataTable;
MyDataTable = myconn.GetDataTable("Select SWID, CURR_NAME test From CURRENCY order by SWID");
if (MyDataTable != null && MyDataTable.Rows.Count > 0)
{
lstCurr_name.DataSource = MyDataTable;
lstCurr_name.DisplayMember = "test".ToUpper();
lstCurr_name.ValueMember = "SWID";
lstCurr_name.SelectedIndex = -1;
}
}
private void FillBranch(string strAccid)
{
dgBranches.Rows.Clear();
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtBranches = cnn.GetDataTable("select b.swid,b.branch_aname,a.acc_id,a.swid BranchAccid from branches b " +
" left outer JOIN acc_branch a on(b.swid = a.branch_id and a.acc_id = " + strAccid + ") order by b.swid");
for (int i = 0; i < dtBranches.Rows.Count; i++)
{
dgBranches.Rows.Add();
dgBranches[0, dgBranches.Rows.Count - 1].Value = dtBranches.Rows[i]["BranchAccid"].ToString();
dgBranches[1, dgBranches.Rows.Count - 1].Value = (dtBranches.Rows[i]["BranchAccid"].ToString() != "" ? true : false);
dgBranches[2, dgBranches.Rows.Count - 1].Value = dtBranches.Rows[i]["swid"].ToString();
dgBranches[3, dgBranches.Rows.Count - 1].Value = dtBranches.Rows[i]["branch_aname"].ToString();
}
}
private void GetSrvceItemData(string strSrvceSwid)
{
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtSrvceItem = cnn.GetDataTable("select si.swid,i.item_no,i.item_name,si.price from SERVICE_ITEMS si ,items i" +
" where si.itemid = i.swid and si.service_id = " + strSrvceSwid);
dgServiceItems.Rows.Clear();
for (int i = 0; i < dtSrvceItem.Rows.Count; i++)
{
dgServiceItems.Rows.Add();
dgServiceItems[0, dgServiceItems.Rows.Count - 1].Value = dtSrvceItem.Rows[i]["swid"].ToString();
dgServiceItems[1, dgServiceItems.Rows.Count - 1].Value = dtSrvceItem.Rows[i]["item_no"].ToString();
dgServiceItems[2, dgServiceItems.Rows.Count - 1].Value = dtSrvceItem.Rows[i]["item_name"].ToString();
dgServiceItems[3, dgServiceItems.Rows.Count - 1].Value = dtSrvceItem.Rows[i]["price"].ToString();
}
}
private void GetBankAddress()
{
dgAddressBook.Rows.Clear();
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtContact = cnn.GetDataTable("select ab.swid,ab.adb_name,ab.job " +
" from address_book ab " +
" where ab.swid in (select ba.ab_id from bank_address ba where ba.bank_id = " + lstBankName.SelectedValue.ToString() + ")");
for (int i = 0; i < dtContact.Rows.Count; i++)
{
dgAddressBook.Rows.Add();
dgAddressBook[0, dgAddressBook.Rows.Count - 1].Value = dtContact.Rows[i]["swid"].ToString();
dgAddressBook[1, dgAddressBook.Rows.Count - 1].Value = dtContact.Rows[i]["adb_name"].ToString();
dgAddressBook[2, dgAddressBook.Rows.Count - 1].Value = dtContact.Rows[i]["job"].ToString();
}
}
internal static bool IsHoliday(DateTime date, ConnectionToDB disconnect = ConnectionToDB.disconnect)
{
if (!isAlreadyInList(date))
{
GetAll(date, disconnect);
}
foreach (Holidays d in Holidays.ArrayListHolidays)
{
if (d.Date == date)
{
return(true);
}
}
return(false);
}
private void btnAddRecieptBook_Click(object sender, EventArgs e)
{
if (lstCollectorId.SelectedIndex == -1)
{
glb_function.MsgBox("الرجاء اختيار المحصل");
lstCollectorId.Focus();
return;
}
if (nmbBOOK_NO.Value <= 0)
{
glb_function.MsgBox("الرجاء ادخال رقم الدفتر ");
nmbBOOK_NO.Focus();
return;
}
if (nmbFROM_NO.Value <= 0)
{
glb_function.MsgBox("الرجاء ادخال عدد المستند بشكل صحيح ");
nmbFROM_NO.Focus();
return;
}
if (nmbTO_NO.Value <= nmbFROM_NO.Value)
{
glb_function.MsgBox("الرجاء ادخال عدد المستند بشكل صحيح ");
nmbTO_NO.Focus();
return;
}
ConnectionToDB cnn = new ConnectionToDB();
glb_function.arrInsertLogs = new System.Collections.ArrayList();
glb_function.arrInsertLogs.Add
("insert into RECEIPT_BOOK values((select nvl(max(swid),0)+1 from RECEIPT_BOOK)" +
", " + glb_function.glb_strUserId + ",sysdate,'فعال'," + nmbBOOK_NO.Value + "," +
nmbFROM_NO.Value + "," + nmbTO_NO.Value +
",to_date('" + dtpRECEIVED_DATE.Value.ToString("dd/MM/yyyy") + "','dd/mm/yyyy')" +
" ," + lstCollectorId.SelectedValue.ToString() + ",null,null,0,0)");
if (glb_function.MultiTransData())
{
GetCollectorBookData();
}
}
private string GetJournalHeader()
{
//
StringBuilder sbGetXml = new StringBuilder();
XmlWriter xmlWriter = XmlWriter.Create(sbGetXml);
xmlWriter.WriteStartDocument();
xmlWriter.WriteStartElement("DocumentElement".ToLower());
xmlWriter.WriteStartElement("journal_header".ToLower());
xmlWriter.WriteElementString("SWID".ToLower(), "");
xmlWriter.WriteElementString("STAT".ToLower(), "فعال");
xmlWriter.WriteElementString("CREATED_USER".ToLower(), glb_function.glb_strUserId);
xmlWriter.WriteElementString("branch_id".ToLower(), glb_function.glb_BranchNo.ToString());
xmlWriter.WriteElementString("year_n".ToLower(), DateTime.Now.ToString("yyyy"));
xmlWriter.WriteElementString("JOUR_DATE".ToLower(), DateTime.Now.ToString("dd/MM/yyyy"));
xmlWriter.WriteElementString("exchange_in_date".ToLower(), "0");
xmlWriter.WriteElementString("jour_details".ToLower(), "مصروف مشتريات" + " " + txtISSUED_TYPE.Text);
ConnectionToDB conn = new ConnectionToDB();
DataTable dtVochMax = conn.GetDataTable("select nvl( max(issued_id),0)+1 from journal_header where issued_type='قيد مصروف مشتريات' and branch_id=" + glb_function.glb_BranchNo + " and year_n=" + DateTime.Now.ToString("yyyy"));
string strIssueId = dtVochMax.Rows[0][0].ToString();
xmlWriter.WriteElementString("issued_id".ToLower(), strIssueId);
xmlWriter.WriteElementString("issued_type".ToLower(), "قيد مصروف مشتريات");
xmlWriter.WriteEndElement();
xmlWriter.WriteEndElement();
xmlWriter.WriteEndDocument();
xmlWriter.Flush();
xmlWriter.Close();
string strHeader = sbGetXml.ToString();
return(strHeader);
}
private void CheckDefaultCurrency()
{
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtCurr = cnn.GetDataTable("select IS_MAIN_CURR from CURRENCY where IS_MAIN_CURR='1'");
if (dtCurr != null && dtCurr.Rows.Count > 0)
{
ckbIS_MAIN_CURR.Enabled = false;
}
dtCurr.Rows.Clear();
cnn.GetDataTable("select IS_STOCK_CURR from CURRENCY where IS_STOCK_CURR='1'");
if (dtCurr != null && dtCurr.Rows.Count > 0)
{
ckbIS_STOCK_CURR.Enabled = false;
}
}
bool bItemCheck = false;//take item from supplierItem and take supplierItem from item infinity loop
private void GetSuplierItemData(string strSuplierSwid)
{
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtSupllierItems = cnn.GetDataTable("select swid,item_no,Item_name,itemid From item_supplier where swid=" + strSuplierSwid);
txtITEM_SUPPLIER_NUMBER.Text = dtSupllierItems.Rows[0]["item_no"].ToString();
txtITEM_SUPPLIER_NAME.Text = dtSupllierItems.Rows[0]["Item_name"].ToString();
if (dtSupllierItems.Rows[0]["itemid"].ToString().Trim() != "")
{
if (bItemCheck == false)
{
bItemCheck = true;
GetItemData(dtSupllierItems.Rows[0]["itemid"].ToString().Trim());
}
}
bItemCheck = false;
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!CheckEntries())
{
return;
}
ConnectionToDB cnn = new ConnectionToDB();
glb_function.arrInsertLogs = new System.Collections.ArrayList();
DataTable dtImport = cnn.GetDataTable("select nvl(max(swid),0)+1 from imports ");
txtSwid.Text = dtImport.Rows[0][0].ToString();
dtImport.Clear();
dtImport = cnn.GetDataTable("select swid from accounts a where stat = N'فعال' and system_acc_type = N'وارد' and acc_class = N'فرعي' order by swid");
if (dtImport == null || dtImport.Rows.Count <= 0)
{
glb_function.MsgBox("لايوجد حساب للواردات");
return;
}
txtIMP_ACCOUNT_ID.Text = dtImport.Rows[0][0].ToString();
glb_function.arrInsertLogs.Add("insert into imports values(" + txtSwid.Text + ",sysdate," +
glb_function.glb_strUserId + ",'فعال','" + lstImport_NATURE.Text +
"','" + txtImport_no.Text + "',to_date('" + dtpImport_DATE.Value.ToString("dd/MM/yyyy") + "','dd/mm/yyyy'),'" +
lstSHIPPING_Way.Text + "','" + lstOPERATION_TYPE.Text +
"',to_date('" + dtpVESSEL_DATE.Value.ToString("dd/MM/yyyy") + "','dd/mm/yyyy'),'" +
txtPORT_LOADING.Text + "','" + txtPORT_LOADING_COUNTRY.Text +
"',to_date('" + dtpESTIMATED_ARRIVAL_date.Value.ToString("dd/MM/yyyy") + "','dd/mm/yyyy'),'" +
txtPORT_DISCHARGE.Text + "','" + txtPORT_DISCHARGE_COUNTRY.Text + "','" +
txtShipping_trip_no.Text +
"',to_date('" + dtpDEPARTURE_DATE.Value.ToString("dd/MM/yyyy") + "','dd/mm/yyyy')," +
"to_date('" + dtpARRIVAL_DATE.Value.ToString("dd/MM/yyyy") + "','dd/mm/yyyy')," + txtIMP_ACCOUNT_ID.Text + "," + lstCURRENCY_ID.SelectedValue.ToString() + ")");
if (glb_function.MultiTransData())
{
GetData(txtSwid.Text);
}
}
private void DownloadEmployeesToList(string select, ConnectionToDB disconnect = ConnectionToDB.disconnect)
{
//odczyt dataReaderem zwróconego wiersza
SqlDataReader dataReader = Database.GetData(select);
arrayEmployees.Clear();
while (dataReader.Read())
{
arrayEmployees.Add(AssignEmployee(dataReader));
}
dataReader.Close();
if (disconnect == ConnectionToDB.disconnect)
{
Polaczenia.OdlaczenieOdBazy();
}
}
private void GetItemData(string strItemSwid)
{
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtItems = cnn.GetDataTable("select item_no,item_name,(select s.swid from item_supplier s where s.itemid=i.swid and s.people_id=" + txtSUPPLIER_ID.Text + ") supplierItem from items i where swid=" + strItemSwid);
txtItemNo.Text = dtItems.Rows[0]["item_no"].ToString();
txtItemName.Text = dtItems.Rows[0]["item_name"].ToString();
if (dtItems.Rows[0]["supplierItem"].ToString().Trim() != "")
{
if (bItemCheck == false)
{
bItemCheck = true;
GetSuplierItemData(dtItems.Rows[0]["supplierItem"].ToString().Trim());
}
}
bItemCheck = false;
}
private void GetTempDetailsData(int iRow)
{
dgvTempDetails.Items.Clear();
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtTempDetail = cnn.GetDataTable("select d.pkid, control_type, en_name, ar_name, control_value, real_value from HR_templet_details d " +
" where d.header_id = " + glb_function.GetCellValue(ref dgvTempHeader, clmPkId.DisplayIndex, iRow));
clsTempDetails newRow;
for (int i = 0; i < dtTempDetail.Rows.Count; i++)
{
newRow = new clsTempDetails();
newRow.clmPropName = dtTempDetail.Rows[i]["ar_name"].ToString();
newRow.clmPropValue = dtTempDetail.Rows[i]["control_value"].ToString();
dgvTempDetails.Items.Add(newRow);
}
}
private void GetData(string strListName)
{
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtGetFreeListData = cnn.GetDataTable("select swid,list_name,display_member,value_member from FREE_LIST t" +
" where list_name = '" + strListName + "'");
dgFreeList.Rows.Clear();
lstLIST_NAME.Text = strListName;
for (int i = 0; i < dtGetFreeListData.Rows.Count; i++)
{
dgFreeList.Rows.Add();
dgFreeList[0, dgFreeList.Rows.Count - 1].Value = dtGetFreeListData.Rows[i]["swid"].ToString();
dgFreeList[1, dgFreeList.Rows.Count - 1].Value = dtGetFreeListData.Rows[i]["value_member"].ToString();
dgFreeList[2, dgFreeList.Rows.Count - 1].Value = dtGetFreeListData.Rows[i]["display_member"].ToString();
}
}
private void FillLocation()
{
ConnectionToDB myconn = new ConnectionToDB();
DataTable MyDataTable;
MyDataTable = myconn.GetDataTable("Select swid, LOCATION_NAME From location order by LOCATION_NAME");
if (MyDataTable != null)
{
lstBRANCH_LOCATION.DataSource = MyDataTable;
lstBRANCH_LOCATION.DisplayMember = "LOCATION_NAME";
lstBRANCH_LOCATION.ValueMember = "swid";
lstBRANCH_LOCATION.SelectedIndex = -1;
}
}
private void btnSearch_Click(object sender, EventArgs e)
{
dgvImports.Rows.Clear();
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtLocationData = cnn.GetDataTable(" select swid,import_no,import_date,import_nature,operation_type from imports where import_no like '%" + txtImportNo.Text + "%' and import_nature like '%" + txtImportNature.Text + "%'" + strWhere);
for (int i = 0; i < dtLocationData.Rows.Count; i++)
{
dgvImports.Rows.Add();
dgvImports[0, dgvImports.Rows.Count - 1].Value = dtLocationData.Rows[i]["swid"].ToString();
dgvImports[1, dgvImports.Rows.Count - 1].Value = dtLocationData.Rows[i]["import_no"].ToString();
dgvImports[2, dgvImports.Rows.Count - 1].Value = dtLocationData.Rows[i]["import_date"].ToString();
dgvImports[3, dgvImports.Rows.Count - 1].Value = dtLocationData.Rows[i]["import_nature"].ToString();
dgvImports[4, dgvImports.Rows.Count - 1].Value = dtLocationData.Rows[i]["operation_type"].ToString();
}
}
public TourViewModel()
{
CreateTourCommand = new DelegateCommand <string[]>(str =>
{
if ((str[0] != "") && (str[1] != "") && (str[2] != "") && (str[3] != "") && (str[4] != "") && (str[5] != ""))
{
TourModel.CreatePersonalTicket(str[0], str[1], str[2], str[3], str[4], Convert.ToInt32(str[5]));
EnterModel.Close_Tour_Window();
}
else
{
MessageBox.Show("Вы заполнили не все поля!");
}
});
AvailableCounties = ConnectionToDB.getCountriesForComboBox();
}
private void btnSave_Click(object sender, EventArgs e)
{
if (!CheckEntries())
{
return;
}
glb_function.arrInsertLogs = new System.Collections.ArrayList();
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtPk = cnn.GetDataTable("select nvl(max(swid),0)+1 from JOURNAL_TEMPLATES_HD");
txtSwid.Text = dtPk.Rows[0][0].ToString().Trim();
glb_function.arrInsertLogs.Add("insert into JOURNAL_TEMPLATES_HD values ((" + txtSwid.Text + ")," +
" sysdate," + glb_function.glb_strUserId + "," + lstBranches.SelectedValue.ToString() +
",'" + txtTEMPLATES_NAME.Text.Trim() + "','" + lstT_TYPE.Text.Trim() + "','" + lstGENERAL_SPECIAL.Text.Trim() +
"'," + nmbMONTH.Value.ToString() + "," + nmbDAY.Value.ToString() + "," + nmbPERIOD.Value.ToString() +
"," + lstHeaderCurrency.SelectedValue.ToString() + ",'" + txtJOUR_DETAILS_Header.Text.Trim() +
"','" + txtNOTES.Text.Trim() + "')");
for (int i = 0; i < dgvTempDetail.Rows.Count; i++)
{
double dValue = 0;
if (dgvTempDetail[clmCredit.Index, i].Value.ToString() != "0")
{
dValue = -1 * Convert.ToDouble(dgvTempDetail[clmCredit.Index, i].Value.ToString());
}
else
{
dValue = Convert.ToDouble(dgvTempDetail[clmDept.Index, i].Value.ToString());
}
glb_function.arrInsertLogs.Add("insert into JOURNAL_TEMPLATES_DE values ((select nvl(max(swid),0)+1 from JOURNAL_TEMPLATES_DE)," +
txtSwid.Text.Trim() + "," + dValue.ToString() +
"," + dgvTempDetail[clmCurrId.Index, i].Value.ToString() +
"," + dgvTempDetail[clmAccId.Index, i].Value.ToString() +
"," + (dgvTempDetail[clmCostCenterId.Index, i].Value.ToString() == ""?"null": dgvTempDetail[clmCostCenterId.Index, i].Value.ToString()) +
",'" + dgvTempDetail[clmJourDetailNote.Index, i].Value.ToString() + "')");
}
if (glb_function.MultiTransData())
{
GetData(txtSwid.Text);
}
}
private void FillBranches()
{
ConnectionToDB conn = new ConnectionToDB();
DataTable MyDataTable;
MyDataTable = conn.GetDataTable("Select SWID,BRANCH_ANAME From BRANCHES order by BRANCH_ANAME");
if (MyDataTable != null)
{
lstUSER_BRANCH.DataSource = MyDataTable;
lstUSER_BRANCH.DisplayMember = "BRANCH_ANAME";
lstUSER_BRANCH.ValueMember = "SWID";
lstUSER_BRANCH.SelectedIndex = -1;
}
}
private void FillUserPreventAcc(string strSwid)
{
dgUserAccPervented.Rows.Clear();
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtUserPreAcc = cnn.GetDataTable("select u.swid,u.acc_id,a.acc_no,a.acc_name from USER_PREVENTED_ACC u,accounts a " +
" where a.swid = u.acc_id" +
" and u.user_id = " + strSwid);
for (int i = 0; i < dtUserPreAcc.Rows.Count; i++)
{
dgUserAccPervented.Rows.Add();
dgUserAccPervented[0, dgUserAccPervented.Rows.Count - 1].Value = dtUserPreAcc.Rows[i]["swid"].ToString();
dgUserAccPervented[1, dgUserAccPervented.Rows.Count - 1].Value = dtUserPreAcc.Rows[i]["acc_id"].ToString();
dgUserAccPervented[2, dgUserAccPervented.Rows.Count - 1].Value = dtUserPreAcc.Rows[i]["acc_no"].ToString();
dgUserAccPervented[3, dgUserAccPervented.Rows.Count - 1].Value = dtUserPreAcc.Rows[i]["acc_name"].ToString();
}
}
private void FillAccountTree()
{
dtPrepareAccTree = new DataTable();
ConnectionToDB cnn = new ConnectionToDB();
//dtPrepareAccTree = cnn.GetDataTable("select nvl(the_value,0) from DEFAULT_VALUES where VALUE_NAME='الرتبة'");
// int iLevelNo =Convert.ToInt16(dtPrepareAccTree.Rows[0][0].ToString());
dtPrepareAccTree.Rows.Clear();
dtPrepareAccTree = cnn.GetDataTable("select swid, created_date, stat, acc_no, acc_type, acc_name, acc_level, acc_class, acc_note, acc_code, nvl(acc_parent,0) as acc_parent, created_user, acc_subject,ACC_REPORT,ACC_NATURE from ACCOUNTS t " +
" order by acc_no ");
tvAccTreeMain.Nodes.Clear();
PopulateTreeViewMain(0, null);
}
private void GetCustomerData(string strId)
{
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtCustomers = cnn.GetDataTable("select p.swid,p.acc_id,a.acc_no,p.p_name, " +
" (select max( swid ) contact_id from address_book ab where ab.people_id=p.swid) contact_id " +
" from people p , accounts a " +
" where p.acc_id = a.swid and p.swid = " + strId);
txtCustomerId.Text = strId;
txtCUSTOMER_ACCID.Text = dtCustomers.Rows[0]["acc_no"].ToString();
txtContactName.Text = dtCustomers.Rows[0]["p_name"].ToString();
txtCONTACT_ID.Text = dtCustomers.Rows[0]["contact_id"].ToString();
}
private void GetExchangeLog()
{
dgExhangeLog.Rows.Clear();
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtExLog = cnn.GetDataTable("select CURR_ID,CURR_PRICE,CURR_MIN,CURR_MAX,to_char(CREATED_DATE,'dd/mm/yyyy') CREATED_DATE from CURRENCY_EXCHANGE" +
" where curr_id=" + lstCurr_name.SelectedValue.ToString() + "order by swid desc");
for (int i = 0; i < dtExLog.Rows.Count; i++)
{
dgExhangeLog.Rows.Add();
dgExhangeLog[0, dgExhangeLog.Rows.Count - 1].Value = dtExLog.Rows[i]["CURR_PRICE"].ToString();
dgExhangeLog[1, dgExhangeLog.Rows.Count - 1].Value = dtExLog.Rows[i]["CURR_MIN"].ToString();
dgExhangeLog[2, dgExhangeLog.Rows.Count - 1].Value = dtExLog.Rows[i]["CURR_MAX"].ToString();
dgExhangeLog[3, dgExhangeLog.Rows.Count - 1].Value = dtExLog.Rows[i]["CREATED_DATE"].ToString();
}
}
