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));
}
