private void myBottun1_Click(object sender, EventArgs e)
{
string strBarcod = "";
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtChar = cnn.GetDataTable("select barcode from beneficiary where swid=1827 ");
string str = dtChar.Rows[0][0].ToString();
str = str.Substring(str.Length - 1);
int icheck = 0;
dtChar.Clear();
dtChar = cnn.GetDataTable("select swid, barcode from beneficiary");
try
{
for (int i = 0; i < dtChar.Rows.Count; i++)
{
if (dtChar.Rows[i]["barcode"].ToString() != "")
{
if (dtChar.Rows[i]["barcode"].ToString().Substring(dtChar.Rows[i]["barcode"].ToString().Length - 1) == str)
{
icheck = cnn.TranDataToDB("update beneficiary set barcode='" + dtChar.Rows[i]["barcode"].ToString().Replace(str, "") + "' where swid=" + dtChar.Rows[i]["swid"].ToString());
}
}
}
}
catch (Exception)
{
string strtes = strBarcod;
}
cnn.glb_commitTransaction();
}
private void rblogout_Click(object sender, EventArgs e)
{
lblUserLable.Text = "";
ConnectionToDB cnn = new ConnectionToDB();
int icheck = cnn.TranDataToDB("update USER_LOGS set USER_LOGS.logoff_date=sysdate" +
" where USER_LOGS.user_id = " + glb_function.glb_strUserId +
" and USER_LOGS.logoff_date is null ");
cnn.glb_commitTransaction();
glb_function.glb_strUserName = "";
InitialLogin();
}
private void myBottun1_Click(object sender, EventArgs e)
{
ConnectionToDB cnn = new ConnectionToDB();
if (txtItemSwid.Text == "")
{
if (txtItemNo.Text == "")
{
glb_function.MsgBox("الرجاء ادخال رقم القطعة");
return;
}
DataTable dt = cnn.GetDataTable("select swid from items where item_no='" + txtItemNo.Text + "'");
if (dt == null || dt.Rows.Count <= 0)
{
glb_function.MsgBox("No data");
return;
}
else if (dt.Rows.Count > 1)
{
glb_function.MsgBox("more than One Item");
txtItemSwid.Text = dt.Rows[0][0].ToString();
// return;
}
else
{
return;
}
}
int icheck = cnn.TranDataToDB("delete from ITEM_UNITS where item_id=" + txtItemSwid.Text);
if (icheck < 0)
{
glb_function.MsgBox("Error in item units");
return;
}
// icheck = cnn.TranDataToDB("delete from PROPERTY_ITEM where item_id=" + txtItemSwid.Text);
//if (icheck < 0)
//{
// glb_function.MsgBox("Error in item PROPERTY");
// cnn.glb_RollbackTransaction();
// return;
//}
icheck = cnn.TranDataToDB("delete from PROPERTY_ITEM where item_id=" + txtItemSwid.Text);
if (icheck < 0)
{
glb_function.MsgBox("Error in item PROPERTY");
cnn.glb_RollbackTransaction();
return;
}
icheck = cnn.TranDataToDB("delete from PACK_ITEM where itemid=" + txtItemSwid.Text);
if (icheck < 0)
{
glb_function.MsgBox("Error in item Package");
cnn.glb_RollbackTransaction();
return;
}
icheck = cnn.TranDataToDB("delete from items where swid=" + txtItemSwid.Text);
if (icheck <= 0)
{
glb_function.MsgBox("Error in items");
cnn.glb_RollbackTransaction();
return;
}
cnn.glb_commitTransaction();
glb_function.MsgBox("Deleted");
}
private void btnLogin_Click(object sender, EventArgs e)
{
// CnnDB cnn = new CnnDB();
ConnectionToDB cnn = new ConnectionToDB();
DataTable dtLogin = cnn.GetDataTable("select swid,STAT,USER_LOGIN,USER_NAME,USER_BRANCH,(select branch_aname from branches where swid=nvl(USER_BRANCH,0)) BranchName,access_type,dept_id,(select d.dept_aname from departements d where d.swid=dept_id) dept_name,to_char(sysdate,'dd/mm/yyyy') TodayDate from USERINFO " +
" where USER_LOGIN=N'" + txtUserid.Text.Trim().Replace("'", "").Trim() + "' and USER_PASSWORD='******'");
if (dtLogin != null && dtLogin.Rows.Count != 0)
{
#region test
// frmMain f = (frmMain)Application.OpenForms["frmMain"];
//new glb_function(). LoginMethod(txtUserid.Text);
#endregion
if (dtLogin.Rows[0]["stat"].ToString() == "غير فعال")
{
glb_function.MsgBox("المستخدم غير فعال", "رسالة نظام");
return;
}
string userip = glb_function.GetLocalIPAddress();
DataTable dtUserAcc = new DataTable();
// 1التاكد من ان المستخدم لديه الحق في الدخول من هذا الجهاز
string str = dtLogin.Rows[0]["access_type"].ToString();
if (dtLogin.Rows[0]["access_type"].ToString() != "كل")
{
dtUserAcc = cnn.GetDataTable("select swid from USER_COMPUTERS t " +
" where t.userid =" + dtLogin.Rows[0]["swid"].ToString() + " and (device_code = '" + glb_function.GetProcessorId() + "' or '" + userip + "' like t.device_code || '%' ) ");
if (dtUserAcc == null || dtUserAcc.Rows.Count <= 0)
{
glb_function.MsgBox("ليس لديك صلاحية للدخول من هذا الجهاز");
return;
}
}
//1*******************************************************
//2التاكد ان المستخدم داخل من جهاز ثاني
dtUserAcc.Rows.Clear();
dtUserAcc = cnn.GetDataTable("select swid,ip from USER_LOGS where user_id=" + dtLogin.Rows[0]["swid"].ToString() + " and (logoff_date ='' or logoff_date is null)");
if (dtUserAcc.Rows.Count >= 1)
{
IPAddress ip = IPAddress.Parse(dtUserAcc.Rows[0]["ip"].ToString());
if (dtUserAcc.Rows[0]["ip"].ToString() != glb_function.GetLocalIPAddress())
{
if (glb_function.MsgBox("هذا المستخدم مسجل بجهاز اخر هل تريد الخروج منه والتسجيل من هذا الجهاز", "", true))
{
// glb_function. SendMessage("<log off user >" +txtUserid.Text.Trim(), ip);
}
else
{
return;
}
}
int icheck1 = cnn.TranDataToDB("update USER_LOGS set logoff_date= sysdate where user_id=" + dtLogin.Rows[0]["swid"].ToString() + " and (logoff_date ='' or logoff_date is null)");
if (icheck1 <= 0)
{
glb_function.MsgBox("حدث خطأ ");
return;
}
cnn.glb_commitTransaction();
}
//2********************************
//3 فحص هل المستخدم تغير ام لا
if (glb_function.glb_strUserLogin != txtUserid.Text)
{
//OpenForms f = new Application.OpenForms();
for (int i = Application.OpenForms.Count - 1; i >= 0; i--)
{
if (((Form)(Application.OpenForms[i])).Name != "frmMain" && Application.OpenForms[i].Name != "frmLogin")
{
Application.OpenForms[i].Close();
}
}
}
//3***************************
//4 إنشاء بيانات الدخول وفتح جلسة للمستخدم
int icheck = cnn.TranDataToDB("insert into USER_LOGS values((select nvl(max(swid),0)+1 from USER_LOGS)," + dtLogin.Rows[0]["swid"].ToString() + ",sys_context('USERENV','SID'),sys_context('USERENV','HOST'),sysdate,null,'" + userip + "')");
if (icheck <= 0)
{
glb_function.MsgBox("حدث خطأ اثناء تسجيل بيانات الدخول");
return;
}
cnn.glb_commitTransaction();
//4***************************************
glb_function.glb_strUserId = dtLogin.Rows[0]["swid"].ToString();
glb_function.glb_strUserLogin = dtLogin.Rows[0]["USER_LOGIN"].ToString();
glb_function.glb_strUserName = dtLogin.Rows[0]["USER_NAME"].ToString();
glb_function.glb_BranchNo = Convert.ToInt16(dtLogin.Rows[0]["USER_BRANCH"].ToString());
glb_function.glb_BranchName = dtLogin.Rows[0]["BranchName"].ToString();
glb_function.glb_deptId = Convert.ToInt16(dtLogin.Rows[0]["dept_id"].ToString());
glb_function.glb_DeptName = dtLogin.Rows[0]["dept_name"].ToString();
glb_function.dtSysdate = DateTime.ParseExact(dtLogin.Rows[0]["TodayDate"].ToString(), "dd/MM/yyyy", System.Globalization.CultureInfo.InvariantCulture);
//***************
DataTable dtMainCurr = cnn.GetDataTable("select swid,curr_name,curr_decimal from currency c where c.is_main_curr = '1'");
if (dtMainCurr == null || dtMainCurr.Rows.Count <= 0)
{
glb_function.MsgBox("لايوجد عملة رئيسية للنظام");
// SOWAID.frmCurrency frm = new frmCurrency();
//frm.FormClosed += Frm_FormClosed;
//frm.ShowDialog();
}
else
{
glb_function.glb_MainCurrencyId = Convert.ToInt16(dtMainCurr.Rows[0]["swid"].ToString());
glb_function.glbMainCurrencyName = dtMainCurr.Rows[0]["curr_name"].ToString();
glb_function.glbMainDecimalPoint = Convert.ToInt16(dtMainCurr.Rows[0]["curr_decimal"].ToString());
}
//*****************
}
else
{
glb_function.MsgBox("كلمة السر او اسم المستخدم غير صحيحة", "تنبية");
return;
}
//DataTable dtSession = cnn.GetDataTable("select sys_context('USERENV', 'SID') from dual ");
//MessageBox.Show(dtSession.Rows[0][0].ToString());
this.Close();
}
