private void button1_Click(object sender, EventArgs e)
{
try
{
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand comm = new SqlCommand("ADDNEWUSER", DatabaseConnection.mConnection);
comm.CommandType = CommandType.StoredProcedure;
comm.Parameters.AddWithValue("@EMP_ID", myEmployee.SH_ID);
comm.Parameters.AddWithValue("@EMP_NAME", myEmployee.SH_EMPLOYEE_NAME);
comm.Parameters.AddWithValue("@EMP_USER_NAME", txtEmpUserName.Text);
comm.Parameters.AddWithValue("@EMP_PASSWORD", txtEmpPassword.Text);
comm.Parameters.AddWithValue("@CREATIONDATE", DateTime.Now);
comm.ExecuteNonQuery();
MessageBox.Show("تم تسجيل الموظف كمستخدم بنجاح");
bttnSave.Enabled = false;
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
}
}
void load_clients_data_search(string clientname)
{
clients.Clear();
try
{
string query = "SELECT * FROM SH_CLIENT_COMPANY WHERE SH_CLIENT_COMPANY_NAME LIKE N'%" + clientname + "' OR SH_CLIENT_COMPANY_NAME LIKE N'%" + clientname + "%' OR SH_CLIENT_COMPANY_NAME LIKE N'" + clientname + "%' ";
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
// cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_NAME" ,clientname);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
clients.Add(new SH_CLIENT_COMPANY {
SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_CLIENT_COMPANY_NAME = reader["SH_CLIENT_COMPANY_NAME"].ToString(), SH_CLIENT_COMPANY_TYPE = reader["SH_CLIENT_COMPANY_TYPE"].ToString(), SH_CLIENT_COMPANY_TELEPHONE = reader["SH_CLIENT_COMPANY_TELEPHONE"].ToString(), SH_CLIENT_COMPANY_FAX_NUMBER = reader["SH_CLIENT_COMPANY_FAX_NUMBER"].ToString()
});
}
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE GETTING CLIENTS DATA FROM DB" + ex.ToString());
}
}
void loadspecificationsofcutprintedmaterial()
{
specifications.Clear();
try
{
string query = "SELECT * FROM SH_SPECIFICATION_OF_CUT_PRINTED_MATERIAL";
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
specifications.Add(new SH_SPECIFICATION_OF_CUT_PRINTED_MATERIAL()
{
SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_CLIENT_ID = long.Parse(reader["SH_CLIENT_ID"].ToString()), SH_PRODUCT_ID = long.Parse(reader["SH_PRODUCT_ID"].ToString())
});
}
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE GETTING SPECIFICATIONS OF CUT PRINTED MATERIAL " + ex.ToString());
}
}
long loadPlasticTappaspcification()
{
SpecList.Clear();
try
{
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand("getPlasticMoldSpecification", DatabaseConnection.mConnection);
cmd.CommandType = CommandType.StoredProcedure;
cmd.Parameters.AddWithValue("@SH_MOLD_TYPE_NAME", textBoxType.Text);
cmd.Parameters.AddWithValue("@SH_MOLD_SIZE_VALUE", double.Parse(textBoxClintName.Text));
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
long id_spec = long.Parse(reader["SH_ID"].ToString());
textBoxQuntityInStock.Clear();
textBoxQuntityInStock.Text = reader["SH_TOTAL_NO_ITEMS"].ToString();
return(id_spec);
}
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE GETTING Plastic Mold specification FROM DB " + ex.ToString());
}
return(0);
}
void loadUserPermisions()
{
string query = "select * from SH_USER_PERMISIONS";
try
{
DatabaseConnection conn = new DatabaseConnection();
conn.openConnection();
SqlCommand comm = new SqlCommand(query, DatabaseConnection.mConnection);
SqlDataReader red = comm.ExecuteReader();
while (red.Read())
{
userPermList.Add(new SH_USER_PERMISIONS {
SH_ID = long.Parse(red["SH_ID"].ToString()), SH_ACCOUNT_ID = long.Parse(red["SH_ACCOUNT_ID"].ToString()), SH_ACCOUNT_NAME = red["SH_ACCOUNT_NAME"].ToString()
});
}
red.Close();
conn.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("Error in loading User permisions from dataBase" + ex.Message);
}
}
void loadallshoporders()
{
work_shop_orders.Clear();
try
{
string query = "SELECT * FROM SH_WORK_SHOP_WORK_ORDERS ";
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
work_shop_orders.Add(new SH_WORK_SHOP_WORK_ORDERS()
{
SH_ASKED_MAN_NAME = reader["SH_ASKED_MAN_NAME"].ToString(), SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_ITEM_NAME = reader["SH_ITEM_NAME"].ToString(), SH_ITEM_QUANTITY = long.Parse(reader["SH_ITEM_QUANTITY"].ToString()), SH_NOTES = reader["SH_NOTES"].ToString(), SH_START_WORK_DATE = DateTime.Parse(reader["SH_START_WORK_DATE"].ToString()), SH_WORKING_MACHINE = reader["SH_WORKING_MACHINE"].ToString(), SH_WORKING_TOTAL_HOURS = long.Parse(reader["SH_WORKING_TOTAL_HOURS"].ToString()), SH_FINISH_DATE = DateTime.Parse(reader["SH_FINISH_DATE"].ToString()), SH_WORK_STAT = long.Parse(reader["SH_WORK_STAT"].ToString()), SH_WORK_STAT_NAME = reader["SH_WORK_STAT_NAME"].ToString()
});
}
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE GETTING WORKSHOP ORDERS " + ex.ToString());
}
}
void loadmuranmaterials()
{
muran_materials.Clear();
try
{
string query = "SELECT * FROM SH_SPECIFICATION_OF_MURAN_MATERIAL";
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
muran_materials.Add(new SH_SPECIFICATION_OF_MURAN_MATERIAL()
{
SH_ITEM_LENGTH = double.Parse(reader["SH_ITEM_LENGTH"].ToString()), SH_ITEM_WIDTH = double.Parse(reader["SH_ITEM_WIDTH"].ToString()), SH_ITEM_THICKNESS = double.Parse(reader["SH_ITEM_THICKNESS"].ToString()), SH_BOTTLE_CAPACITY = reader["SH_BOTTLE_CAPACITY"].ToString(), SH_BOTTLE_HEIGHT = double.Parse(reader["SH_BOTTLE_HEIGHT"].ToString()), SH_ITEM_CODE = reader["SH_ITEM_CODE"].ToString(), SH_ITEM_FIRST_FACE = reader["SH_ITEM_FIRST_FACE"].ToString(), SH_ITEM_SECOND_FACE = reader["SH_ITEM_SECOND_FACE"].ToString(), SH_ITEM_TYPE = reader["SH_ITEM_TYPE"].ToString(), SH_MURAN_TYPE = reader["SH_MURAN_TYPE"].ToString(), SH_SIZE_ID = long.Parse(reader["SH_SIZE_ID"].ToString()), SH_SIZE_NAME = reader["SH_SIZE_NAME"].ToString(), SH_ID = long.Parse(reader["SH_ID"].ToString())
});
}
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE GETTING ALL MURAN TIN INFORMATION " + ex.ToString());
}
}
void update_specifiction_quanities(long sid)
{
try
{
string query = "UPDATE SH_SPECIFICATION_OF_RAW_MATERIAL SET SH_ITEM_TOTAL_NUMBER_OF_SHEETS = SH_ITEM_TOTAL_NUMBER_OF_SHEETS + @SH_ITEM_TOTAL_NUMBER_OF_SHEETS";
query += ", SH_TOTAL_NET_WEIGHT = SH_TOTAL_NET_WEIGHT + @SH_TOTAL_NET_WEIGHT, SH_ITEM_TOTAL_NUMBER_OF_PACKAGES = SH_ITEM_TOTAL_NUMBER_OF_PACKAGES + @SH_ITEM_TOTAL_NUMBER_OF_PACKAGES ,";
query += " SH_TOTAL_GROSS_WEIGHT = SH_TOTAL_GROSS_WEIGHT + @SH_TOTAL_GROSS_WEIGHT WHERE SH_ID = @SH_ID";
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
cmd.Parameters.AddWithValue("@SH_ITEM_TOTAL_NUMBER_OF_SHEETS", all_packages_no_sheets);
cmd.Parameters.AddWithValue("@SH_TOTAL_NET_WEIGHT", (((double.Parse(item_length_text_box.Text) * double.Parse(item_width_text_box.Text) * double.Parse(item_thickness_text_box.Text)) / 1000000) * double.Parse(item_intensity_text_box.Text)) * double.Parse(all_packages_no_sheets.ToString()));
cmd.Parameters.AddWithValue("@SH_TOTAL_GROSS_WEIGHT", all_packages_gross_weight);
cmd.Parameters.AddWithValue("@SH_ITEM_TOTAL_NUMBER_OF_PACKAGES", total_no_packges);
cmd.Parameters.AddWithValue("@SH_ID", sid);
cmd.ExecuteNonQuery();
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR UPDATING QUANTITES IN SPECIFICATION TABLE" + ex.ToString());
}
}
void LOADALLRAWTININFOS()
{
all_raw_tin.Clear();
try
{
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand("Select * FROM SH_SPECIFICATION_OF_RAW_MATERIAL ", DatabaseConnection.mConnection);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
all_raw_tin.Add(new SH_SPECIFICATION_OF_RAW_MATERIAL {
SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_ITEM_LENGTH = double.Parse(reader["SH_ITEM_LENGTH"].ToString()), SH_ITEM_WIDTH = double.Parse(reader["SH_ITEM_WIDTH"].ToString()), SH_ITEM_THICKNESS = double.Parse(reader["SH_ITEM_THICKNESS"].ToString()), SH_ITEM_CODE = reader["SH_ITEM_CODE"].ToString(), SH_ITEM_FINISH = reader["SH_ITEM_FINISH"].ToString(), SH_ITEM_TEMPER = reader["SH_ITEM_TEMPER"].ToString(), SH_ITEM_COATING = reader["SH_ITEM_COATING"].ToString(), SH_ITEM_INTENSITY = double.Parse(reader["SH_ITEM_INTENSITY"].ToString()), SH_ITEM_TYPE = reader["SH_ITEM_TYPE"].ToString(), SH_ITEM_NAME = reader["SH_ITEM_NAME"].ToString(), SH_CREATION_DATE = DateTime.Parse(reader["SH_CREATION_DATE"].ToString()), SH_ITEM_TOTAL_GROSS_WEIGHT = double.Parse(reader["SH_TOTAL_GROSS_WEIGHT"].ToString()), SH_ITEM_TOTAL_NET_WEIGHT = double.Parse(reader["SH_TOTAL_NET_WEIGHT"].ToString()), SH_ITEM_TOTAL_NUMBER_OF_PACKAGES = long.Parse(reader["SH_ITEM_TOTAL_NUMBER_OF_PACKAGES"].ToString()), SH_ITEM_TOTAL_NUMBER_OF_SHEETS = long.Parse(reader["SH_ITEM_TOTAL_NUMBER_OF_SHEETS"].ToString())
});
}
myconnection.closeConnection();
}
catch (Exception)
{
MessageBox.Show("خطأ فى تحميل البيانات ", "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
}
}
void loadsuppliersdata()
{
SUPPLIERS.Clear();
try
{
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand("SELECT * FROM SH_SUPPLY_COMPANY", DatabaseConnection.mConnection);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
SUPPLIERS.Add(new SH_SUPPLY_COMPANY()
{
SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_SUPPLY_COMAPNY_NAME = reader["SH_SUPPLY_COMAPNY_NAME"].ToString(), SH_SUPPLY_COMPANY_TELEPHONE = reader["SH_SUPPLY_COMPANY_TELEPHONE"].ToString(), SH_SUPPLY_COMPANY_MOBILE = reader["SH_SUPPLY_COMPANY_MOBILE"].ToString(), SH_SUPPLY_COMPANY_TYPE = reader["SH_SUPPLY_COMPANY_TYPE"].ToString(), SH_SUPPLY_COMPANY_FAX = reader["SH_SUPPLY_COMPANY_FAX"].ToString()
});
}
reader.Close();
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE GETTING SUPLLIERS DATA" + ex.ToString());
}
}
void loadDataGrid()
{
try
{
string query = "select * from SH_QUANTITY_OF_EXCHANGED_PRINTED_MATERIAL where SH_CUTTER_ID=@id";
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
cmd.Parameters.AddWithValue("@id", cutters[cutters_combo_box.SelectedIndex].SH_ID);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
QntExchPrntMaterialLst.Add(new SH_QUANTITY_OF_EXCHANGED_PRINTED_MATERIAL {
SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_CUTTER_NAME = reader["SH_CUTTER_NAME"].ToString(), SH_CONFIDENTIAL_MAN_ID = long.Parse(reader["SH_CONFIDENTIAL_MAN_ID"].ToString()), SH_EXCHANGE_PERMISSION_NUMBER = reader["SH_EXCHANGE_PERMISSION_NUMBER"].ToString(), SH_CONFIDENTIAL_MAN_NAME = reader["SH_CONFIDENTIAL_MAN_NAME"].ToString(), SH_CUTTER_ID = long.Parse(reader["SH_CUTTER_ID"].ToString()), SH_CUTTER_MAN_NAME = reader["SH_CUTTER_MAN_NAME"].ToString(), SH_DEPARTMENET_ID = long.Parse(reader["SH_DEPARTMENET_ID"].ToString()), SH_DEPARTMENT_NAME = reader["SH_DEPARTMENT_NAME"].ToString(), SH_NUMBER_OF_PARCELS = long.Parse(reader["SH_NUMBER_OF_PARCELS"].ToString()), SH_STOCK_NAME = reader["SH_STOCK_NAME"].ToString(), SH_NUMBER_OF_SHEETS = long.Parse(reader["SH_NUMBER_OF_SHEETS"].ToString()), SH_RECEIVED_MAN_ID = long.Parse(reader["SH_RECEIVED_MAN_ID"].ToString()), SH_RECEIVED_MAN_NAME = reader["SH_RECEIVED_MAN_NAME"].ToString(), SH_STOCK_ID = long.Parse(reader["SH_STOCK_ID"].ToString()), SH_STOCK_MAN_ID = long.Parse(reader["SH_STOCK_MAN_ID"].ToString()), SH_STOCK_MAN_NAME = reader["SH_STOCK_MAN_NAME"].ToString()
});
}
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERRO WHILE GETTING QUANTITY_OF_EXCHANGED_PRINTED_MATERIAL DATA FROM DB " + ex.ToString());
}
}
void fillprintedmaterialparcelsgridview()
{
parcels.Clear();
try
{
string query = "SELECT SH_PALLETS_OF_CUT_PRINTED_MATERIAL.* ";
query += " FROM SH_PALLETS_OF_CUT_PRINTED_MATERIAL ";
query += "WHERE(SH_CLIENT_ID = @SH_CLIENT_ID) AND(SH_PRODUCT_ID = @SH_PRODUCT_ID)";
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
cmd.Parameters.AddWithValue("@SH_CLIENT_ID", clients[clients_combo_box.SelectedIndex].SH_ID);
cmd.Parameters.AddWithValue("@SH_PRODUCT_ID", client_products[client_products_combo_box.SelectedIndex].SH_ID);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
parcels.Add(new SH_PALLETS_OF_CUT_PRINTED_MATERIAL()
{
SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_CLIENT_ID = long.Parse(reader["SH_CLIENT_ID"].ToString()), SH_CLIENT_NAME = reader["SH_CLIENT_NAME"].ToString(), SH_ADDITION_DATE = DateTime.Parse(reader["SH_ADDITION_DATE"].ToString()), SH_ADDTION_PERMISSION_NUMBER = reader["SH_ADDTION_PERMISSION_NUMBER"].ToString(), SH_CUTTER_ID = long.Parse(reader["SH_CUTTER_ID"].ToString()), SH_CUTTER_NAME = reader["SH_CUTTER_NAME"].ToString(), SH_CUTTER_TECHNICAL_MAN = reader["SH_CUTTER_TECHNICAL_MAN"].ToString(), SH_NUMBER_OF_BOTTLES_PER_SEQUENCE = long.Parse(reader["SH_NUMBER_OF_BOTTLES_PER_SEQUENCE"].ToString()), SH_NUMBER_OF_SEQUENCES = long.Parse(reader["SH_NUMBER_OF_SEQUENCES"].ToString()), SH_PRODUCT_ID = long.Parse(reader["SH_PRODUCT_ID"].ToString()), SH_PRODUCT_NAME = reader["SH_PRODUCT_NAME"].ToString(), SH_QUANTITIES_OF_CUT_PRINTED_MATERIAL_ID = long.Parse(reader["SH_QUANTITIES_OF_CUT_PRINTED_MATERIAL_ID"].ToString()), SH_SPECIFICATION_OF_CU_PRINTED_MATERIAL_ID = long.Parse(reader["SH_SPECIFICATION_OF_CU_PRINTED_MATERIAL_ID"].ToString()), SH_STOCK_ID = long.Parse(reader["SH_STOCK_ID"].ToString()), SH_STOCK_NAME = reader["SH_STOCK_NAME"].ToString(), SH_TOTAL_NUMBER_OF_BOTTELS = long.Parse(reader["SH_TOTAL_NUMBER_OF_BOTTELS"].ToString()), SH_WORK_ORDER_NUMBER = reader["SH_WORK_ORDER_NUMBER"].ToString()
});
}
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE GETTING MURAN MATERIAL PARCELS DATA " + ex.ToString());
}
if (parcels.Count > 0)
{
for (int i = 0; i < parcels.Count; i++)
{
parcels_cut_printed_parcels_grid_view.Rows.Add(new string[] { (i + 1).ToString(), parcels[i].SH_CLIENT_NAME, parcels[i].SH_PRODUCT_NAME, parcels[i].SH_TOTAL_NUMBER_OF_BOTTELS.ToString(), parcels[i].SH_NUMBER_OF_SEQUENCES.ToString() });
}
}
}
void loadDataGridEmployees()
{
supply_contacts.Clear();
try
{
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand("select * from SH_SUPPLIER_COMPANY_CONTACTS where SH_SUPPLIER_COMPANY_CONTACT_ID=@id", DatabaseConnection.mConnection);
cmd.Parameters.AddWithValue("@id", Mcompany.SH_ID);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
supply_contacts.Add(new SH_SUPPLIER_COMPANY_CONTACTS {
SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_SUPPLIER_COMPANY_CONTACT_EMAIL = reader["SH_SUPPLIER_COMPANY_CONTACT_EMAIL"].ToString(), SH_SUPPLIER_COMPANY_CONTACT_TELEPHONE = reader["SH_SUPPLIER_COMPANY_CONTACT_TELEPHONE"].ToString(), SH_SUPPLIER_COMPANY_CONTACT_NAME = reader["SH_SUPPLIER_COMPANY_CONTACT_NAME"].ToString()
});
}
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE GETTING Supplier employees Contacts " + ex.ToString());
}
}
void loadPrintedMaterial(SH_PRINTED_MATERIAL_PARCEL myparcel)
{
try
{
string query = "SELECT * FROM SH_SPECIFICATION_OF_PRINTED_MATERIAL WHERE SH_ID = @SH_ID ";
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
cmd.Parameters.AddWithValue("@SH_ID", myparcel.SH_SPECIFICATION_OF_PRINTED_MATERIAL_ID);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
specifPrntMaterialLst.Add(new SH_SPECIFICATION_OF_PRINTED_MATERIAL {
SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_ITEM_COATING = reader["SH_ITEM_COATING"].ToString(), SH_ITEM_CODE = reader["SH_ITEM_CODE"].ToString(), SH_ITEM_FINISH = reader["SH_ITEM_FINISH"].ToString(), SH_ITEM_LENGTH = long.Parse(reader["SH_ITEM_LENGTH"].ToString()), SH_ITEM_SHEET_WEIGHT = long.Parse(reader["SH_ITEM_SHEET_WEIGHT"].ToString()), SH_ITEM_TEMPER = reader["SH_ITEM_TEMPER"].ToString(), SH_ITEM_THICKNESS = double.Parse(reader["SH_ITEM_THICKNESS"].ToString()), SH_ITEM_TOTAL_GROSS_WEIGHT = double.Parse(reader["SH_ITEM_TOTAL_GROSS_WEIGHT"].ToString()), SH_ITEM_TOTAL_NET_WEIGHT = double.Parse(reader["SH_ITEM_TOTAL_NET_WEIGHT"].ToString()), SH_ITEM_TOTAL_NO_PARCELS = long.Parse(reader["SH_ITEM_TOTAL_NO_PARCELS"].ToString()), SH_ITEM_TOTAL_NO_SHEETS = long.Parse(reader["SH_ITEM_TOTAL_NO_SHEETS"].ToString()), SH_ITEM_TYPE = reader["SH_ITEM_TYPE"].ToString(), SH_ITEM_WIDTH = double.Parse(reader["SH_ITEM_WIDTH"].ToString())
});
}
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERRO WHILE GETTING printed material DATA FROM DB " + ex.ToString());
}
}
void loadaallsizes()
{
sizes.Clear();
try
{
string query = "SELECT * FROM SH_ITEM_SIZE";
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
sizes.Add(new SH_ITEM_SIZE()
{
SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_SIZE_FIRST_DIAMETER = double.Parse(reader["SH_SIZE_FIRST_DIAMETER"].ToString()), SH_SIZE_FIRST_DIAMETER_NAME = reader["SH_SIZE_FIRST_DIAMETER_NAME"].ToString(), SH_SIZE_NAME = reader["SH_SIZE_NAME"].ToString(), SH_SIZE_SECOND_DIAMETER = double.Parse(reader["SH_SIZE_SECOND_DIAMETER"].ToString()), SH_SIZE_SECOND_DIAMETER_NAME = reader["SH_SIZE_SECOND_DIAMETER_NAME"].ToString(), SH_SIZE_SHAPE_NAME = reader["SH_SIZE_SHAPE_NAME"].ToString(), SH_SIZE_SURROUNDING = double.Parse(reader["SH_SIZE_SURROUNDING"].ToString())
});
}
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE LOADING DB" + ex.ToString());
}
}
void loadallrawmaterialparcels()
{
try
{
string query = "SELECT * FROM SH_RAW_MATERIAL_PARCEL";
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
parcels.Add(new SH_RAW_MATERIAL_PARCEL()
{
SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_ITEM_LENGTH = double.Parse(reader["SH_ITEM_LENGTH"].ToString()), SH_ITEM_WIDTH = double.Parse(reader["SH_ITEM_WIDTH"].ToString()), SH_ITEM_THICKNESS = double.Parse(reader["SH_ITEM_THICKNESS"].ToString()), SH_ITEM_CODE = reader["SH_ITEM_CODE"].ToString(), SH_ITEM_COATING = reader["SH_ITEM_COATING"].ToString(), SH_ITEM_TYPE = reader["SH_ITEM_TYPE"].ToString()
});
}
myconnection.closeConnection();
// MessageBox.Show("GET ALL DATA");
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE LOADING PARCELS DATA" + ex.ToString());
}
}
void getallclientandproductparcels(long client_id, long product_id)
{
try
{
string query = "SELECT * FROM SH_PRINTED_MATERIAL_PARCEL WHERE SH_ID IN ( SELECT SH_PRINTED_MATERIAL_PARCEL_ID FROM SH_PRODUCT_OF_CLIENTS_PARCELS WHERE(SH_CLIENT_ID = @SH_CLIENT_ID AND SH_CLIENT_PRODUCT_ID = @SH_CLIENT_PRODUCT_ID) AND ( SH_PRINTED_MATERIAL_PARCEL_ID NOT IN (SELECT SH_PRINTED_MATERIAL_PARCEL_ID FROM SH_EXCHANGED_PRINTED_MATERIAL_PARCELS)) )";
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
cmd.Parameters.AddWithValue("@SH_CLIENT_PRODUCT_ID", product_id);
cmd.Parameters.AddWithValue("@SH_CLIENT_ID", client_id);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
parcels.Add(new SH_PRINTED_MATERIAL_PARCEL()
{
SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_ADDITION_DATE = DateTime.Parse(reader["SH_ADDITION_DATE"].ToString()), SH_ITEM_COATING = reader["SH_ITEM_COATING"].ToString(), SH_ITEM_CODE = reader["SH_ITEM_CODE"].ToString(), SH_ITEM_FINISH = reader["SH_ITEM_FINISH"].ToString(), SH_ITEM_LENGTH = double.Parse(reader["SH_ITEM_LENGTH"].ToString()), SH_ITEM_SHEET_WEIGHT = double.Parse(reader["SH_ITEM_SHEET_WEIGHT"].ToString()), SH_ITEM_TEMPER = reader["SH_ITEM_TEMPER"].ToString(), SH_ITEM_THICKNESS = double.Parse(reader["SH_ITEM_THICKNESS"].ToString()), SH_ITEM_TOTAL_GROSS_WEIGHT = double.Parse(reader["SH_ITEM_GROSS_WEIGHT"].ToString()), SH_ITEM_TOTAL_NET_WEIGHT = double.Parse(reader["SH_ITEM_NET_WEIGHT"].ToString()), SH_ITEM_TOTAL_NO_SHEETS = long.Parse(reader["SH_ITEM_NO_SHEETS"].ToString()), SH_ITEM_TYPE = reader["SH_ITEM_TYPE"].ToString(), SH_ITEM_WIDTH = double.Parse(reader["SH_ITEM_WIDTH"].ToString()), SH_PARCEL_NET_WEIGHT = double.Parse(reader["SH_ITEM_NET_WEIGHT"].ToString()), SH_PARCEL_NO_SHEETS = long.Parse(reader["SH_ITEM_NO_SHEETS"].ToString()), SH_PRINTER_ID = long.Parse(reader["SH_PRINTER_ID"].ToString()), SH_PRINTER_NAME = reader["SH_PRINTER_NAME"].ToString(), SH_PRINTING_PERMISSION_NUMBER = reader["SH_PRINTING_PERMISSION_NUMBER"].ToString(), SH_QUANTITIES_OF_PRINTED_MATERIAL_ID = long.Parse(reader["SH_QUANTITIES_OF_PRINTED_MATERIAL_ID"].ToString()), SH_SPECIFICATION_OF_PRINTED_MATERIAL_ID = reader["SH_SPECIFICATION_OF_PRINTED_MATERIAL_ID"].ToString(), SH_STOCK_NAME = reader["SH_STOCK_NAME"].ToString(), SH_TOTAL_NUMBER_OF_BOTTELS = long.Parse(reader["SH_TOTAL_NUMBER_OF_BOTTELS"].ToString()), SH_WORK_ORDER_NUMBER = reader["SH_WORK_ORDER_NUMBER"].ToString()
});
}
myconnection.closeConnection();
}catch (Exception ex)
{
MessageBox.Show("ERROR WHILE GETTING PRINTED PARCELS " + ex.ToString());
}
}
void getallquantities()
{
string client_name = "";
bool client_data = false;
string client_branch_name = "";
bool client_branch_data = false;
if (string.IsNullOrWhiteSpace(clients_combo_box.Text))
{
client_name = "";
client_data = false;
}
else
{
client_name = " AND SRPI.SH_CLIENT_ID = @SH_CLIENT_ID";
client_data = true;
}
if (string.IsNullOrWhiteSpace(client_branches_combo_box.Text))
{
client_branch_name = "";
client_branch_data = false;
}
else
{
client_branch_name = " AND SRPI.SH_CLIENT_BRANCH_ID =@SH_CLIENT_BRANCH_ID ";
client_branch_data = true;
}
mydata.Clear();
try
{
myconnection.openConnection();
string query = "SELECT SRPI.SH_CLIENT_ID , ";
query += "(select cc.SH_CLIENT_COMPANY_NAME from SH_CLIENT_COMPANY cc where cc.SH_ID = SRPI.SH_CLIENT_ID ) as client_name, ";
query += " (SELECT CCB.SH_CLIENT_BRANCH_NAME FROM SH_CLIENTS_BRANCHES CCB WHERE CCB.SH_ID = SRPI.SH_CLIENT_BRANCH_ID ) ";
query += " AS CLIENT_BRANCH_NAME ,";
query += " SRPQI.SH_ITEM_NAME , SRPQI.SH_ITEM_CONTAINER , ";
query += " sum(SRPQI.SH_NO_CONTAINERS) as number_containers , sum(SRPQI.SH_TOTAL_NO_ITEMS) as total_quantity ";
query += " FROM SH_RECEIVING_PERMISSION_ITEMS_QUANTITIES_INFORMATION SRPQI ";
query += " left join SH_RECEIVING_PERMISSION_INFORMATION SRPI ";
query += " on SRPQI.SH_RECEIVING_PERMISSION_INFORMATION_ID = SRPI.SH_ID ";
query += " where 1 = 1 " + client_name + client_branch_name;
query += " group by SRPI.SH_CLIENT_ID ,SRPI.SH_CLIENT_BRANCH_ID ,";
query += " SRPQI.SH_ITEM_NAME ,SRPQI.SH_ITEM_CONTAINER ";
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
if (client_data)
{
cmd.Parameters.AddWithValue("@SH_CLIENT_ID", clients[clients_combo_box.SelectedIndex].SH_ID);
}
if (client_branch_data)
{
cmd.Parameters.AddWithValue("@SH_CLIENT_BRANCH_ID", client_branches[client_branches_combo_box.SelectedIndex].SH_ID);
}
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
mydata.Add(new summary_receiving_information_quantity_data()
{
client_name = reader["client_name"].ToString(),
client_branch_name = reader["CLIENT_BRANCH_NAME"].ToString(),
item_name = reader["SH_ITEM_NAME"].ToString(),
client_id = long.Parse(reader["SH_CLIENT_ID"].ToString()),
no_containers = long.Parse(reader["number_containers"].ToString()),
no_items = long.Parse(reader["total_quantity"].ToString()),
container_name = reader["SH_ITEM_CONTAINER"].ToString()
});
}
reader.Close();
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE GETTING CLIENTS SUMMARY DATA " + ex.ToString());
}
if (mydata.Count > 0)
{
receving_permission_quantities_grid_view.Rows.Clear();
for (int i = 0; i < mydata.Count; i++)
{
string[] mydatavalues = new string[7];
mydatavalues[0] = (i + 1).ToString();
mydatavalues[1] = (mydata[i].client_name).ToString();
mydatavalues[2] = (mydata[i].client_branch_name).ToString();
mydatavalues[3] = (mydata[i].item_name).ToString();
mydatavalues[4] = (mydata[i].container_name).ToString();
mydatavalues[5] = (mydata[i].no_containers).ToString();
mydatavalues[6] = (mydata[i].no_items).ToString();
receving_permission_quantities_grid_view.Rows.Add(mydatavalues);
}
}
}
private void printplasticcovertotalbalanceform_Load(object sender, EventArgs e)
{
long no_items = 0;
long no_containers = 0;
DataTable mydatatabel = new DataTable();
mydatatabel.Columns.Add("m");
mydatatabel.Columns.Add("container_name");
mydatatabel.Columns.Add("no_items_per_container");
mydatatabel.Columns.Add("no_containers");
mydatatabel.Columns.Add("total_no_items");
mydatatabel.Columns.Add("addition_date");
mydatatabel.Columns.Add("client_name");
mydatatabel.Columns.Add("pillow_color_name");
mydatatabel.Columns.Add("size_name");
mydatatabel.Columns.Add("logo_or_not");
try
{
myconnection.openConnection();
SqlCommand cmd = new SqlCommand("SH_GET_ALL_SH_SPECIFICATION_OF_PLASTIC_COVER", DatabaseConnection.mConnection);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = cmd.ExecuteReader();
long counter = 0;
while (reader.Read())
{
counter++;
string[] mydata = new string[10];
mydata[0] = counter.ToString();
mydata[1] = reader["SH_CONTAINER_NAME"].ToString();
mydata[2] = reader["SH_NO_ITEMS"].ToString();
mydata[3] = reader["NO_ITEMS"].ToString();
no_containers += long.Parse(reader["NO_ITEMS"].ToString());
mydata[4] = reader["TOTAL_NO_ITEMS"].ToString();
no_items += long.Parse(reader["TOTAL_NO_ITEMS"].ToString());
mydata[5] = reader["SH_ADDTION_DATE"].ToString();
mydata[6] = reader["CLIENT_NAME"].ToString();
mydata[7] = reader["PILLOW_COLOR_NAME"].ToString();
mydata[8] = reader["SIZE_NAME"].ToString();
if (long.Parse(reader["SH_LOGO_OR_NOT"].ToString()) == 0)
{
mydata[9] = "N";
}
else
{
mydata[9] = "Y";
}
mydatatabel.Rows.Add(mydata);
}
reader.Close();
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHIlE GETTInG PLASTIC COVER DATA " + ex.ToString());
}
ReportParameter[] myparams = new ReportParameter[3];
myparams[0] = new ReportParameter("report_presenter_name", mEmployee.SH_EMPLOYEE_NAME, false);
myparams[1] = new ReportParameter("total_no_containers", no_containers.ToString(), false);
myparams[2] = new ReportParameter("total_no_items", no_items.ToString(), false);
this.reportViewer1.LocalReport.SetParameters(myparams);
ReportDataSource rds = new ReportDataSource("DataSet1", mydatatabel);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(rds);
this.reportViewer1.RefreshReport();
}
private void search_properties_Click(object sender, EventArgs e)
{
double testnumber = 0;
bool length = false;
bool width = false;
bool thickness = false;
bool temper = false;
bool coating = false;
bool code = false;
bool finish = false;
bool type = false;
string mlength = "";
string mwidth = "";
string mthickness = "";
string mtemper = "";
string caoting = "";
string mcode = "";
string mfinish = "";
string mtype = "";
if (string.IsNullOrEmpty(item_length_text_box.Text))
{
mlength = "";
}
else if (double.TryParse(item_length_text_box.Text, out testnumber))
{
length = true;
mlength = " AND (srm.SH_ITEM_LENGTH = @SH_ITEM_LENGTH) ";
}
else
{
mlength = "";
}
if (string.IsNullOrEmpty(item_width_text_box.Text))
{
mwidth = "";
}
else if (double.TryParse(item_width_text_box.Text, out testnumber))
{
width = true;
mwidth = " AND (srm.SH_ITEM_WIDTH = @SH_ITEM_WIDTH) ";
}
else
{
mwidth = "";
}
if (string.IsNullOrEmpty(item_thickness_text_box.Text))
{
mthickness = "";
}
else if (double.TryParse(item_thickness_text_box.Text, out testnumber))
{
thickness = true;
mthickness = "AND (srm.SH_ITEM_THICKNESS = @SH_ITEM_THICKNESS)";
}
else
{
mthickness = "";
}
if (string.IsNullOrEmpty(item_temper_text_box.Text))
{
mtemper = "";
}
else
{
temper = true;
mtemper = " AND (srm.SH_ITEM_TEMPER LIKE N'%@SH_ITEM_TEMPER' || srm.SH_ITEM_TEMPER LIKE N'%@SH_ITEM_TEMPER%' || srm.SH_ITEM_TEMPER LIKE N'@SH_ITEM_TEMPER%' )";
}
if (string.IsNullOrEmpty(item_code_text_box.Text))
{
mcode = "";
}
else
{
code = true;
mcode = " AND (srm.SH_ITEM_CODE LIKE N'%@SH_ITEM_CODE' ||srm.SH_ITEM_CODE LIKE N'%@SH_ITEM_CODE%' || srm.SH_ITEM_CODE LIKE N'@SH_ITEM_CODE%' )";
}
if (string.IsNullOrEmpty(item_finish_text_box.Text))
{
mfinish = "";
}
else
{
finish = true;
mfinish = "AND (srm.SH_ITEM_FINISH LIKE N'%@SH_ITEM_FINISH' ||srm.SH_ITEM_FINISH LIKE N'%@SH_ITEM_FINISH%' ||srm.SH_ITEM_FINISH LIKE N'@SH_ITEM_FINISH%')";
}
if (string.IsNullOrEmpty(item_type_text_box.Text))
{
mtype = "";
}
else
{
type = true;
mtype = "AND (srm.SH_ITEM_TYPE LIKE N'%@SH_ITEM_TYPE' || srm.SH_ITEM_TYPE LIKE N'%@SH_ITEM_TYPE%' || srm.SH_ITEM_TYPE LIKE N'@SH_ITEM_TYPE%' )";
}
try
{
string query = "SELECT * FROM SH_RAW_MATERIAL_PARCEL srm WHERE ( TRUE " + mlength + mwidth + mthickness + mcode + mfinish + mtemper + mtype + " ) AND NOT EXISTS (SELECT * FROM SH_MINUTES_PACKAGES_EXAMINED_RAW_MATERIAL mperm where mperm.SH_ITEM_PRACEL_ID = srm.SH_ID) ";
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
if (length)
{
cmd.Parameters.AddWithValue("", "");
}
myconnection.closeConnection();
}
catch (Exception)
{
throw;
}
}
void fillallsoldquantities()
{
mydata.Clear();
string client_name = "";
bool client_data = false;
string client_branch_name = "";
bool client_branch_data = false;
if (string.IsNullOrWhiteSpace(clients_combo_box.Text))
{
client_name = "";
client_data = false;
}
else
{
client_name = " AND SRPI.SH_CLIENT_ID = @SH_CLIENT_ID";
client_data = true;
}
if (string.IsNullOrWhiteSpace(client_branches_combo_box.Text))
{
client_branch_name = "";
client_branch_data = false;
}
else
{
client_branch_name = " AND SRPI.SH_CLIENT_BRANCH_ID =@SH_CLIENT_BRANCH_ID ";
client_branch_data = true;
}
try
{
myconnection.openConnection();
string query = " select SRPI.SH_RECEIVING_PERMISSION_NUMBER, SRPI.SH_ADDITION_DATE, ";
query += " CC.SH_CLIENT_COMPANY_NAME , CCB.SH_CLIENT_BRANCH_NAME ,SEPIQI.SH_ITEM_NAME , ";
query += " SEPIQI.SH_ITEM_CONTAINER ,SEPIQI.SH_NO_ITEMS_PER_CONTAINER,SEPIQI.SH_NO_CONTAINERS ,SEPIQI.SH_TOTAL_NO_ITEMS , ";
query += " SRPI.SH_DRIVER_NAME,SS.SH_STOCK_NAME , SEMP.SH_EMPLOYEE_NAME ";
query += " from SH_RECEIVING_PERMISSION_ITEMS_QUANTITIES_INFORMATION SEPIQI ";
query += " left join SH_RECEIVING_PERMISSION_INFORMATION SRPI ";
query += " on SEPIQI.SH_RECEIVING_PERMISSION_INFORMATION_ID = SRPI.SH_ID ";
query += " LEFT JOIN SH_CLIENT_COMPANY CC ON ";
query += " CC.SH_ID = SRPI.SH_CLIENT_ID ";
query += " LEFT JOIN SH_CLIENTS_BRANCHES CCB ON ";
query += " CCB.SH_ID = SRPI.SH_CLIENT_BRANCH_ID ";
query += " LEFT JOIN SH_SHAHEEN_STOCKS SS ON ";
query += " SS.SH_ID = SRPI.SH_STOCK_ID ";
query += " LEFT JOIN SH_EMPLOYEES SEMP ON ";
query += " SEMP.SH_ID = SRPI.SH_STOCK_MAN_ID ";
query += " WHERE 1=1 " + client_name + client_branch_name;
query += " AND SRPI.SH_ADDITION_DATE BETWEEN @date_one AND @date_two ";
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
cmd.Parameters.AddWithValue("@date_one", DateTime.Parse(start_date_one.Text));
cmd.Parameters.AddWithValue(" @date_two", DateTime.Parse(end_date_two.Text));
if (client_data)
{
cmd.Parameters.AddWithValue("@SH_CLIENT_ID", clients[clients_combo_box.SelectedIndex].SH_ID);
}
if (client_branch_data)
{
cmd.Parameters.AddWithValue("@SH_CLIENT_BRANCH_ID", client_branches[client_branches_combo_box.SelectedIndex].SH_ID);
}
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
mydata.Add(new allsolditemsfullinformationdetails()
{
client_branch_name = reader["SH_CLIENT_BRANCH_NAME"].ToString(),
client_name = reader["SH_CLIENT_COMPANY_NAME"].ToString(),
container_name = reader["SH_ITEM_CONTAINER"].ToString(),
driver_name = reader["SH_DRIVER_NAME"].ToString(),
//no_carton_dividers = long.Parse(),
no_containers = long.Parse(reader["SH_NO_CONTAINERS"].ToString()),
no_items_per_container = long.Parse(reader["SH_NO_ITEMS_PER_CONTAINER"].ToString()),
//no_pallets = long.Parse(),
//no_wooden_faces = long.Parse(),
receival_permission_date = DateTime.Parse(reader["SH_ADDITION_DATE"].ToString()),
receival_permission_number = reader["SH_RECEIVING_PERMISSION_NUMBER"].ToString(),
stock_man_name = reader["SH_EMPLOYEE_NAME"].ToString(),
stock_name = reader["SH_STOCK_NAME"].ToString(),
total_number_of_items = long.Parse(reader["SH_TOTAL_NO_ITEMS"].ToString())
});
}
reader.Close();
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE GETTING SOLD DATA " + ex.ToString());
}
if (mydata.Count > 0)
{
total_receival_information_quantities_data_grid_view.Rows.Clear();
for (int i = 0; i < mydata.Count; i++)
{
string[] myvalues = new string[13];
myvalues[0] = (i + 1).ToString();
}
}
}
async Task autogenerateadditionpermisionnumber()
{
long mycount = 0;
try
{
myconnection.openConnection();
SqlCommand cmd = new SqlCommand("SELECT (MAX(SH_ID)+1) AS lastedid FROM SH_ADDITION_PERMISSION_NUMBER_OF_PLASTIC_COVER ", DatabaseConnection.mConnection);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
if (string.IsNullOrWhiteSpace(reader["lastedid"].ToString()))
{
reader.Close();
}
else
{
mycount = long.Parse(reader["lastedid"].ToString());
}
}
reader.Close();
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("Error while getting new permission number " + ex.ToString());
}
if (mycount == 0)
{
//there is the first rows in the db
string permissionnumber = "SH_";
permissionnumber += "PLASTIC_COVER-";
permissionnumber += DateTime.Now.ToString("yy");
string currentr = 1.ToString();
for (int i = 0; i < 5 - 1; i++)
{
permissionnumber += "0";
}
permissionnumber += 1.ToString();
addition_permission_number_text_box.Text = permissionnumber;
}
else
{
string permissionnumber = "SH_";
permissionnumber += "PLASTIC_COVER-";
permissionnumber += DateTime.Now.ToString("yy");
string currentr = mycount.ToString();
for (int i = 0; i < 5 - currentr.Length; i++)
{
permissionnumber += "0";
}
permissionnumber += mycount.ToString();
addition_permission_number_text_box.Text = permissionnumber;
}
}
private void printpeelofftotalbalanceform_Load(object sender, EventArgs e)
{
//
long total_no_items = 0;
long total_no_containers = 0;
long total_no_pallets = 0;
long total_no_cartons = 0;
DataTable mydatatabel = new DataTable();
mydatatabel.Columns.Add("m");
mydatatabel.Columns.Add("item_material_type");
mydatatabel.Columns.Add("printing_type");
mydatatabel.Columns.Add("size_name");
mydatatabel.Columns.Add("client_name");
mydatatabel.Columns.Add("first_face");
mydatatabel.Columns.Add("second_face");
mydatatabel.Columns.Add("container_name");
mydatatabel.Columns.Add("no_items_per_container");
mydatatabel.Columns.Add("total_no_items");
mydatatabel.Columns.Add("usage");
mydatatabel.Columns.Add("addition_date");
try
{
myconnection.openConnection();
SqlCommand cmd = new SqlCommand("SH_GET_ALL_SH_SPECIFICATION_OF_PEEL_OFF", DatabaseConnection.mConnection);
cmd.CommandType = CommandType.StoredProcedure;
SqlDataReader reader = cmd.ExecuteReader();
long counter = 0;
while (reader.Read())
{
counter++;
string[] mydata = new string[12];
mydata[0] = counter.ToString();
mydata[1] = reader["SH_RAW_MATERIAL_TYPE"].ToString();
mydata[2] = reader["SH_PRINTING_TYPE_NAME"].ToString();
if (long.Parse(reader["SH_PRINTING_TYPE"].ToString()) == 0)
{
mydata[3] = reader["SIZE_NAME"].ToString();
mydata[4] = reader["CLIENT_NAME"].ToString();
mydata[5] = reader["CLIENT_PRODUCT_NAME"].ToString();
mydata[6] = reader["PRODUCT_SECOND_FACE"].ToString();
}
else
{
mydata[3] = reader["SIZE_NAME"].ToString();
mydata[4] = "عام";
mydata[5] = reader["FIRST_FACE"].ToString();
mydata[6] = reader["SECOND_FACE"].ToString();
}
mydata[7] = reader["SH_CONTAINER_NAME"].ToString();
if (string.Compare(reader["SH_CONTAINER_NAME"].ToString(), "بالتة") == 0)
{
total_no_pallets += long.Parse(reader["NUMBER_OF_CONTAINERS"].ToString());
}
else
{
total_no_cartons += long.Parse(reader["NUMBER_OF_CONTAINERS"].ToString());
}
total_no_containers += long.Parse(reader["NUMBER_OF_CONTAINERS"].ToString());
mydata[8] = (long.Parse(reader["NO_ITEMS"].ToString()) / long.Parse(reader["NUMBER_OF_CONTAINERS"].ToString())).ToString();
total_no_items += long.Parse(reader["NO_ITEMS"].ToString());
mydata[9] = reader["NO_ITEMS"].ToString();
mydata[10] = reader["SH_USAGE"].ToString();
mydata[11] = reader["SH_ADDITION_DATE"].ToString();
mydatatabel.Rows.Add(mydata);
}
reader.Close();
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE GETTING BOTTOM INFO " + ex.ToString());
}
ReportParameter[] myparams = new ReportParameter[6];
myparams[0] = new ReportParameter("total_no_items", total_no_items.ToString(), false);
myparams[1] = new ReportParameter("total_no_containers", total_no_containers.ToString(), false);
myparams[2] = new ReportParameter("total_no_pallets", total_no_pallets.ToString(), false);
myparams[3] = new ReportParameter("total_no_cartons", total_no_cartons.ToString(), false);
myparams[4] = new ReportParameter("report_presenter_name", mEmployee.SH_EMPLOYEE_NAME, false);
myparams[5] = new ReportParameter("doc_title_text", "الأرصدة من المنتج التام ( إيزى أوبن )", false);
this.reportViewer1.LocalReport.SetParameters(myparams);
ReportDataSource rds = new ReportDataSource("DataSet1", mydatatabel);
this.reportViewer1.LocalReport.DataSources.Clear();
this.reportViewer1.LocalReport.DataSources.Add(rds);
this.reportViewer1.RefreshReport();
}
void save_raw_tin_quantites(long specification_id)
{
for (int i = 0; i < quantities.Count; i++)
{
try
{
string query = "INSERT INTO SH_QUANTITY_OF_RAW_MATERIAL ";
query += "(SH_SPECIFICATION_OF_RAW_MATERIAL_ID, SH_ITEM_LENGTH, SH_ITEM_WIDTH,";
query += "SH_ITEM_THICKNESS, SH_ITEM_INTENSITY, SH_ITEM_TEMPER, SH_ITEM_FINISH, ";
query += "SH_ITEM_COATING, SH_ITEM_TYPE,SH_ITEM_NAME, ";
query += "SH_ITEM_CODE, SH_ITEM_SHEET_WEIGHT, SH_TOTAL_NUMBER_OF_PACKAGES, ";
query += "SH_TOTAL_NUMBER_OF_SHEETS_OF_PACKAGE, SH_NET_WEIGHT,";
query += " SH_STOCK_NAME, SH_ADDITION_DATE, SH_ITEM_GROSS_WEIGHT, ";
query += " SH_DATA_ENTRY_USER_ID, SH_DATA_ENTRY_USER_NAME, SH_DATA_ENTRY_EMPLOYEE_ID, SH_DATA_ENTRY_EMPLOYEE_NAME";
query += ") VALUES(";
query += "@SH_SPECIFICATION_OF_RAW_MATERIAL_ID,@SH_ITEM_LENGTH,@SH_ITEM_WIDTH,@SH_ITEM_THICKNESS";
query += ",@SH_ITEM_INTENSITY,@SH_ITEM_TEMPER,@SH_ITEM_FINISH,@SH_ITEM_COATING,@SH_ITEM_TYPE";
query += ",@SH_ITEM_NAME,@SH_ITEM_CODE,@SH_ITEM_SHEET_WEIGHT,@SH_TOTAL_NUMBER_OF_PACKAGES,";
query += "@SH_TOTAL_NUMBER_OF_SHEETS_OF_PACKAGE,@SH_NET_WEIGHT,@SH_STOCK_NAME,@SH_ADDITION_DATE,";
query += "@SH_ITEM_GROSS_WEIGHT , ";
query += " @SH_DATA_ENTRY_USER_ID, @SH_DATA_ENTRY_USER_NAME, @SH_DATA_ENTRY_EMPLOYEE_ID, @SH_DATA_ENTRY_EMPLOYEE_NAME";
query += ") SELECT SCOPE_IDENTITY() AS myidentity";
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
cmd.Parameters.AddWithValue("@SH_SPECIFICATION_OF_RAW_MATERIAL_ID", specification_id);
cmd.Parameters.AddWithValue("@SH_ITEM_LENGTH", double.Parse(item_length_text_box.Text));
cmd.Parameters.AddWithValue("@SH_ITEM_WIDTH", double.Parse(item_width_text_box.Text));
cmd.Parameters.AddWithValue("@SH_ITEM_THICKNESS", double.Parse(item_thickness_text_box.Text));
cmd.Parameters.AddWithValue("@SH_ITEM_INTENSITY", double.Parse(item_intensity_text_box.Text));
cmd.Parameters.AddWithValue("@SH_ITEM_TEMPER", item_temper_combo_box.Text);
cmd.Parameters.AddWithValue("@SH_ITEM_FINISH", item_finish_combo_box.Text);
cmd.Parameters.AddWithValue("@SH_ITEM_COATING", item_coating_text_box.Text);
cmd.Parameters.AddWithValue("@SH_ITEM_TYPE", item_type_combo_box.Text);
cmd.Parameters.AddWithValue("@SH_ITEM_NAME", "صفيح");
cmd.Parameters.AddWithValue("@SH_ITEM_CODE", item_code_text_box.Text);
cmd.Parameters.AddWithValue("@SH_ITEM_SHEET_WEIGHT", double.Parse(item_sheet_weight_text_box.Text));
cmd.Parameters.AddWithValue("@SH_TOTAL_NUMBER_OF_PACKAGES", quantities[i].SH_TOTAL_NUMBER_OF_PACKAGES);
cmd.Parameters.AddWithValue("@SH_TOTAL_NUMBER_OF_SHEETS_OF_PACKAGE", quantities[i].SH_TOTAL_NUMBER_OF_SHEETS_OF_PACKAGE);
cmd.Parameters.AddWithValue("@SH_NET_WEIGHT", quantities[i].SH_NET_WEIGHT);
cmd.Parameters.AddWithValue("@SH_STOCK_NAME", quantities[i].SH_STOCK_NAME);
cmd.Parameters.AddWithValue("@SH_ADDITION_DATE", DateTime.Parse(addition_date_text_box.Text));
cmd.Parameters.AddWithValue("@SH_ITEM_GROSS_WEIGHT", quantities[i].SH_ITEM_GROSS_WEIGHT);
cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_USER_ID", mAccount.SH_ID);
cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_USER_NAME ", mAccount.SH_EMP_USER_NAME);
cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_EMPLOYEE_ID", mAccount.SH_EMP_ID);
cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_EMPLOYEE_NAME", mAccount.SH_EMP_NAME);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
//MessageBox.Show("Quantity : "+reader["myidentity"].ToString());
save_raw_tin_packages(specification_id, i, long.Parse(reader["myidentity"].ToString()), quantities[i].SH_TOTAL_NUMBER_OF_PACKAGES);
}
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE SAVING IN SH_QUANTITY_OF_RAW_MATERIAL" + ex.ToString());
}
}
}
async Task getstocksmantoexamination()
{
stock_men.Clear();
try
{
string query = "SELECT EMP.* FROM SH_EMPLOYEES EMP ";
query += " LEFT JOIN SH_DEPARTEMENTS DPT ON ";
query += " DPT.SH_ID = EMP.SH_DEPARTMENT_ID ";
query += " WHERE DPT.SH_DEPARTEMNT_NAME LIKE N'%مخازن%' ";
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
stock_men.Add(new SH_EMPLOYEES()
{
SH_DATA_ENTRY_EMPLOYEE_ID = long.Parse(reader["SH_DATA_ENTRY_EMPLOYEE_ID"].ToString()),
SH_DATA_ENTRY_EMPLOYEE_NAME = reader["SH_DATA_ENTRY_EMPLOYEE_NAME"].ToString(),
SH_DATA_ENTRY_USER_ID = long.Parse(reader["SH_DATA_ENTRY_USER_ID"].ToString()),
SH_DATA_ENTRY_USER_NAME = reader["SH_DATA_ENTRY_USER_NAME"].ToString(),
SH_DEPARTMENT_ID = long.Parse(reader["SH_DEPARTMENT_ID"].ToString()),
SH_DEPARTMENT_NAME = reader["SH_DEPARTMENT_NAME"].ToString(),
SH_EMPLOYEE_ADDRESS = reader["SH_EMPLOYEE_ADDRESS"].ToString(),
SH_EMPLOYEE_EMAIL = reader["SH_EMPLOYEE_EMAIL"].ToString(),
SH_EMPLOYEE_FUNCTION_ID = long.Parse(reader["SH_EMPLOYEE_FUNCTION_ID"].ToString()),
SH_EMPLOYEE_FUNCTION_NAME = reader["SH_EMPLOYEE_FUNCTION_NAME"].ToString(),
SH_EMPLOYEE_GENDER = reader["SH_EMPLOYEE_GENDER"].ToString(),
SH_EMPLOYEE_MOBILE = reader["SH_EMPLOYEE_MOBILE"].ToString(),
SH_EMPLOYEE_NAME = reader["SH_EMPLOYEE_NAME"].ToString(),
SH_EMPLOYEE_NATIONAL_ID = reader["SH_EMPLOYEE_NATIONAL_ID"].ToString(),
SH_ID = long.Parse(reader["SH_ID"].ToString()),
SH_EMPLOYEMENT_DATE = DateTime.Parse(reader["SH_EMPLOYEMENT_DATE"].ToString())
});
}
reader.Close();
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE GETTING STOCK_MEN " + ex.ToString());
}
if (stock_men.Count > 0)
{
monitors_one.Items.Clear();
monitors_two.Items.Clear();
monitor_one_combo_box.Items.Clear();
monitor_two_combo_box.Items.Clear();
for (int i = 0; i < stock_men.Count; i++)
{
monitors_one.Items.Add(stock_men[i].SH_EMPLOYEE_NAME);
monitors_two.Items.Add(stock_men[i].SH_EMPLOYEE_NAME);
monitor_one_combo_box.Items.Add(stock_men[i].SH_EMPLOYEE_NAME);
monitor_two_combo_box.Items.Add(stock_men[i].SH_EMPLOYEE_NAME);
}
}
}
async Task getmuranmaterialdata()
{
bool client = false;
string client_q = "";
bool product = false;
string product_q = "";
if (string.IsNullOrWhiteSpace(client_name_combo_box.Text))
{
client = false;
}
else
{
client = true;
client_q = "AND SH_CLIENT_ID = @SH_CLIENT_ID";
}
//if (string.IsNullOrWhiteSpace(client_products_combo_box.Text))
//{
// product = false;
//}
//else
//{
// product = true;
// product_q = " AND SH_CLIENT_PRODUCT_ID = @SH_CLIENT_PRODUCT_ID";
//}
try
{
myconnection.openConnection();
string query = "SELECT * FROM SH_SPECIFICATION_OF_MURAN_MATERIAL WHERE 1=1 " + client_q;
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
if (client)
{
cmd.Parameters.AddWithValue("@SH_CLIENT_ID", clients[client_name_combo_box.SelectedIndex].SH_ID);
}
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
materials.Add(new client_material_balance_items()
{
container_name = "طرد",
material_name = "صفيح مطبوع",
no_of_containers = long.Parse(reader["SH_ITEM_TOTAL_NUMBER_OF_PACKAGES"].ToString()),
total_no_items = long.Parse(reader["SH_ITEM_TOTAL_NUMBER_OF_SHEETS"].ToString())
});
}
reader.Close();
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE GETTING MURAN MATERIAL INFO " + ex.ToString());
}
}
private void bttnSave_Click(object sender, EventArgs e)
{
if (WithErrors() == true)
{
MessageBox.Show("من فضلك اكمل باقى البيانات");
}
else
{
if (txtTitle.Text.Trim() != "")
{
if (strFilePath == "")
{
if (ImageByteArray.Length != 0)
{
ImageByteArray = new byte[] { }
}
;
}
else
{
Image temp = new Bitmap(strFilePath);
MemoryStream strm = new MemoryStream();
temp.Save(strm, System.Drawing.Imaging.ImageFormat.Jpeg);
ImageByteArray = strm.ToArray();
}
try
{
string query = "INSERT INTO SH_EMPLOYEES ";
query += "(SH_EMPLOYEE_NAME, SH_EMPLOYEE_NATIONAL_ID, SH_EMPLOYEE_ADDRESS, SH_EMPLOYEE_MOBILE, SH_EMPLOYEE_GENDER, SH_EMPLOYEE_EMAIL, SH_EMPLOYEMENT_DATE, SH_EMPLOYEE_FUNCTION_ID,";
query += " SH_EMPLOYEE_FUNCTION_NAME, SH_DATA_ENTRY_USER_ID,SH_DATA_ENTRY_USER_NAME, SH_DATA_ENTRY_EMPLOYEE_ID, SH_DATA_ENTRY_EMPLOYEE_NAME ,SH_DEPARTMENT_ID ,SH_DEPARTMENT_NAME ,SH_EMPLOYEE_IMAGE ";
query += " , SH_SOCIAL_INSURANCE_NUMBER ,SH_HEALTH_INSURANCE_NUMBER )";
query += " VALUES(@SH_EMPLOYEE_NAME,@SH_EMPLOYEE_NATIONAL_ID,@SH_EMPLOYEE_ADDRESS,@SH_EMPLOYEE_MOBILE,@SH_EMPLOYEE_GENDER,@SH_EMPLOYEE_EMAIL,@SH_EMPLOYEMENT_DATE,@SH_EMPLOYEE_FUNCTION_ID,";
query += " @SH_EMPLOYEE_FUNCTION_NAME,@SH_DATA_ENTRY_USER_ID,@SH_DATA_ENTRY_USER_NAME,@SH_DATA_ENTRY_EMPLOYEE_ID,@SH_DATA_ENTRY_EMPLOYEE_NAME , @SH_DEPARTMENT_ID , @SH_DEPARTMENT_NAME , @SH_EMPLOYEE_IMAGE ";
query += " , @SH_SOCIAL_INSURANCE_NUMBER ,@SH_HEALTH_INSURANCE_NUMBER )";
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand comm = new SqlCommand(query, DatabaseConnection.mConnection);
comm.Parameters.AddWithValue("@SH_EMPLOYEE_NAME", txtEmpName.Text);
comm.Parameters.AddWithValue("@SH_EMPLOYEE_NATIONAL_ID", txtEmpNationalID.Text);
comm.Parameters.AddWithValue("@SH_EMPLOYEE_ADDRESS", txtEmpAddress.Text);
if (radioFemale.Checked == true)
{
comm.Parameters.AddWithValue("@SH_EMPLOYEE_GENDER", radioFemale.Text);
}
else
if (radioMale.Checked == true)
{
comm.Parameters.AddWithValue("@SH_EMPLOYEE_GENDER", radioMale.Text);
}
else
{
MessageBox.Show("ادخل نوع الموظف");
}
comm.Parameters.AddWithValue("@SH_EMPLOYEE_MOBILE", txtEmpMobile.Text);
comm.Parameters.AddWithValue("@SH_EMPLOYEE_EMAIL", txtEmpEmail.Text);
comm.Parameters.AddWithValue("@SH_EMPLOYEMENT_DATE", Convert.ToDateTime(dateTimePicker1.Text));
comm.Parameters.AddWithValue("@SH_EMPLOYEE_FUNCTION_ID", jobList[comboBoxFn.SelectedIndex].SH_ID);
comm.Parameters.AddWithValue("@SH_EMPLOYEE_FUNCTION_NAME", jobList[comboBoxFn.SelectedIndex].SH_FUNCTION_NAME);
comm.Parameters.AddWithValue("@SH_DEPARTMENT_ID", deptList[comboBoxDept.SelectedIndex].SH_ID);
comm.Parameters.AddWithValue("@SH_DEPARTMENT_NAME", deptList[comboBoxDept.SelectedIndex].SH_DEPARTEMNT_NAME);
comm.Parameters.AddWithValue("@SH_DATA_ENTRY_USER_ID", maccount.SH_ID);
comm.Parameters.AddWithValue("@SH_DATA_ENTRY_USER_NAME", maccount.SH_EMP_NAME);
comm.Parameters.AddWithValue("@SH_DATA_ENTRY_EMPLOYEE_ID", memployee.SH_ID);
comm.Parameters.AddWithValue("@SH_DATA_ENTRY_EMPLOYEE_NAME", memployee.SH_EMPLOYEE_NAME);
comm.Parameters.AddWithValue("@SH_EMPLOYEE_IMAGE", ImageByteArray);
comm.Parameters.AddWithValue("@SH_SOCIAL_INSURANCE_NUMBER", social_insurance_number_text_box.Text);
comm.Parameters.AddWithValue("@SH_HEALTH_INSURANCE_NUMBER", health_insurance_number_text_box.Text);
comm.ExecuteNonQuery();
myconnection.closeConnection();
MessageBox.Show(" تم تسجيل الموظف بنجاح");
// bttnSave.Enabled = false;
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE ADDING NEW EMPLOYEES " + ex.Message);
}
}
}
}
void getDeptID()
{
try
{
string query = "select * from SH_FUNCTION where SH_DEPARTEMENT_ID=@id";
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
cmd.Parameters.AddWithValue("@id", deptList[comboBoxDept.SelectedIndex].SH_ID);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
jobList.Add(new SH_FUNCTION()
{
SH_ID = long.Parse(reader["SH_ID"].ToString()), SH_DEPARTEMENT_NAME = reader["SH_DEPARTEMENT_NAME"].ToString(), SH_DEPARTEMENT_ID = long.Parse(reader["SH_DEPARTEMENT_ID"].ToString()), SH_FUNCTION_NAME = reader["SH_FUNCTION_NAME"].ToString()
});
}
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("error in getting deptID" + ex.ToString());
}
}
void fillJobCombobox()
{
jobList.Clear();
comboBoxFn.Items.Clear();
getDeptID();
if (jobList.Count <= 0)
{
}
else
{
for (int i = 0; i < jobList.Count; i++)
{
comboBoxFn.Items.Add(jobList[i].SH_FUNCTION_NAME);
}
}
}
private async void save_company_btn_Click(object sender, EventArgs e)
{
if (string.IsNullOrEmpty(client_company_fax_number_text_box.Text) || string.IsNullOrEmpty(company_telephone_text_box.Text) || string.IsNullOrEmpty(company_telephone_text_box.Text))
{
MessageBox.Show("إملاء البيانات من فضلك", "تحذير", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
}
else
{
if ((errorProvider1.GetError(company_telephone_text_box) == "") && (errorProvider1.GetError(company_telephone_text_box) == ""))
{
if (mclient == null)
{
//new client
if (await check_if_name_exits_or_not())
{
MessageBox.Show("هذا العميل تم إضافته مسبقا", "تحذير", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
}
else
{
string company_type_text_box = "";
if (national_client_radio_btn.Checked)
{
company_type_text_box = "محلى";
}
else
{
company_type_text_box = "دولى";
}
string query = "INSERT INTO SH_CLIENT_COMPANY";
query += " (SH_CLIENT_COMPANY_NAME, SH_CLIENT_COMPANY_TYPE,";
query += " SH_CLIENT_COMPANY_TELEPHONE, ";
query += " SH_CLIENT_COMPANY_FAX_NUMBER,SH_CLIENT_COMPANY_MOBILE ";
query += ", SH_DATA_ENTRY_USER_ID,SH_DATA_ENTRY_EMPLOYEE_ID,SH_ADDITION_DATE ";
query += " ) VALUES ";
query += " (@SH_CLIENT_COMPANY_NAME,@SH_CLIENT_COMPANY_TYPE,@SH_CLIENT_COMPANY_TELEPHONE , ";
query += " @SH_CLIENT_COMPANY_FAX_NUMBER,@SH_CLIENT_COMPANY_MOBILE ";
query += " , @SH_DATA_ENTRY_USER_ID,@SH_DATA_ENTRY_EMPLOYEE_ID,@SH_ADDITION_DATE ";
query += " ) ";
try
{
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_NAME", company_name_text_box.Text);
cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_TYPE", company_type_text_box);
cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_TELEPHONE", company_telephone_text_box.Text);
cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_FAX_NUMBER", client_company_fax_number_text_box.Text);
cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_MOBILE", textBoxMobile.Text);
cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_USER_ID", mAccount.SH_ID);
cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_EMPLOYEE_ID", mAccount.SH_EMP_ID);
cmd.Parameters.AddWithValue("@SH_ADDITION_DATE", DateTime.Now);
cmd.ExecuteNonQuery();
myconnection.closeConnection();
MessageBox.Show("تم الحفظ بنجاح", "معلومات", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
company_name_text_box.Text = "";
company_telephone_text_box.Text = "";
client_company_fax_number_text_box.Text = "";
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE SAVING CLIENT COMPANY" + ex.ToString());
}
}
}
else //edite client data
{
if (await check_if_name_exits_or_not())
{
MessageBox.Show("هذا العميل تم إضافته مسبقا", "تحذير", MessageBoxButtons.OK, MessageBoxIcon.Warning, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
}
else
{
string company_type_text_box = "";
if (national_client_radio_btn.Checked)
{
company_type_text_box = "محلى";
}
else
{
company_type_text_box = "دولى";
}
string query = " UPDATE SH_CLIENT_COMPANY SET SH_CLIENT_COMPANY_NAME = @SH_CLIENT_COMPANY_NAME, ";
query += "SH_CLIENT_COMPANY_TYPE = @SH_CLIENT_COMPANY_TYPE, SH_CLIENT_COMPANY_TELEPHONE = @SH_CLIENT_COMPANY_TELEPHONE, ";
query += " SH_DATA_ENTRY_USER_ID = @SH_DATA_ENTRY_USER_ID, ";
query += " SH_DATA_ENTRY_EMPLOYEE_ID = @SH_DATA_ENTRY_EMPLOYEE_ID ,";
query += " SH_ADDITION_DATE = @SH_ADDITION_DATE , ";
query += " SH_CLIENT_COMPANY_MOBILE = @SH_CLIENT_COMPANY_MOBILE, ";
query += " SH_CLIENT_COMPANY_FAX_NUMBER = @SH_CLIENT_COMPANY_FAX_NUMBER WHERE SH_ID = @SH_ID ";
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_NAME", company_name_text_box.Text);
cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_TYPE", company_type_text_box);
cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_TELEPHONE", company_telephone_text_box.Text);
cmd.Parameters.AddWithValue("@SH_CLIENT_COMPANY_FAX_NUMBER", client_company_fax_number_text_box.Text);
cmd.Parameters.AddWithValue("@SH_ID", mclient.SH_ID);
cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_USER_ID", mAccount.SH_ID);
cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_EMPLOYEE_ID", mAccount.SH_EMP_ID);
cmd.Parameters.AddWithValue("@SH_ADDITION_DATE", DateTime.Now);
cmd.ExecuteNonQuery();
myconnection.closeConnection();
MessageBox.Show("تم التعديل بنجاح", "معلومات", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
company_name_text_box.Text = "";
company_telephone_text_box.Text = "";
client_company_fax_number_text_box.Text = "";
}
}
}
else
{
MessageBox.Show("لا يمكن حفظ البيانات \n الرجاء التاكد من كتابة البيانات بشكل صحيح ", "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
}
}
}
void updatequantitysp_id(long sp_old_id, long sp_new_id)
{
List <SH_QUANTITY_OF_RAW_MATERIAL> quantities = new List <SH_QUANTITY_OF_RAW_MATERIAL>();
try
{
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand("SELECT * FROM SH_QUANTITY_OF_RAW_MATERIAL WHERE SH_SPECIFICATION_OF_RAW_MATERIAL_ID = @SH_SPECIFICATION_OF_RAW_MATERIAL_ID", DatabaseConnection.mConnection);
cmd.Parameters.AddWithValue("@SH_SPECIFICATION_OF_RAW_MATERIAL_ID", sp_old_id);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
quantities.Add(new SH_QUANTITY_OF_RAW_MATERIAL {
SH_ID = long.Parse(reader["SH_ID"].ToString())
});
}
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE GETTING ALL QUANTITY IDs" + ex.ToString());
}
//updatingwithnew sp_new_id
for (int i = 0; i < quantities.Count; i++)
{
try
{
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand("UPDATE SH_QUANTITY_OF_RAW_MATERIAL SET SH_SPECIFICATION_OF_RAW_MATERIAL_ID = @SH_SPECIFICATION_OF_RAW_MATERIAL_ID WHERE SH_ID = @SH_ID ", DatabaseConnection.mConnection);
cmd.Parameters.AddWithValue("@SH_SPECIFICATION_OF_RAW_MATERIAL_ID", sp_new_id);
cmd.Parameters.AddWithValue("@SH_ID", quantities[i].SH_ID);
cmd.ExecuteNonQuery();
myconnection.closeConnection();
}
catch (Exception)
{
MessageBox.Show("ERROR WHILE UPDATING QUANTITIES SP_ID");
}
}
List <SH_RAW_MATERIAL_PARCEL> parcels = new List <SH_RAW_MATERIAL_PARCEL>();
//getting all old parcels that have the infection ;
try
{
DatabaseConnection MYCONNECTION = new DatabaseConnection();
MYCONNECTION.openConnection();
SqlCommand cmd = new SqlCommand("SELECT * FROM SH_RAW_MATERIAL_PARCEL WHERE SH_SPECIFICATION_OF_RAW_MATERIAL_ID = @SH_SPECIFICATION_OF_RAW_MATERIAL_ID", DatabaseConnection.mConnection);
cmd.Parameters.AddWithValue("@SH_SPECIFICATION_OF_RAW_MATERIAL_ID", sp_old_id);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
parcels.Add(new SH_RAW_MATERIAL_PARCEL {
SH_ID = long.Parse(reader["SH_ID"].ToString())
});
}
MYCONNECTION.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE GEETING INFECTED PARCELS WHITH old SP_OLD_ID" + ex.ToString());
}
//Correction of infected parcels
for (int i = 0; i < parcels.Count; i++)
{
try
{
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand("UPDATE SH_RAW_MATERIAL_PARCEL SET SH_SPECIFICATION_OF_RAW_MATERIAL_ID = @SH_SPECIFICATION_OF_RAW_MATERIAL_ID WHERE SH_ID = @SH_ID ", DatabaseConnection.mConnection);
cmd.Parameters.AddWithValue("@SH_SPECIFICATION_OF_RAW_MATERIAL_ID", sp_new_id);
cmd.Parameters.AddWithValue("@SH_ID", parcels[i].SH_ID);
cmd.ExecuteNonQuery();
myconnection.closeConnection();
}
catch (Exception)
{
MessageBox.Show("ERROR WHILE UPDATING QUANTITIES SP_ID");
}
}
}
long savetofirstduration_rawtin()
{
if (!((errorProvider1.GetError(item_length_text_box) == "") && (errorProvider1.GetError(item_width_text_box) == "") && (errorProvider1.GetError(item_thickness_text_box) == "") && (errorProvider1.GetError(item_coating_text_box) == "")))
{
MessageBox.Show("لا يمكن حفظ البيانات \n الرجاء التاكد من كتابة البيانات بشكل صحيح ", "خطأ", MessageBoxButtons.OK, MessageBoxIcon.Error, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
}
else
{
//MessageBox.Show("hello");
try
{
string query = "INSERT INTO SH_SPECIFICATION_OF_RAW_MATERIAL";
query += "(SH_ITEM_LENGTH, SH_ITEM_WIDTH, SH_ITEM_THICKNESS, SH_ITEM_TYPE, ";
query += "SH_ITEM_NAME, SH_ITEM_CODE, SH_ITEM_TEMPER, SH_ITEM_FINISH, SH_ITEM_COATING,";
query += "SH_ITEM_INTENSITY,SH_ITEM_TOTAL_NUMBER_OF_PACKAGES, SH_CREATION_DATE , ";
query += "SH_ITEM_TOTAL_NUMBER_OF_SHEETS , SH_TOTAL_NET_WEIGHT , SH_TOTAL_GROSS_WEIGHT ";
query += ", SH_DATA_ENTRY_USER_ID, SH_DATA_ENTRY_USER_NAME, SH_DATA_ENTRY_EMPLOYEE_ID, SH_DATA_ENTRY_EMPLOYEE_NAME)";
query += " VALUES(@SH_ITEM_LENGTH ,@SH_ITEM_WIDTH,";
query += "@SH_ITEM_THICKNESS, @SH_ITEM_TYPE, @SH_ITEM_NAME, @SH_ITEM_CODE, @SH_ITEM_TEMPER , ";
query += "@SH_ITEM_FINISH,@SH_ITEM_COATING,@SH_ITEM_INTENSITY,@SH_ITEM_TOTAL_NUMBER_OF_PACKAGES ";
query += ", @SH_CREATION_DATE";
query += ",@SH_ITEM_TOTAL_NUMBER_OF_SHEETS , @SH_TOTAL_NET_WEIGHT , @SH_TOTAL_GROSS_WEIGHT ";
query += ", @SH_DATA_ENTRY_USER_ID, @SH_DATA_ENTRY_USER_NAME, @SH_DATA_ENTRY_EMPLOYEE_ID, @SH_DATA_ENTRY_EMPLOYEE_NAME)";
query += "SELECT SCOPE_IDENTITY() AS myidentity";
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
cmd.Parameters.AddWithValue("@SH_ITEM_LENGTH", double.Parse(item_length_text_box.Text));
cmd.Parameters.AddWithValue("@SH_ITEM_WIDTH", double.Parse(item_width_text_box.Text));
cmd.Parameters.AddWithValue("@SH_ITEM_THICKNESS", double.Parse(item_thickness_text_box.Text));
cmd.Parameters.AddWithValue("@SH_ITEM_TYPE", item_type_combo_box.Text);
cmd.Parameters.AddWithValue("@SH_ITEM_NAME", "صفيح");
cmd.Parameters.AddWithValue("@SH_ITEM_CODE", item_code_text_box.Text);
cmd.Parameters.AddWithValue("@SH_ITEM_TEMPER", item_temper_combo_box.Text);
cmd.Parameters.AddWithValue("@SH_ITEM_FINISH", item_finish_combo_box.Text);
cmd.Parameters.AddWithValue("@SH_ITEM_COATING", item_coating_text_box.Text);
cmd.Parameters.AddWithValue("@SH_ITEM_INTENSITY", double.Parse(item_intensity_text_box.Text));
cmd.Parameters.AddWithValue("@SH_CREATION_DATE", DateTime.Parse(addition_date_text_box.Text));
cmd.Parameters.AddWithValue("@SH_ITEM_TOTAL_NUMBER_OF_PACKAGES", total_no_packges);
cmd.Parameters.AddWithValue("@SH_ITEM_TOTAL_NUMBER_OF_SHEETS", all_packages_no_sheets);
cmd.Parameters.AddWithValue("@SH_TOTAL_NET_WEIGHT", (((double.Parse(item_length_text_box.Text) * double.Parse(item_width_text_box.Text) * double.Parse(item_thickness_text_box.Text)) / 1000000) * double.Parse(item_intensity_text_box.Text)) * double.Parse(all_packages_no_sheets.ToString()));
cmd.Parameters.AddWithValue("@SH_TOTAL_GROSS_WEIGHT", all_packages_gross_weight);
cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_USER_ID", mAccount.SH_ID);
cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_USER_NAME ", mAccount.SH_EMP_USER_NAME);
cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_EMPLOYEE_ID", mAccount.SH_EMP_ID);
cmd.Parameters.AddWithValue("@SH_DATA_ENTRY_EMPLOYEE_NAME", mAccount.SH_EMP_NAME);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
// MessageBox.Show("GENERAL : "+ reader["myidentity"].ToString());
return(long.Parse(reader["myidentity"].ToString()));
}
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("failed to save to SH_SPECIFICATION_OF_RAW_MATERIAL " + ex.ToString());
}
return(0);
}
return(0);
}
