private void NewLogInsertToDatabase() { try { SqlConnection cn = ConnectToDatabase.NewConnectToDatabase(); SqlCommand cmd = ConnectToDatabase.NewSqlCommand(System.Data.CommandType.StoredProcedure, "Insert_Log_New", cn); cmd.Parameters.AddWithValue("dev_no", DeviceNumber); cmd.Parameters.AddWithValue("kind", Kind.ToString()); cmd.Parameters.AddWithValue("comment", classEnumLog.ShowError(Type)); cmd.Parameters.AddWithValue("level", Level.ToString()); cmd.Parameters.AddWithValue("intTime", (Convert.ToInt32(PublicMehotd.time_php()) + Sec)); cmd.Parameters.AddWithValue("datep", PublicMehotd.RetStringPersianCalender()); cmd.Parameters.AddWithValue("timep", PublicMehotd.RetStringLocalTime(Sec)); cmd.Parameters.AddWithValue("datetimep", PublicMehotd.retStringShowDatetime()); cmd.Parameters.AddWithValue("value", Val); cmd.Parameters.AddWithValue("yearp", PublicMehotd.retStringYearPersian()); cmd.Parameters.AddWithValue("monthp", PublicMehotd.retStringMonthPersian()); cmd.Parameters.AddWithValue("dayp", PublicMehotd.retStringDayPersian()); cn.Open(); object obj = cmd.ExecuteScalar(); cn.Close(); } catch (Exception ex) { //Enum.ClassEnumError.ShowErrorInMessageBox(EnumError.insertNewLogProbel); log_system.saveLogSystem(ex, "log_manager insert"); } }
public static bool InsertToDatabase(int devicenumber, Enum.EnumTypeData type, Enum.EnumKindDevice kind, double value) { try { Boolean check = true; if (check) { SqlConnection cn = ConnectToDatabase.NewConnectToDatabase(); SqlCommand cmd = ConnectToDatabase.NewSqlCommand(System.Data.CommandType.StoredProcedure, "Insert_Data_new", cn); cmd.Parameters.AddWithValue("dev_no", devicenumber); cmd.Parameters.AddWithValue("type", type.ToString()); cmd.Parameters.AddWithValue("kind", kind.ToString()); cmd.Parameters.AddWithValue("value", value); cmd.Parameters.AddWithValue("intTime", PublicMehotd.time_php()); cmd.Parameters.AddWithValue("datep", PublicMehotd.RetStringPersianCalender()); cmd.Parameters.AddWithValue("timep", PublicMehotd.RetStringLocalTime()); cmd.Parameters.AddWithValue("yearp", PublicMehotd.retStringYearPersian()); cmd.Parameters.AddWithValue("monthp", PublicMehotd.retStringMonthPersian()); cmd.Parameters.AddWithValue("dayp", PublicMehotd.retStringDayPersian()); cmd.Parameters.AddWithValue("datetimep", Convert.ToDouble(PublicMehotd.retStringShowDatetime())); cn.Open(); object obj = cmd.ExecuteScalar(); cn.Close(); if (Autoclav.sendServer_count == Varibale.save_count_autoclav_server) { Autoclav.sendServer_count = 0; } else { Autoclav.sendServer_count++; } return(true); } else { return(true); } } catch (Exception ex) { log_system.saveLogSystem(ex, "autoclav-insert database"); //Enum.ClassEnumError.ShowErrorInMessageBox(Enum.EnumError.insertnewDatalogforautoclav); return(false); } }