private void transferButton_Click(object sender, EventArgs e)
{
if (clientId != 0)
{
#region Func
if (string.IsNullOrWhiteSpace(nationalIdText.Text))
{
err = new ErrorProvider();
err.SetError(nationalIdText, "يجب إدخال الرقم القومي");
}
else
{
if (err != null)
{
err.Clear();
}
}
if (string.IsNullOrWhiteSpace(unitType.Text))
{
unitErr = new ErrorProvider();
err.SetError(unitType, "يجب إدخال نوع الوحدة المحول إليها ");
}
else
{
if (unitErr != null)
{
unitErr.Clear();
}
}
//Sql commands
if (!string.IsNullOrWhiteSpace(unitType.Text) && !string.IsNullOrWhiteSpace(nationalIdText.Text) && unitType.Text != currentUnitState.Text)
{
try
{
String selectUnit = "select ID from units where unit_type=" + int.Parse(unitType.Text.ToString());
c1.SQLCODE(selectUnit, false);
int unittyperetrie = 0;
while (c1.myReader.Read())
{
unittyperetrie = int.Parse(c1.myReader["ID"].ToString());
}
FunctionsClass.updtaeMyScriptHistory(clientId);
String sqlupdateToOld = "update ClientsUnits set RecoredState='O' where (client_id=" + clientId + " and RecoredState='N')";
c1.SQLUPDATE(sqlupdateToOld, false);
String sqlinsert = "insert into ClientsUnits(client_id,unit_id,RecoredState)values(" + clientId + "," + unittyperetrie + ",'N')";
c1.SQLUPDATE(sqlinsert, false);
String updateUnitsSql = "update units set available_units=available_units-1 where unit_type=" + int.Parse(unitType.Text);
c1.SQLUPDATE(updateUnitsSql, false);
updateUnitsSql = "update units set available_units=available_units+1 where unit_type=" + int.Parse(currentUnitState.Text);
c1.SQLUPDATE(updateUnitsSql, true);
}
catch (Exception ex)
{
MessageBox.Show("خطأ ف البيانات المدخلة");
Logger.WriteLog("[" + DateTime.Now + "] ExceptionString: " + ex.ToString() + " InnerException: " + ex.InnerException + " ExceptionMessage: " + ex.Message + ". [" + this.Name + "] By [" + SessionInfo.empName + "]");
}
//clear all errors
if (unitErr != null)
{
unitErr.Clear();
}
if (err != null)
{
err.Clear();
}
}
else
{
MessageBox.Show("خطأ ف البيانات المدخلة");
}
}
#endregion
}
private void button4_Click(object sender, EventArgs e)
{
//validate
if (string.IsNullOrWhiteSpace(nationalIDMota.Text))
{
err = new ErrorProvider();
err.SetError(nationalIDMota, "يجب إدخال الرقم القومي");
}
else
{
if (err != null)
{
err.Clear();
}
}
//insert into tanazolat
if (err == null && MotnazelToComplete && motnazelID != 0 && !string.IsNullOrEmpty(MotnazelToNationalId))
{
try
{
String motanazaElleh = MotnazelToNationalId;
String subquery = "select ID from Clients where national_id='" + motanazaElleh + "'";
c1.SQLCODE(subquery, false);
int ToID = 0;
int unitType = 0;
while (c1.myReader.Read())
{
ToID = int.Parse(c1.myReader["ID"].ToString());
}
if (ToID != 0 && motnazelID != 0)
{
String da = tanazolDate.Value.ToString("yyyy/MM/dd");
String query1 = "insert into tanazolat (from_id,to_id,tanazol_date) values (" + motnazelID + "," + ToID + ",#" + da + "#)";
if (c1.SQLUPDATE(query1, false))
{
String query2 = "update Clients set TnazolState ='F' where id=" + motnazelID + "";
c1.SQLUPDATE(query2, false);
String query3 = "update Clients set TnazolState ='T' where id=" + ToID + "";
c1.SQLUPDATE(query3, false);
//We need to update aqsat history to be with the new client ID
String query4 = "update aqsat set client_id=" + ToID + ",details='تم نقل القسط بعد التنازل' where client_id=" + motnazelID + "";
c1.SQLUPDATE(query4, false);
String query5 = "update first_paids set client_id=" + ToID + " where client_id=" + motnazelID + "";
c1.SQLUPDATE(query5, false);
String query6 = "update T5sesMoney set client_id =" + ToID + " where client_id=" + motnazelID + "";
c1.SQLUPDATE(query6, false);
//
String unitTypeTanazolSql = "select * from ClientsUnits where client_id=" + motnazelID + " ORDER BY ClientsUnits.ID DESC";
c1.SQLCODE(unitTypeTanazolSql, false);
if (c1.myReader.Read())
{
unitType = int.Parse(c1.myReader["unit_id"].ToString());
}
String sql2 = "insert into ClientsUnits(client_id,unit_id,RecoredState)values(" + ToID + "," + unitType + ",'N')";
c1.SQLUPDATE(sql2, true);
FunctionsClass.updtaeMyScriptHistory(motnazelID);
this.Close();
}
}
}
catch (Exception ex)
{
MessageBox.Show("خطأ ف البيانات المدخلة");
Logger.WriteLog("[" + DateTime.Now + "] ExceptionString: " + ex.ToString() + " InnerException: " + ex.InnerException + " ExceptionMessage: " + ex.Message + ". [" + this.Name + "] By [" + SessionInfo.empName + "]");
}
}
else
{
MessageBox.Show("يوجد خطأ, اما انك لم تدخل بيانات العميل الجديد او أنك لم تدخل الرقم القومي للعميل القديم ");
}
}