public static Pos_ProductTransactionType GetPos_ProductTransactionTypeByID(int id) { Pos_ProductTransactionType pos_ProductTransactionType = new Pos_ProductTransactionType(); SqlPos_ProductTransactionTypeProvider sqlPos_ProductTransactionTypeProvider = new SqlPos_ProductTransactionTypeProvider(); pos_ProductTransactionType = sqlPos_ProductTransactionTypeProvider.GetPos_ProductTransactionTypeByID(id); return pos_ProductTransactionType; }
public static Pos_ProductTransactionType GetPos_ProductTransactionTypeByID(int id) { Pos_ProductTransactionType pos_ProductTransactionType = new Pos_ProductTransactionType(); SqlPos_ProductTransactionTypeProvider sqlPos_ProductTransactionTypeProvider = new SqlPos_ProductTransactionTypeProvider(); pos_ProductTransactionType = sqlPos_ProductTransactionTypeProvider.GetPos_ProductTransactionTypeByID(id); return(pos_ProductTransactionType); }
public bool UpdatePos_ProductTransactionType(Pos_ProductTransactionType pos_ProductTransactionType) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("GP_UpdatePos_ProductTransactionType", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Pos_ProductTransactionTypeID", SqlDbType.Int).Value = pos_ProductTransactionType.Pos_ProductTransactionTypeID; cmd.Parameters.Add("@ProductTransactionTypeName", SqlDbType.NVarChar).Value = pos_ProductTransactionType.ProductTransactionTypeName; cmd.Parameters.Add("@CentralStockFormula", SqlDbType.NChar).Value = pos_ProductTransactionType.CentralStockFormula; cmd.Parameters.Add("@ShowRoomFormula", SqlDbType.NChar).Value = pos_ProductTransactionType.ShowRoomFormula; cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = pos_ProductTransactionType.ExtraField1; cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = pos_ProductTransactionType.ExtraField2; cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = pos_ProductTransactionType.ExtraField3; connection.Open(); int result = cmd.ExecuteNonQuery(); return(result == 1); } }
public Pos_ProductTransactionType GetPos_ProductTransactionTypeFromReader(IDataReader reader) { try { Pos_ProductTransactionType pos_ProductTransactionType = new Pos_ProductTransactionType ( (int)reader["Pos_ProductTransactionTypeID"], reader["ProductTransactionTypeName"].ToString(), reader["CentralStockFormula"].ToString(), reader["ShowRoomFormula"].ToString(), reader["ExtraField1"].ToString(), reader["ExtraField2"].ToString(), reader["ExtraField3"].ToString() ); return(pos_ProductTransactionType); } catch (Exception ex) { return(null); } }
public Pos_ProductTransactionType GetPos_ProductTransactionTypeFromReader(IDataReader reader) { try { Pos_ProductTransactionType pos_ProductTransactionType = new Pos_ProductTransactionType ( (int)reader["Pos_ProductTransactionTypeID"], reader["ProductTransactionTypeName"].ToString(), reader["CentralStockFormula"].ToString(), reader["ShowRoomFormula"].ToString(), reader["ExtraField1"].ToString(), reader["ExtraField2"].ToString(), reader["ExtraField3"].ToString() ); return pos_ProductTransactionType; } catch(Exception ex) { return null; } }
public bool UpdatePos_ProductTransactionType(Pos_ProductTransactionType pos_ProductTransactionType) { using (SqlConnection connection = new SqlConnection(this.ConnectionString)) { SqlCommand cmd = new SqlCommand("GP_UpdatePos_ProductTransactionType", connection); cmd.CommandType = CommandType.StoredProcedure; cmd.Parameters.Add("@Pos_ProductTransactionTypeID", SqlDbType.Int).Value = pos_ProductTransactionType.Pos_ProductTransactionTypeID; cmd.Parameters.Add("@ProductTransactionTypeName", SqlDbType.NVarChar).Value = pos_ProductTransactionType.ProductTransactionTypeName; cmd.Parameters.Add("@CentralStockFormula", SqlDbType.NChar).Value = pos_ProductTransactionType.CentralStockFormula; cmd.Parameters.Add("@ShowRoomFormula", SqlDbType.NChar).Value = pos_ProductTransactionType.ShowRoomFormula; cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = pos_ProductTransactionType.ExtraField1; cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = pos_ProductTransactionType.ExtraField2; cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = pos_ProductTransactionType.ExtraField3; connection.Open(); int result = cmd.ExecuteNonQuery(); return result == 1; } }
public static bool UpdatePos_ProductTransactionType(Pos_ProductTransactionType pos_ProductTransactionType) { SqlPos_ProductTransactionTypeProvider sqlPos_ProductTransactionTypeProvider = new SqlPos_ProductTransactionTypeProvider(); return sqlPos_ProductTransactionTypeProvider.UpdatePos_ProductTransactionType(pos_ProductTransactionType); }
public static int InsertPos_ProductTransactionType(Pos_ProductTransactionType pos_ProductTransactionType) { SqlPos_ProductTransactionTypeProvider sqlPos_ProductTransactionTypeProvider = new SqlPos_ProductTransactionTypeProvider(); return sqlPos_ProductTransactionTypeProvider.InsertPos_ProductTransactionType(pos_ProductTransactionType); }
public static bool UpdatePos_ProductTransactionType(Pos_ProductTransactionType pos_ProductTransactionType) { SqlPos_ProductTransactionTypeProvider sqlPos_ProductTransactionTypeProvider = new SqlPos_ProductTransactionTypeProvider(); return(sqlPos_ProductTransactionTypeProvider.UpdatePos_ProductTransactionType(pos_ProductTransactionType)); }
public static int InsertPos_ProductTransactionType(Pos_ProductTransactionType pos_ProductTransactionType) { SqlPos_ProductTransactionTypeProvider sqlPos_ProductTransactionTypeProvider = new SqlPos_ProductTransactionTypeProvider(); return(sqlPos_ProductTransactionTypeProvider.InsertPos_ProductTransactionType(pos_ProductTransactionType)); }