public void InsertStockInfo(StockInfo stockInfo) { SQLConn sQLConn = new SQLConn(); string query = @"insert into StockInfo( SEngineNo , SChassisNo , SCompany , SModel , SAmount , SRegNo , SFileNo , SDate , CopyRecived , LetterRecived ) values(@SEngineNo , @SChassisNo , @SCompany , @SModel , @SAmount , @SRegNo , @SFileNo , @SDate , @CopyRecived , @LetterRecived)"; SqlCommand sqlCommand = new SqlCommand(query, sQLConn.GetConnToLocalDb()); SqlParameter sqlParameter = new SqlParameter { ParameterName = "SEngineNo", SqlDbType = System.Data.SqlDbType.NVarChar, Value = stockInfo.SEngineNo }; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter { ParameterName = "SChassisNo", SqlDbType = System.Data.SqlDbType.NVarChar, Value = stockInfo.SChassisNo }; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter { ParameterName = "SCompany", SqlDbType = System.Data.SqlDbType.NVarChar, Value = stockInfo.SCompany }; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter { ParameterName = "SModel", SqlDbType = System.Data.SqlDbType.NVarChar, Value = stockInfo.SModel }; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter { ParameterName = "SAmount", SqlDbType = System.Data.SqlDbType.Int, Value = stockInfo.SAmount }; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter { ParameterName = "SRegNo", SqlDbType = System.Data.SqlDbType.NVarChar, Value = stockInfo.SRegNo }; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter { ParameterName = "SFileNo", SqlDbType = System.Data.SqlDbType.NVarChar, Value = stockInfo.SFileNo }; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter { ParameterName = "SDate", SqlDbType = System.Data.SqlDbType.Date, Value = stockInfo.SDate }; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter { ParameterName = "CopyRecived", SqlDbType = System.Data.SqlDbType.Int, Value = stockInfo.CopyRecived }; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter { ParameterName = "LetterRecived", SqlDbType = System.Data.SqlDbType.Int, Value = stockInfo.LetterRecived }; sqlCommand.Parameters.Add(sqlParameter); sqlCommand.ExecuteNonQuery(); }
public void UpdateRecord(StockInfo stockInfo, string CSEngineNo) { SQLConn sQLConn = new SQLConn(); string query = @"update stockinfo set SEngineNo = @SEngineNo , SChassisNo = @SChassisNo , SCompany = @SCompany , SModel = SModel , SAmount = SAmount , SRegNo = SRegNo , SFileNo = @SFileNo , SDate = @SDate , CopyRecived = @CopyRecived , LetterRecived = @LetterRecived Where SEngineNo = @CSEngineNo"; SqlCommand sqlCommand = new SqlCommand(query, sQLConn.GetConnToLocalDb()); SqlParameter sqlParameter = new SqlParameter { ParameterName = "SEngineNo", SqlDbType = System.Data.SqlDbType.NVarChar, Value = stockInfo.SEngineNo }; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter { ParameterName = "CSEngineNo", SqlDbType = System.Data.SqlDbType.NVarChar, Value = CSEngineNo }; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter { ParameterName = "SChassisNo", SqlDbType = System.Data.SqlDbType.NVarChar, Value = stockInfo.SChassisNo }; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter { ParameterName = "SCompany", SqlDbType = System.Data.SqlDbType.NVarChar, Value = stockInfo.SCompany }; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter { ParameterName = "SModel", SqlDbType = System.Data.SqlDbType.NVarChar, Value = stockInfo.SModel }; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter { ParameterName = "SAmount", SqlDbType = System.Data.SqlDbType.Int, Value = stockInfo.SAmount }; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter { ParameterName = "SRegNo", SqlDbType = System.Data.SqlDbType.NVarChar, Value = stockInfo.SRegNo }; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter { ParameterName = "SFileNo", SqlDbType = System.Data.SqlDbType.NVarChar, Value = stockInfo.SFileNo }; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter { ParameterName = "SDate", SqlDbType = System.Data.SqlDbType.Date, Value = stockInfo.SDate }; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter { ParameterName = "CopyRecived", SqlDbType = System.Data.SqlDbType.Int, Value = stockInfo.CopyRecived }; sqlCommand.Parameters.Add(sqlParameter); sqlParameter = new SqlParameter { ParameterName = "LetterRecived", SqlDbType = System.Data.SqlDbType.Int, Value = stockInfo.LetterRecived }; sqlCommand.Parameters.Add(sqlParameter); sqlCommand.ExecuteNonQuery(); }