private void search_btn_Click(object sender, EventArgs e)
{
Cursor.Current = Cursors.WaitCursor;
parcels.Clear();
mtotal_number_of_parcels = 0;
mtotal_number_of_sheets = 0;
mtotoal_net_weight = 0;
total_number_of_sheets.Text = 0.ToString();
total_number_of_packages.Text = 0.ToString();
total_net_weight_text_box.Text = 0.ToString();
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;
bool stock = false;
string mlength = "";
string mwidth = "";
string mthickness = "";
string mtemper = "";
string mcaoting = "";
string mcode = "";
string mfinish = "";
string mtype = "";
string mStock = "";
if (string.IsNullOrEmpty(item_length_text_box.Text))
{
mlength = " ";
}
else if (double.TryParse(item_length_text_box.Text, out testnumber))
{
length = true;
mlength = " AND ( 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 ( 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 ( SH_ITEM_THICKNESS = @SH_ITEM_THICKNESS )";
}
else
{
mthickness = " ";
}
if (string.IsNullOrEmpty(stocks_combo_box.Text))
{
mStock = " ";
}
else
{
stock = true;
mStock = " AND ( SH_STOCK_NAME LIKE N'%" + stocks[stocks_combo_box.SelectedIndex].SH_STOCK_NAME + "%')";
}
if (string.IsNullOrEmpty(tempet_combo_box.Text))
{
mtemper = " ";
}
else
{
temper = true;
mtemper = " AND ( SH_ITEM_TEMPER LIKE N'%" + item_temper[tempet_combo_box.SelectedIndex] + "%')";
}
if (string.IsNullOrEmpty(item_code_text_box.Text))
{
mcode = " ";
}
else
{
code = true;
mcode = " AND ( SH_ITEM_CODE LIKE N'%" + item_code_text_box.Text + "%')";
}
if (string.IsNullOrEmpty(finish_combo_box.Text))
{
mfinish = " ";
}
else
{
finish = true;
mfinish = "AND ( SH_ITEM_FINISH LIKE N'%" + item_finish[finish_combo_box.SelectedIndex] + "%')";
}
if (string.IsNullOrEmpty(item_types_combo_box.Text))
{
mtype = " ";
type = false;
}
else
{
type = true;
//OR SH_ITEM_TYPE LIKE N'% @SH_ITEM_TYPE %' OR SH_ITEM_TYPE LIKE N' @SH_ITEM_TYPE %'
mtype = " AND ( SH_ITEM_TYPE LIKE N'%" + item_types[item_types_combo_box.SelectedIndex] + "%' )";
}
if (string.IsNullOrEmpty(coating_text_box.Text))
{
mcaoting = " ";
}
else
{
coating = true;
mcaoting = " AND ( SH_ITEM_COATING LIKE N'%" + item_coating[coating_text_box.SelectedIndex] + "%')";
}
//+mlength + mwidth + mthickness + mcode + mfinish + mtemper + mtype + mcaoting +
try
{
// string query = "SELECT * FROM SH_RAW_MATERIAL_PARCEL WHERE (SH_ID NOT IN (SELECT SH_RAW_MATERIAL_PARCEL_ID FROM SH_PACKAGES_DISBURSED_RAW_MATERIAL) )" + mlength + mwidth + mthickness + mcode + mfinish + mtemper + mtype + mcaoting ;
string query = "SELECT * FROM SH_RAW_MATERIAL_PARCEL WHERE SH_ID not in (SELECT SH_RAW_MATERIAL_PARCEL_ID FROM SH_PACKAGES_DISBURSED_RAW_MATERIAL )" + mlength + mwidth + mthickness + mcode + mfinish + mtemper + mtype + mcaoting + mStock;
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
if (length)
{
cmd.Parameters.AddWithValue("@SH_ITEM_LENGTH", double.Parse(item_length_text_box.Text));
}
if (width)
{
cmd.Parameters.AddWithValue("@SH_ITEM_WIDTH", double.Parse(item_width_text_box.Text));
}
if (thickness)
{
cmd.Parameters.AddWithValue("@SH_ITEM_THICKNESS", double.Parse(item_thickness_text_box.Text));
}
if (code)
{
// cmd.Parameters.AddWithValue("@SH_ITEM_CODE", item_code_text_box.Text);
}
if (temper)
{
// cmd.Parameters.AddWithValue("@SH_ITEM_TEMPER", item_temper[tempet_combo_box.SelectedIndex]);
}
if (coating)
{
// cmd.Parameters.AddWithValue("@SH_ITEM_COATING",item_coating[coating_text_box.SelectedIndex]);
}
if (finish)
{
// cmd.Parameters.AddWithValue("@SH_ITEM_FINISH", item_finish[finish_combo_box.SelectedIndex]);
}
if (type)
{
//MessageBox.Show(cmd.CommandText);
// cmd.Parameters.AddWithValue("@SH_ITEM_TYPE", item_types[item_types_combo_box.SelectedIndex]);
}
// MessageBox.Show(cmd.Parameters.ToString());
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
mtotal_number_of_parcels += 1;
mtotal_number_of_sheets += long.Parse(reader["SH_ITEM_NUMBER_OF_SHEETS"].ToString());
parcels.Add(new SH_RAW_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_GROSS_WEIGHT = Math.Round(double.Parse(reader["SH_ITEM_PARCEL_GROSS_WEIGHT"].ToString()), 1), SH_ITEM_LENGTH = Math.Round(double.Parse(reader["SH_ITEM_LENGTH"].ToString()), 1), SH_ITEM_NUMBER_OF_SHEETS = long.Parse(reader["SH_ITEM_NUMBER_OF_SHEETS"].ToString()), SH_ITEM_PARCEL_GROSS_WEIGHT = Math.Round(double.Parse(reader["SH_ITEM_PARCEL_GROSS_WEIGHT"].ToString()), 1), SH_ITEM_PARCEL_NET_WEIGHT = Math.Round(double.Parse(reader["SH_ITEM_PARCEL_NET_WEIGHT"].ToString()), 1), SH_ITEM_SHEET_WEIGHT = Math.Round(double.Parse(reader["SH_ITEM_SHEET_WEIGHT"].ToString()), 1), SH_ITEM_TEMPER = reader["SH_ITEM_TEMPER"].ToString(), SH_ITEM_TYPE = reader["SH_ITEM_TYPE"].ToString(), SH_ITEM_THICKNESS = double.Parse(reader["SH_ITEM_THICKNESS"].ToString()), SH_ITEM_WIDTH = Math.Round(double.Parse(reader["SH_ITEM_WIDTH"].ToString()), 1), SH_STOCK_NAME = reader["SH_STOCK_NAME"].ToString(), SH_SUPPLIER_NAME = reader["SH_SUPPLIER_NAME"].ToString()
});
mtotoal_net_weight += double.Parse(reader["SH_ITEM_PARCEL_NET_WEIGHT"].ToString());
}
total_number_of_sheets.Text = mtotal_number_of_sheets.ToString();
total_number_of_packages.Text = mtotal_number_of_parcels.ToString();
total_net_weight_text_box.Text = String.Format("{0:0,0.0}", mtotoal_net_weight);
myconnection.closeConnection();
fillparcelsgridview();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE GETTING SEARCH RESULT FORM " + ex.ToString());
}
finally
{
Cursor.Current = Cursors.WaitCursor;
}
}
void savenewquantityofmurantin(long muran_sp_id)
{
if (quantities.Count > 0)
{
for (int i = 0; i < quantities.Count; i++)
{
try
{
string query = "INSERT INTO SH_QUANTITY_OF_MURAN_MATERIAL ";
query += "(SH_SPECIFICATION_OF_MURAN_MATERIAL_ID, SH_ITEM_LENGTH, SH_ITEM_WIDTH, SH_ITEM_THICKNESS, SH_ITEM_TYPE, SH_ITEM_NAME, SH_ITEM_CODE, SH_ITEM_INTENSITY,";
query += "SH_ITEM_SHEET_WEIGHT, SH_ITEM_PACKAGE_NET_WEIGHT, SH_ITEM_NUMBER_OF_PACKAGES, SH_ITEM_TOTAL_NUMBER_OF_SHEETS, SH_QUANTITY_NET_WEIGHT, SH_QUANTITY_GROSS_WEIGHT,";
query += "SH_PACKAGE_GROSS_WEIGHT, SH_CLIENT_NAME, SH_STOCK_NAME, SH_ITEM_FIRST_FACE, SH_ITEM_SECOND_FACE, SH_MURAN_TYPE,";
query += " SH_BOTTLE_CAPACITY";
query += ", SH_BOTTLE_HEIGHT , SH_SIZE_ID , SH_SIZE_NAME ) VALUES( @SH_SPECIFICATION_OF_MURAN_MATERIAL_ID , @SH_ITEM_LENGTH , @SH_ITEM_WIDTH,@SH_ITEM_THICKNESS,@SH_ITEM_TYPE,@SH_ITEM_NAME,@SH_ITEM_CODE,@SH_ITEM_INTENSITY";
query += ",@SH_ITEM_SHEET_WEIGHT,@SH_ITEM_PACKAGE_NET_WEIGHT,@SH_ITEM_NUMBER_OF_PACKAGES,@SH_ITEM_TOTAL_NUMBER_OF_SHEETS,@SH_QUANTITY_NET_WEIGHT,@SH_QUANTITY_GROSS_WEIGHT";
query += ",@SH_PACKAGE_GROSS_WEIGHT,@SH_CLIENT_NAME,@SH_STOCK_NAME,@SH_ITEM_FIRST_FACE,@SH_ITEM_SECOND_FACE,@SH_MURAN_TYPE";
query += ",@SH_BOTTLE_CAPACITY, @SH_BOTTLE_HEIGHT , @SH_SIZE_ID , @SH_SIZE_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_MURAN_MATERIAL_ID", muran_sp_id);
cmd.Parameters.AddWithValue("@SH_ITEM_LENGTH", quantities[i].SH_ITEM_LENGTH);
cmd.Parameters.AddWithValue("@SH_ITEM_WIDTH", quantities[i].SH_ITEM_WIDTH);
cmd.Parameters.AddWithValue("@SH_ITEM_THICKNESS", quantities[i].SH_ITEM_THICKNESS);
cmd.Parameters.AddWithValue("@SH_ITEM_TYPE", quantities[i].SH_ITEM_TYPE);
cmd.Parameters.AddWithValue("@SH_ITEM_NAME", "صفيح");
cmd.Parameters.AddWithValue("@SH_ITEM_CODE", quantities[i].SH_ITEM_CODE);
cmd.Parameters.AddWithValue("@SH_ITEM_INTENSITY", quantities[i].SH_ITEM_INTENSITY);
cmd.Parameters.AddWithValue("@SH_ITEM_SHEET_WEIGHT", quantities[i].SH_ITEM_SHEET_WEIGHT);
cmd.Parameters.AddWithValue("@SH_ITEM_PACKAGE_NET_WEIGHT", quantities[i].SH_ITEM_PARCEL_NET_WEIGHT);
cmd.Parameters.AddWithValue("@SH_ITEM_NUMBER_OF_PACKAGES", quantities[i].SH_ITEM_NUMBER_OF_PACKAGES);
cmd.Parameters.AddWithValue("@SH_ITEM_TOTAL_NUMBER_OF_SHEETS", quantities[i].SH_ITEM_TOTAL_NUMBER_OF_SHEETS);
cmd.Parameters.AddWithValue("@SH_QUANTITY_NET_WEIGHT", quantities[i].SH_QUANTITY_NET_WEIGHT);
cmd.Parameters.AddWithValue("@SH_QUANTITY_GROSS_WEIGHT", 0);
cmd.Parameters.AddWithValue("@SH_PACKAGE_GROSS_WEIGHT", 0);
cmd.Parameters.AddWithValue("@SH_CLIENT_NAME", quantities[i].SH_CLIENT_NAME);
cmd.Parameters.AddWithValue("@SH_STOCK_NAME", quantities[i].SH_STOCK_NAME);
cmd.Parameters.AddWithValue("@SH_ITEM_FIRST_FACE", quantities[i].SH_ITEM_FIRST_FACE);
cmd.Parameters.AddWithValue("@SH_ITEM_SECOND_FACE", quantities[i].SH_ITEM_SECOND_FACE);
cmd.Parameters.AddWithValue("@SH_MURAN_TYPE", quantities[i].SH_MURAN_TYPE);
cmd.Parameters.AddWithValue("@SH_BOTTLE_HEIGHT", quantities[i].SH_BOTTLE_HEIGHT);
cmd.Parameters.AddWithValue("@SH_BOTTLE_CAPACITY", quantities[i].SH_BOTTLE_CAPACITY);
cmd.Parameters.AddWithValue("@SH_SIZE_ID", quantities[i].SH_SIZE_ID);
cmd.Parameters.AddWithValue("@SH_SIZE_NAME", quantities[i].SH_SIZE_NAME);
SqlDataReader reader = cmd.ExecuteReader();
if (reader.Read())
{
long q_id = long.Parse(reader["myidentity"].ToString());
savemurantinparcel(muran_sp_id, q_id, quantities[i].SH_ITEM_NUMBER_OF_PACKAGES, quantities[i]);
}
myconnection.closeConnection();
}
catch (Exception ex)
{
MessageBox.Show("ERROR WHILE SAVING QUANTITIES" + ex.ToString());
}
}
MessageBox.Show("تم الحفظ ", "معلومات", MessageBoxButtons.OK, MessageBoxIcon.Information, MessageBoxDefaultButton.Button1, MessageBoxOptions.RtlReading);
}
}
void saveUserPermisions()
{
try
{
string query = " INSERT INTO SH_USER_PERMISIONS ";
query += "(SH_ACCOUNT_ID, SH_ACCOUNT_NAME, SH_OPEN_CHANGE_PASSWORD, SH_OPEN_DASH_BOARD, SH_OPEN_GETALL_EMP, SH_OPEN_DISPLAY_ALLUSERS, SH_OPEN_MAKE_NEW_USER, SH_OPEN_REGIST_EMP,";
query += " SH_OPEN_SELECT_USER_PERMISION, SH_ADD_NEW_CLIENT_COMPANY, SH_ADD_NEW_CLIENT_BRANCH, SH_SHOW_ALL_CLIENTS, SH_ADD_NEW_SUPPLIER, SH_ADD_NEW_SUPPLIER_BRANCH,";
query += " SH_SHOW_ALL_SUPPLIERS, SH_MAIN_TIN_STOCK, SH_RAW_TIN_MATERIAL, SH_ADD_NEW_RAW_TIN_FIRST_DURATION, SH_ADD_NEW_RAW_TIN, SH_EXCHANGE_RAW_TIN_PARCEL_NO,";
query += " SH_EXCHANGE_RAW_TIN_PROPERTIES, SH_ADD_NEW_MURAN_TIN, SH_EXCHANGE_MURAN_TIN, SH_ADD_NEW_PRINTED_TIN, SH_EXCHANGE_PRINTED_TIN, SH_ADD_NEW_SIZE, SH_ADD_NEW_CUT_RAW_TIN,";
query += " SH_EXCHANGE_CUT_RAW_TIN, SH_ADD_NEW_CUT_PRINTED_TIN, SH_EXCHANGE_CUT_PRINTED_TIN, SH_ADD_NEW_CUT_MURAN_TIN, SH_EXCHANGE_CUT_MURAN_TIN, SH_SHOW_ALL_CUTTERS,";
query += " SH_ADD_NEW_CUTTERS, SH_ADD_NEW_STOCK_PLACE, SH_SHOW_ALL_STOCKS, SH_DEPARTMENT_STOCKS, SH_DEPARTMENT_SALES, SH_DEPARTMENT_HR, SH_DEPARTMENT_PURCHASING,";
query += " SH_DEPARTMENT_SECRETARY, SH_DEPARTMENT_ACCOUNTING, SH_DEPARTMENT_IT, SH_DEPARTMENT_PRODUCTION, SH_IT_SERVER_SETTINGS, SH_ADD_NEW_DEPARTMENT, SH_ADD_NEW_JOB,";
query += " SH_ADD_NEW_PRODUCT_CLIENT, SH_ADD_NEW_COLOR, SH_ADD_PRODUCTION_REQUIRMENT, SH_EXCHANGE_PRODUCTION_REQUIRMENT, SH_ADD_CHANGE_BITS, SH_EXCHANGE_CHANGE_BITS,";
query += " SH_ADD_EASY_OPEN, SH_EXCHANGE_EASY_OPEN, SH_ADD_TIN_CANS, SH_EXCHANGE_TIN_CANS, SH_ADD_NEW_RLT, SH_EXCHANGE_RLT, SH_ADD_NEW_BOTTOM, SH_EXCHANGE_BOTTOM)";
query += " VALUES(@SH_ACCOUNT_ID, @SH_ACCOUNT_NAME, @SH_OPEN_CHANGE_PASSWORD, @SH_OPEN_DASH_BOARD, @SH_OPEN_GETALL_EMP, @SH_OPEN_DISPLAY_ALLUSERS, @SH_OPEN_MAKE_NEW_USER, @SH_OPEN_REGIST_EMP, ";
query += " @SH_OPEN_SELECT_USER_PERMISION, @SH_ADD_NEW_CLIENT_COMPANY, @SH_ADD_NEW_CLIENT_BRANCH, @SH_SHOW_ALL_CLIENTS, @SH_ADD_NEW_SUPPLIER, @SH_ADD_NEW_SUPPLIER_BRANCH, ";
query += " @SH_SHOW_ALL_SUPPLIERS, @SH_MAIN_TIN_STOCK, @SH_RAW_TIN_MATERIAL, @SH_ADD_NEW_RAW_TIN_FIRST_DURATION, @SH_ADD_NEW_RAW_TIN, @SH_EXCHANGE_RAW_TIN_PARCEL_NO, ";
query += " @SH_EXCHANGE_RAW_TIN_PROPERTIES, @SH_ADD_NEW_MURAN_TIN, @SH_EXCHANGE_MURAN_TIN, @SH_ADD_NEW_PRINTED_TIN, @SH_EXCHANGE_PRINTED_TIN, @SH_ADD_NEW_SIZE, @SH_ADD_NEW_CUT_RAW_TIN, ";
query += " @SH_EXCHANGE_CUT_RAW_TIN, @SH_ADD_NEW_CUT_PRINTED_TIN, @SH_EXCHANGE_CUT_PRINTED_TIN, @SH_ADD_NEW_CUT_MURAN_TIN, @SH_EXCHANGE_CUT_MURAN_TIN, @SH_SHOW_ALL_CUTTERS, ";
query += " @SH_ADD_NEW_CUTTERS, @SH_ADD_NEW_STOCK_PLACE, @SH_SHOW_ALL_STOCKS, @SH_DEPARTMENT_STOCKS, @SH_DEPARTMENT_SALES, @SH_DEPARTMENT_HR, @SH_DEPARTMENT_PURCHASING, ";
query += " @SH_DEPARTMENT_SECRETARY, @SH_DEPARTMENT_ACCOUNTING, @SH_DEPARTMENT_IT, @SH_DEPARTMENT_PRODUCTION, @SH_IT_SERVER_SETTINGS, @SH_ADD_NEW_DEPARTMENT, @SH_ADD_NEW_JOB, ";
query += " @SH_ADD_NEW_PRODUCT_CLIENT, @SH_ADD_NEW_COLOR, @SH_ADD_PRODUCTION_REQUIRMENT, @SH_EXCHANGE_PRODUCTION_REQUIRMENT, @SH_ADD_CHANGE_BITS, @SH_EXCHANGE_CHANGE_BITS, ";
query += " @SH_ADD_EASY_OPEN, @SH_EXCHANGE_EASY_OPEN, @SH_ADD_TIN_CANS, @SH_EXCHANGE_TIN_CANS, @SH_ADD_NEW_RLT, @SH_EXCHANGE_RLT, @SH_ADD_NEW_BOTTOM, @SH_EXCHANGE_BOTTOM) ";
DatabaseConnection myconnection = new DatabaseConnection();
myconnection.openConnection();
SqlCommand cmd = new SqlCommand(query, DatabaseConnection.mConnection);
cmd.Parameters.AddWithValue("@SH_ACCOUNT_ID", acc.SH_ID);
cmd.Parameters.AddWithValue("@SH_ACCOUNT_NAME", acc.SH_EMP_USER_NAME);
cmd.Parameters.AddWithValue("@SH_OPEN_CHANGE_PASSWORD", userPerm.SH_OPEN_CHANGE_PASSWORD);
cmd.Parameters.AddWithValue("@SH_OPEN_DASH_BOARD", userPerm.SH_OPEN_DASH_BOARD);
cmd.Parameters.AddWithValue("@SH_OPEN_GETALL_EMP", userPerm.SH_OPEN_GETALL_EMP);
cmd.Parameters.AddWithValue("@SH_OPEN_DISPLAY_ALLUSERS", userPerm.SH_OPEN_DISPLAY_ALLUSERS);
cmd.Parameters.AddWithValue("@SH_OPEN_MAKE_NEW_USER", userPerm.SH_OPEN_MAKE_NEW_USER);
cmd.Parameters.AddWithValue("@SH_OPEN_REGIST_EMP", userPerm.SH_OPEN_REGIST_EMP);
cmd.Parameters.AddWithValue("@SH_OPEN_SELECT_USER_PERMISION", userPerm.SH_OPEN_SELECT_USER_PERMISION);
cmd.Parameters.AddWithValue("@SH_ADD_NEW_CLIENT_COMPANY", userPerm.SH_ADD_NEW_CLIENT_COMPANY);
cmd.Parameters.AddWithValue("@SH_ADD_NEW_CLIENT_BRANCH", userPerm.SH_ADD_NEW_CLIENT_BRANCH);
cmd.Parameters.AddWithValue("@SH_SHOW_ALL_CLIENTS", userPerm.SH_SHOW_ALL_CLIENTS);
cmd.Parameters.AddWithValue("@SH_ADD_NEW_SUPPLIER", userPerm.SH_ADD_NEW_SUPPLIER);
cmd.Parameters.AddWithValue("@SH_ADD_NEW_SUPPLIER_BRANCH", userPerm.SH_ADD_NEW_SUPPLIER_BRANCH);
cmd.Parameters.AddWithValue("@SH_SHOW_ALL_SUPPLIERS", userPerm.SH_SHOW_ALL_SUPPLIERS);
cmd.Parameters.AddWithValue("@SH_MAIN_TIN_STOCK", userPerm.SH_MAIN_TIN_STOCK);
cmd.Parameters.AddWithValue("@SH_RAW_TIN_MATERIAL", userPerm.SH_RAW_TIN_MATERIAL);
cmd.Parameters.AddWithValue("@SH_ADD_NEW_RAW_TIN_FIRST_DURATION", userPerm.SH_ADD_NEW_RAW_TIN_FIRST_DURATION);
cmd.Parameters.AddWithValue("@SH_ADD_NEW_RAW_TIN", userPerm.SH_ADD_NEW_RAW_TIN);
cmd.Parameters.AddWithValue("@SH_EXCHANGE_RAW_TIN_PARCEL_NO", userPerm.SH_EXCHANGE_RAW_TIN_PARCEL_NO);
cmd.Parameters.AddWithValue("@SH_EXCHANGE_RAW_TIN_PROPERTIES", userPerm.SH_EXCHANGE_RAW_TIN_PROPERTIES);
cmd.Parameters.AddWithValue("@SH_ADD_NEW_MURAN_TIN", userPerm.SH_ADD_NEW_MURAN_TIN);
cmd.Parameters.AddWithValue("@SH_EXCHANGE_MURAN_TIN", userPerm.SH_EXCHANGE_MURAN_TIN);
cmd.Parameters.AddWithValue("@SH_ADD_NEW_PRINTED_TIN", userPerm.SH_ADD_NEW_PRINTED_TIN);
cmd.Parameters.AddWithValue("@SH_EXCHANGE_PRINTED_TIN", userPerm.SH_EXCHANGE_PRINTED_TIN);
cmd.Parameters.AddWithValue("@SH_ADD_NEW_SIZE", userPerm.SH_ADD_NEW_SIZE);
cmd.Parameters.AddWithValue("@SH_ADD_NEW_CUT_RAW_TIN", userPerm.SH_ADD_NEW_CUT_RAW_TIN);
cmd.Parameters.AddWithValue("@SH_EXCHANGE_CUT_RAW_TIN", userPerm.SH_EXCHANGE_CUT_RAW_TIN);
cmd.Parameters.AddWithValue("@SH_ADD_NEW_CUT_PRINTED_TIN", userPerm.SH_ADD_NEW_CUT_PRINTED_TIN);
cmd.Parameters.AddWithValue("@SH_EXCHANGE_CUT_PRINTED_TIN", userPerm.SH_EXCHANGE_CUT_PRINTED_TIN);
cmd.Parameters.AddWithValue("@SH_ADD_NEW_CUT_MURAN_TIN", userPerm.SH_ADD_NEW_CUT_MURAN_TIN);
cmd.Parameters.AddWithValue("@SH_EXCHANGE_CUT_MURAN_TIN", userPerm.SH_EXCHANGE_CUT_MURAN_TIN);
cmd.Parameters.AddWithValue("@SH_SHOW_ALL_CUTTERS", userPerm.SH_SHOW_ALL_CUTTERS);
cmd.Parameters.AddWithValue("@SH_ADD_NEW_CUTTERS", userPerm.SH_ADD_NEW_CUTTERS);
cmd.Parameters.AddWithValue("@SH_ADD_NEW_STOCK_PLACE", userPerm.SH_ADD_NEW_STOCK_PLACE);
cmd.Parameters.AddWithValue("@SH_SHOW_ALL_STOCKS", userPerm.SH_SHOW_ALL_STOCKS);
cmd.Parameters.AddWithValue("@SH_DEPARTMENT_STOCKS", userPerm.SH_DEPARTMENT_STOCKS);
cmd.Parameters.AddWithValue("@SH_DEPARTMENT_SALES", userPerm.SH_DEPARTMENT_SALES);
cmd.Parameters.AddWithValue("@SH_DEPARTMENT_HR", userPerm.SH_DEPARTMENT_HR);
cmd.Parameters.AddWithValue("@SH_DEPARTMENT_PURCHASING", userPerm.SH_DEPARTMENT_PURCHASING);
cmd.Parameters.AddWithValue("@SH_DEPARTMENT_SECRETARY", userPerm.SH_DEPARTMENT_SECRETARY);
cmd.Parameters.AddWithValue("@SH_DEPARTMENT_ACCOUNTING", userPerm.SH_DEPARTMENT_ACCOUNTING);
cmd.Parameters.AddWithValue("@SH_DEPARTMENT_IT", userPerm.SH_DEPARTMENT_IT);
cmd.Parameters.AddWithValue("@SH_DEPARTMENT_PRODUCTION", userPerm.SH_DEPARTMENT_PRODUCTION);
cmd.Parameters.AddWithValue("@SH_IT_SERVER_SETTINGS", userPerm.SH_IT_SERVER_SETTINGS);
cmd.Parameters.AddWithValue("@SH_ADD_NEW_DEPARTMENT", userPerm.SH_ADD_NEW_DEPARTMENT);
cmd.Parameters.AddWithValue("@SH_ADD_NEW_JOB", userPerm.SH_ADD_NEW_JOB);
cmd.Parameters.AddWithValue("@SH_ADD_NEW_PRODUCT_CLIENT", userPerm.SH_ADD_NEW_PRODUCT_CLIENT);
cmd.Parameters.AddWithValue("@SH_ADD_NEW_COLOR", userPerm.SH_ADD_NEW_COLOR);
cmd.Parameters.AddWithValue("@SH_ADD_PRODUCTION_REQUIRMENT", userPerm.SH_ADD_PRODUCTION_REQUIRMENT);
cmd.Parameters.AddWithValue("@SH_EXCHANGE_PRODUCTION_REQUIRMENT", userPerm.SH_EXCHANGE_PRODUCTION_REQUIRMENT);
cmd.Parameters.AddWithValue("@SH_ADD_CHANGE_BITS", userPerm.SH_ADD_CHANGE_BITS);
cmd.Parameters.AddWithValue("@SH_EXCHANGE_CHANGE_BITS", userPerm.SH_EXCHANGE_CHANGE_BITS);
cmd.Parameters.AddWithValue("@SH_ADD_EASY_OPEN", userPerm.SH_ADD_EASY_OPEN);
cmd.Parameters.AddWithValue("@SH_EXCHANGE_EASY_OPEN", userPerm.SH_EXCHANGE_EASY_OPEN);
cmd.Parameters.AddWithValue("@SH_ADD_TIN_CANS", userPerm.SH_ADD_TIN_CANS);
cmd.Parameters.AddWithValue("@SH_EXCHANGE_TIN_CANS", userPerm.SH_EXCHANGE_EASY_OPEN);
cmd.Parameters.AddWithValue("@SH_ADD_NEW_RLT", userPerm.SH_ADD_NEW_RLT);
cmd.Parameters.AddWithValue("@SH_EXCHANGE_RLT", userPerm.SH_EXCHANGE_RLT);
cmd.Parameters.AddWithValue("@SH_ADD_NEW_BOTTOM", userPerm.SH_ADD_NEW_BOTTOM);
cmd.Parameters.AddWithValue("@SH_EXCHANGE_BOTTOM", userPerm.SH_EXCHANGE_BOTTOM);
cmd.Parameters.AddWithValue("@SH_DEPARTMENT_MAINTENANCE", userPerm.SH_DEPARTMENT_MAINTENANCE);
cmd.ExecuteNonQuery();
MessageBox.Show("تم التسجيل بجاح");
}
catch (Exception ex)
{
MessageBox.Show("Error in" + ex.Message);
}
}