public void edit(int ID, float CF1, float CF2, float CF3, float CF4, float CF5, float CF6, float CF7, float CF8, float CF9) { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "USE [rbi]" + " " + "UPDATE [dbo].[RW_CF_MASTER]" + "SET [ID] = '" + ID + "'" + ",[CF1] = '" + CF1 + "'" + ",[CF2] = '" + CF2 + "'" + ",[CF3] = '" + CF3 + "'" + ",[CF4] = '" + CF4 + "'" + ",[CF5] = '" + CF5 + "'" + ",[CF6] = '" + CF6 + "'" + ",[CF7] = '" + CF7 + "'" + ",[CF8] = '" + CF8 + "'" + ",[CF9] = '" + CF9 + "'" + " WHERE [ID] = '" + ID + "'" + " "; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; cmd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.ToString(), "EDIT FAIL!"); } finally { conn.Close(); conn.Dispose(); } }
public List <int[]> getCheckAddExcel_ID(int comID, int eqID) { List <int[]> temp = new List <int[]>(); int[] data = new int[2]; SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "SELECT AddByExcel,ID FROM rbi.dbo.RW_ASSESSMENT WHERE EquipmentID = '" + eqID + "' AND ComponentID='" + comID + "'"; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader.HasRows) { data[0] = Convert.ToInt32(reader.GetBoolean(0)); data[1] = reader.GetInt32(1); temp.Add(data); } } } } catch (Exception e) { MessageBox.Show(e.ToString(), "GET DATA FAIL!"); } finally { conn.Close(); conn.Dispose(); } return(temp); }
public List <int> getIDbyCoverageID(int CoverageID) { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); List <int> list = new List <int>(); int ID = 0; String sql = "Use [rbi]" + "SELECT [ID]" + "From [dbo].[INSPECTION_COVERAGE_DETAIL] where CoverageID = '" + CoverageID + "'"; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader.HasRows) { ID = (int)reader.GetInt64(0); } list.Add(ID); } } } catch (Exception e) { MessageBox.Show(e.ToString(), "GET DATA FAIL!"); } finally { conn.Close(); conn.Dispose(); } return(list); }
public bool CheckExistID(int ID) { Boolean IsExist = false; SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "SELECT Hydraulic_Water FROM rbi.dbo.RW_CA_TANK WHERE ID = '" + ID + "'"; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader.IsDBNull(0)) { IsExist = false; } else { IsExist = true; } } } } catch (Exception e) { MessageBox.Show(e.ToString(), "GET DATA FAIL!"); } finally { conn.Close(); conn.Dispose(); } return(IsExist); }
public void Edit(int ID, float FLUID_HEIGHT, float SHELL_COURSE_HEIGHT, float TANK_DIAMETTER, int Prevention_Barrier, String Environ_Sensitivity, float P_lvdike, float P_onsite, float P_offsite, String Soil_Type, String TANK_FLUID, String API_FLUID, float SW, float ProductionCost) { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "USE [rbi] " + "UPDATE [dbo].[RW_INPUT_CA_TANK] " + " SET [FLUID_HEIGHT] = '" + FLUID_HEIGHT + "' " + ",[SHELL_COURSE_HEIGHT] = '" + SHELL_COURSE_HEIGHT + "' " + ",[TANK_DIAMETTER] = '" + TANK_DIAMETTER + "' " + ",[Prevention_Barrier] = '" + Prevention_Barrier + "' " + ",[Environ_Sensitivity] = '" + Environ_Sensitivity + "' " + ",[P_lvdike] = '" + P_lvdike + "' " + ",[P_onsite] = '" + P_onsite + "' " + ",[P_offsite] = '" + P_offsite + "' " + ",[Soil_Type] = '" + Soil_Type + "' " + ",[TANK_FLUID] = '" + TANK_FLUID + "' " + ",[API_FLUID] = '" + API_FLUID + "' " + ",[SW] = '" + SW + "' " + ",[ProductionCost] = '" + ProductionCost + "' " + " WHERE [ID] = '" + ID + "'"; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; cmd.ExecuteNonQuery(); } catch { MessageBox.Show("EDIT FAIL!", "ERROR!"); } finally { conn.Close(); conn.Dispose(); } }
public Boolean checkExistAssessment(int ID) { Boolean IsExist = false; SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "select AssessmentDate from rbi.dbo.RW_ASSESSMENT where ID = '" + ID + "'"; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader.IsDBNull(0)) { IsExist = false; } else { IsExist = true; } } } } catch (Exception e) { MessageBox.Show(e.ToString(), "GET DATA FAIL!"); } finally { conn.Close(); conn.Dispose(); } return(IsExist); }
public void edit(int ID, double FCoFValue, String FCoFCategory, int AIL, double envcost, double equipcost, double prodcost, double popdens, double injcost, double FCoFMatrixValue) { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "USE [rbi]" + " " + "UPDATE [dbo].[RW_FULL_FCOF]" + "SET [ID] = '" + ID + "'" + ",[FCoFValue] = '" + FCoFValue + "'" + ",[FCoFCategory] = '" + FCoFCategory + "'" + ",[AIL] = '" + AIL + "'" + ",[envcost] = '" + envcost + "'" + ",[equipcost] = '" + equipcost + "'" + ",[prodcost] = '" + prodcost + "'" + ",[popdens] = '" + popdens + "'" + ",[injcost] = '" + injcost + "'" + ",[FCoFMatrixValue] = '" + FCoFMatrixValue + "'" + " WHERE [ID] = '" + ID + "'" + " "; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; cmd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.ToString(), "EDIT FAIL!"); } finally { conn.Close(); conn.Dispose(); } }
public void add(int DMItemID, String DMDescription, int DMSeq, int DMCategoryID, String DMCode, int HasDF, String FailureMode) { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "USE [rbi] " + " INSERT INTO[dbo].[DM_ITEMS]" + "([DMItemID]" + ",[DMDescription]" + ",[DMSeq]" + ",[DMCategoryID]" + ",[DMCode]" + ",[HasDF]" + ",[FailureMode])" + "VALUES" + "('" + DMItemID + "'" + ",'" + DMDescription + "'" + ",'" + DMSeq + "'" + ",'" + DMCategoryID + "'" + ",'" + DMCode + "'" + ",'" + HasDF + "'" + ",'" + FailureMode + "')"; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; cmd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.ToString(), "ADD FAIL!"); } finally { conn.Close(); } }
public void add(String UserID, String Category, String Permission, int Allowed, String Type, int Active) { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "USE [rbi]" + "INSERT INTO [dbo].[USER_PERMISSONS]" + "([UserID]" + ",[Category]" + ",[Permission]" + ",Allowed]" + ",[Type]" + ",[Active])" + " VALUES" + "( '" + UserID + "'" + ", '" + Category + "'" + ", '" + Permission + "'" + ", '" + Allowed + "'" + ", '" + Type + "'" + ", '" + Active + "')"; try { SqlCommand cmd = new SqlCommand(); cmd.CommandText = sql; cmd.Connection = conn; cmd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.ToString(), "ADD FAIL!"); } finally { conn.Close(); conn.Dispose(); } }
// dung file get data // dung file get list( data source) public List <SITES> getDataSource() { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); List <SITES> list = new List <SITES>(); SITES obj = null; String sql = "SELECT [SiteID],[SiteName] FROM [rbi].[dbo].[SITES]"; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader.HasRows) { obj = new SITES(); obj.SiteID = reader.GetInt32(0); obj.SiteName = reader.GetString(1); list.Add(obj); } } } } catch (Exception e) { MessageBox.Show(e.ToString(), "GET DATA FAIL!"); } finally { conn.Close(); conn.Dispose(); } return(list); }
public String getAPIComponentTypeName(int APIID) { String APIName = ""; SqlConnection con = MSSQLDBUtils.GetDBConnection(); con.Open(); String sql = "SELECT APIComponentTypeName FROM [rbi].[dbo].[API_COMPONENT_TYPE] WHERE APIComponentTypeID = '" + APIID + "'"; try { SqlCommand cmd = new SqlCommand(); cmd.CommandText = sql; cmd.Connection = con; using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader.HasRows) { if (!reader.IsDBNull(0)) { APIName = reader.GetString(0); } } } } } catch (Exception ex) { MessageBox.Show("Get FMS Fail------->" + ex.ToString(), "Get Data Fail"); } finally { con.Close(); con.Dispose(); } return(APIName); }
public void edit(int PointID, String PointName, int ComponentID, float CorrosionRate, float NominalThickness, float MinReqThickness, float ThicknessCurrent, float ThicknessPrevious, DateTime DateCurrent, DateTime DatePrevious) { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "USE [rbi]" + " " + "UPDATE [dbo].[POINTS]" + "SET [PointName] = '" + PointName + "'" + ",[ComponentID] = '" + ComponentID + "'" + ",[CorrosionRate] = '" + CorrosionRate + "'" + ",[NominalThickness] = '" + NominalThickness + "'" + ",[MinReqThickness] = '" + MinReqThickness + "'" + ",[ThicknessCurrent] = '" + ThicknessCurrent + "'" + ",[ThicknessPrevious] = '" + ThicknessPrevious + "'" + ",[DateCurrent] = '" + DateCurrent + "'" + ",[DatePrevious] = '" + DatePrevious + "'" + "WHERE [PointID] ='" + PointID + "'" + " "; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; cmd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.ToString(), "EDIT FAIL!"); } finally { conn.Close(); conn.Dispose(); } }
public void add(int ID, double CoFValue, String CoFCategory, double ProdCost, double CoFMatrixValue) { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "USE [rbi]" + " " + "INSERT INTO [dbo].[RW_FULL_COF_TANK]" + "([ID]" + ",[CoFValue]" + ",[CoFCategory]" + ",[ProdCost]" + ",[CoFMatrixValue])" + "VALUES" + "('" + ID + "'" + ",'" + CoFValue + "'" + ",'" + CoFCategory + "'" + ",'" + ProdCost + "'" + ",'" + CoFMatrixValue + "')" + " "; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; cmd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.ToString(), "ADD FAIL!"); } finally { conn.Close(); conn.Dispose(); } }
public int getIDbyName(String name) { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); int ID = 0; String sql = "Use [rbi]" + "SELECT [SiteID]" + ",[SiteName]" + " FROM [rbi].[dbo].[SITES] WHERE [SiteName] = '" + name + "'"; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader.HasRows) { ID = reader.GetInt32(0); } } } } catch { ID = 0; } finally { conn.Close(); conn.Dispose(); } return(ID); }
public void edit(int ID, double Minus12ToMinus8, double Minus8ToPlus6, double Plus6ToPlus32, double Plus32ToPlus71, double Plus71ToPlus107, double Plus107ToPlus121, double Plus121ToPlus135, double Plus135ToPlus162, double Plus162ToPlus176, double MoreThanPlus176) { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "USE [rbi]" + " " + "UPDATE [dbo].[RW_EXTCOR_TEMPERATURE]" + "SET [ID] = '" + ID + "'" + ",[Minus12ToMinus8] = '" + Minus12ToMinus8 + "'" + ",[Minus8ToPlus6] = '" + Minus8ToPlus6 + "'" + ",[Plus6ToPlus32] = '" + Plus6ToPlus32 + "'" + ",[Plus32ToPlus71] = '" + Plus32ToPlus71 + "'" + ",[Plus71ToPlus107] = '" + Plus71ToPlus107 + "'" + ",[Plus107ToPlus121] = '" + Plus107ToPlus121 + "'" + ",[Plus121ToPlus135] = '" + Plus121ToPlus135 + "'" + ",[Plus135ToPlus162] = '" + Plus135ToPlus162 + "'" + ",[Plus162ToPlus176] = '" + Plus162ToPlus176 + "'" + ",[MoreThanPlus176] = '" + MoreThanPlus176 + "'" + " WHERE [ID] = '" + ID + "'" + " "; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; cmd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.ToString(), "EDIT FAIL!"); } finally { conn.Close(); } }
public void edit(int TemplateID, String TemplateName, String TemplateDescription, String OriginalFile, String ReportIdentifier, String ReportID, String ReportType, String ReportVersion, int Predefined, byte[] TemplateBinary) { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "USE [rbi]" + " " + "UPDATE [dbo].[REPORT_TEMPLATE]" + "SET [TemplateName] = '" + TemplateName + "'" + ",[TemplateDescription] = '" + TemplateDescription + "'" + ",[OriginalFile] = '" + OriginalFile + "'" + ",[ReportIdentifier] = '" + ReportIdentifier + "'" + ",[ReportID] = '" + ReportID + "'" + ",[ReportType] = '" + ReportType + "'" + ",[ReportVersion] = '" + ReportVersion + "'" + ",[Predefined] = '" + Predefined + "'" + ",[TemplateBinary] = '" + TemplateBinary + "'" + "WHERE [TemplateID] = '" + TemplateID + "'" + " "; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; cmd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.ToString(), "EDIT FAIL!"); } finally { conn.Close(); conn.Dispose(); } }
public void edit(int ID, double CoFValue, String CoFCategory, double ProdCost, float EquipOutageMultiplier, float equipcost, float popdens, float injcost, double CoFMatrixValue) { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "USE [rbi]" + " " + "UPDATE [dbo].[RW_FULL_COF_TANK]" + "SET [ID] = '" + ID + "'" + ",[CoFValue] = '" + CoFValue + "'" + ",[CoFCategory] = '" + CoFCategory + "'" + ",[ProdCost] = '" + ProdCost + "'" + ",[EquipOutageMultiplier] = '" + EquipOutageMultiplier + "'" + ",[equipcost] = '" + equipcost + "'" + ",[popdens] = '" + popdens + "'" + ",[injcost] = '" + injcost + "'" + ",[CoFMatrixValue] = '" + CoFMatrixValue + "'" + " WHERE [ID] = '" + ID + "'" + " "; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; cmd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.ToString(), "EDIT FAIL!"); //MessageBox.Show(e.ToString()); } finally { conn.Close(); conn.Dispose(); } }
public int getIDbyName(String EquipmentTypeName) { int ID = 0; SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "USE [rbi]" + "SELECT [EquipmentTypeID]" + ",[EquipmentTypeCode]" + ",[EquipmentTypeName]" + "FROM [rbi].[dbo].[EQUIPMENT_TYPE] WHERE [EquipmentTypeName] ='" + EquipmentTypeName + "'"; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader.HasRows) { ID = reader.GetInt32(0); } } } } catch { MessageBox.Show("GET DATA SOURCE FAIL!"); } finally { conn.Close(); } return(ID); }
public Boolean checkExistDamageMechanism(int ID, int DM_ID) { Boolean IsExist = false; SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "select IsActive from rbi.dbo.RW_DAMAGE_MECHANISM where ID = '" + ID + "' and DMItemID = '" + DM_ID + "'"; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader.IsDBNull(0)) { IsExist = false; } else { IsExist = true; } } } } catch (Exception e) { MessageBox.Show(e.ToString(), "GET DATA FAIL!"); } finally { conn.Close(); } return(IsExist); }
// lay ra maxInspec Eff public String getMaxInspEffec(int CompID, int DMItemID) { String eff = "E"; SqlConnection con = MSSQLDBUtils.GetDBConnection(); con.Open(); String sql = "SELECT MIN([EffectivenessCode]) FROM [rbi].[dbo].[RW_INSPECTION_DETAIL] WHERE [ComponentID] = '" + CompID + "' and [DMItemID] = '" + DMItemID + "'"; try { SqlCommand cmd = new SqlCommand(); cmd.CommandText = sql; cmd.Connection = con; using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader.HasRows) { if (!reader.IsDBNull(0)) { eff = reader.GetString(0); } } } } } catch (Exception ex) { MessageBox.Show("get Data inspection fail" + ex.ToString(), "Cortek"); } finally { con.Close(); con.Dispose(); } return(eff); }
public void edit(int ID, float LF1Factor, float LF4Factor, float LF5Factor, float LF6Factor, float LF7Factor, float LF1, float LF4, float LF5, float LF6, float LF7) { { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "USE [rbi]" + "UPDATE [dbo].[RW_LF_MASTER] " + "SET[ID] = '" + ID + "'" + ",[LF1Factor] = '" + LF1Factor + "'" + ",[LF4Factor] = '" + LF4Factor + "'" + ",[LF5Factor] = '" + LF5Factor + "'" + ",[LF6Factor] = '" + LF6Factor + "'" + ",[LF7Factor] = '" + LF7Factor + "'" + ",[LF1] = '" + LF1 + "'" + ",[LF4] = '" + LF4 + "'" + ",[LF5] = '" + LF5 + "'" + ",[LF6] = '" + LF6 + "'" + ",[LF7] = '" + LF7 + "'" + " WHERE [ID] = '" + ID + "'"; try { SqlCommand cmd = new SqlCommand(); cmd.CommandText = sql; cmd.Connection = conn; cmd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.ToString(), "EDIT FAIL!"); } finally { conn.Close(); conn.Dispose(); } } }
public void add(int PlanID, int EquipmentID, int ComponentID, String Remarks, String Findings, String FindingRTF) { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "USE [rbi]" + "INSERT INTO [dbo].[INSPECTION_COVERAGE]" + "([PlanID]" + ",[EquipmentID]" + ",[ComponentID]" + ",[Remarks]" + ",[Findings]" + ",[FindingRTF])" + "VALUES" + "('" + PlanID + "'" + ",'" + EquipmentID + "'" + ",'" + ComponentID + "'" + ",'" + Remarks + "'" + ",'" + Findings + "'" + ",'" + FindingRTF + "')"; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; cmd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.ToString(), "ADD FAIL!"); } finally { conn.Close(); conn.Dispose(); } }
public List <String> getDMDescription() { string obj = null; List <string> listobj = new List <string>(); SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = " Use [rbi] Select [DMDescription]" + "From [rbi].[dbo].[DM_ITEMS]"; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader.HasRows) { obj = reader.GetString(0); listobj.Add(obj); } } } } catch (Exception e) { MessageBox.Show(e.ToString(), "GET DATA FAIL!"); } finally { conn.Close(); conn.Dispose(); } return(listobj); }
public int getIDbyName(String name) { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); int ID = 0; String sql = " Use [rbi] Select [ComponentTypeID]" + ",[ComponentTypeName]" + ",[ComponentTypeCode]" + "From [rbi].[dbo].[COMPONENT_TYPE] WHERE [ComponentTypeName] = '" + name + "'"; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader.HasRows) { ID = reader.GetInt32(0); } } } } catch (Exception e) { MessageBox.Show(e.ToString(), "GET DATA FAIL!"); } finally { conn.Close(); conn.Dispose(); } return(ID); }
public int getIDbyName(String name) { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); int ID = 0; String sql = " Use [rbi] Select [DesignCodeID]" + ",[DesignCode]" + ",[DesignCodeApp]" + "From [rbi].[dbo].[DESIGN_CODE] WHERE [DesignCode] ='" + name + "' "; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader.HasRows) { ID = reader.GetInt32(0); } } } } catch (Exception e) { ID = 0; } finally { conn.Close(); conn.Dispose(); } return(ID); }
public void edit(int RevisionID, int CoverageDetailID, String ComponentNumber, int CoverageID, int DMItemID, int IMTypeID, DateTime InspectionDate, String EffectivenessCode, int CarriedOut, DateTime CarriedOutDate) { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "USE [rbi]" + " UPDATE[dbo].[EQUIPMENT_REVISION_INSPECTION]" + "SET[RevisionID] ='" + RevisionID + "'" + ",[CoverageDetailID] ='" + CoverageDetailID + "'" + ",[ComponentNumber] = '" + CoverageID + "'" + ",[DMItemID] = '" + DMItemID + "'" + ",[IMTypeID] = '" + IMTypeID + "'" + ",[CoverageID] = '" + CoverageID + "'" + ",[InspectionDate] = '" + InspectionDate + "'" + ",[EffectivenessCode] = '" + EffectivenessCode + "'" + ",[CarriedOut] = '" + CarriedOut + "'" + ",[CarriedOutDate] = '" + CarriedOutDate + "'" + "WHERE [RevisionID] ='" + RevisionID + "'" + "AND [CoverageDetailID] ='" + CoverageDetailID + "'"; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; cmd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.ToString(), "EDIT FAIL!"); } finally { conn.Close(); } }
public Boolean checkExist(String name) { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); Boolean check = false; String sql = "Use [rbi]" + "SELECT [SiteID]" + ",[SiteName]" + " FROM [rbi].[dbo].[SITES] WHERE [SiteName] = '" + name + "'"; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; using (DbDataReader reader = cmd.ExecuteReader()) { while (reader.Read()) { if (reader.HasRows) { check = true; } } } } catch (Exception e) { MessageBox.Show(e.ToString()); } finally { conn.Close(); conn.Dispose(); } return(check); }
public void edit(int ID, String FluidName, float NBP, float MW, float Density, int ChemicalFactor, int HealthDegree, int Flammability, int Reactivity) { { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "USE [rbi]" + "UPDATE [dbo].[RW_PRIMARY_FLUID] " + "SET[ID] = '" + ID + "'" + ",[FluidName] = '" + FluidName + "'" + ",[NBP] = '" + NBP + "'" + ",[MW] = '" + MW + "'" + ",[Density] = '" + Density + "'" + ",[ChemicalFactor] = '" + ChemicalFactor + "'" + ",[HealthDegree] = '" + HealthDegree + "'" + ",[Flammability] = '" + Flammability + "'" + ",[Reactivity] = '" + Reactivity + "'" + " WHERE [ID] = '" + ID + "'"; try { SqlCommand cmd = new SqlCommand(); cmd.CommandText = sql; cmd.Connection = conn; cmd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.ToString(), "EDIT FAIL!"); } finally { conn.Close(); conn.Dispose(); } } }
public void delete(int ExtraFieldID) { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "USE [rbi] DELETE FROM [dbo].[EXTRA_FIELDS_SETTING_COMPONENT] where [ExtraFieldID]='" + ExtraFieldID + "'"; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; cmd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.ToString(), "DELETE FAIL!"); } finally { conn.Close(); } }
public void delete(int FileID) { SqlConnection conn = MSSQLDBUtils.GetDBConnection(); conn.Open(); String sql = "USE [rbi] DELETE FROM [dbo].[FILE_EQUIPMENT] WHERE [FileID] = '" + FileID + "'"; try { SqlCommand cmd = new SqlCommand(); cmd.Connection = conn; cmd.CommandText = sql; cmd.ExecuteNonQuery(); } catch (Exception e) { MessageBox.Show(e.ToString(), "DELETE FAIL!"); } finally { conn.Close(); } }