public static Pos_ProductTransaction GetPos_ProductTransactionByID(int id)
 {
     Pos_ProductTransaction pos_ProductTransaction = new Pos_ProductTransaction();
     SqlPos_ProductTransactionProvider sqlPos_ProductTransactionProvider = new SqlPos_ProductTransactionProvider();
     pos_ProductTransaction = sqlPos_ProductTransactionProvider.GetPos_ProductTransactionByID(id);
     return pos_ProductTransaction;
 }
示例#2
0
 public Pos_ProductTransaction GetPos_ProductTransactionFromReader(IDataReader reader)
 {
     try
     {
         Pos_ProductTransaction pos_ProductTransaction = new Pos_ProductTransaction
                                                         (
             (int)reader["Pos_ProductTransactionID"],
             (int)reader["Pos_ProductID"],
             (decimal)reader["Quantity"],
             (int)reader["Pos_ProductTrasactionTypeID"],
             (int)reader["Pos_ProductTransactionMasterID"],
             reader["ExtraField1"].ToString(),
             reader["ExtraField2"].ToString(),
             reader["ExtraField3"].ToString(),
             reader["ExtraField4"].ToString(),
             reader["ExtraField5"].ToString(),
             (int)reader["AddedBy"],
             (DateTime)reader["AddedDate"],
             (int)reader["UpdatedBy"],
             (DateTime)reader["UpdatedDate"],
             (int)reader["RowStatusID"]
                                                         );
         return(pos_ProductTransaction);
     }
     catch (Exception ex)
     {
         return(null);
     }
 }
示例#3
0
    public bool UpdatePos_ProductTransaction(Pos_ProductTransaction pos_ProductTransaction)
    {
        using (SqlConnection connection = new SqlConnection(this.ConnectionString))
        {
            SqlCommand cmd = new SqlCommand("GP_UpdatePos_ProductTransaction", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@Pos_ProductTransactionID", SqlDbType.Int).Value       = pos_ProductTransaction.Pos_ProductTransactionID;
            cmd.Parameters.Add("@Pos_ProductID", SqlDbType.Int).Value                  = pos_ProductTransaction.Pos_ProductID;
            cmd.Parameters.Add("@Quantity", SqlDbType.Decimal).Value                   = pos_ProductTransaction.Quantity;
            cmd.Parameters.Add("@Pos_ProductTrasactionTypeID", SqlDbType.Int).Value    = pos_ProductTransaction.Pos_ProductTrasactionTypeID;
            cmd.Parameters.Add("@Pos_ProductTransactionMasterID", SqlDbType.Int).Value = pos_ProductTransaction.Pos_ProductTransactionMasterID;
            cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value               = pos_ProductTransaction.ExtraField1;
            cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value               = pos_ProductTransaction.ExtraField2;
            cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value               = pos_ProductTransaction.ExtraField3;
            cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value               = pos_ProductTransaction.ExtraField4;
            cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value               = pos_ProductTransaction.ExtraField5;
            cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value          = pos_ProductTransaction.AddedBy;
            cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value   = pos_ProductTransaction.AddedDate;
            cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value        = pos_ProductTransaction.UpdatedBy;
            cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = pos_ProductTransaction.UpdatedDate;
            cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value      = pos_ProductTransaction.RowStatusID;
            connection.Open();

            int result = cmd.ExecuteNonQuery();
            return(result == 1);
        }
    }
示例#4
0
    public static Pos_ProductTransaction GetPos_ProductTransactionByID(int id)
    {
        Pos_ProductTransaction            pos_ProductTransaction            = new Pos_ProductTransaction();
        SqlPos_ProductTransactionProvider sqlPos_ProductTransactionProvider = new SqlPos_ProductTransactionProvider();

        pos_ProductTransaction = sqlPos_ProductTransactionProvider.GetPos_ProductTransactionByID(id);
        return(pos_ProductTransaction);
    }
 public static bool UpdatePos_ProductTransaction(Pos_ProductTransaction pos_ProductTransaction)
 {
     SqlPos_ProductTransactionProvider sqlPos_ProductTransactionProvider = new SqlPos_ProductTransactionProvider();
     return sqlPos_ProductTransactionProvider.UpdatePos_ProductTransaction(pos_ProductTransaction);
 }
 public static int InsertPos_ProductTransaction(Pos_ProductTransaction pos_ProductTransaction)
 {
     SqlPos_ProductTransactionProvider sqlPos_ProductTransactionProvider = new SqlPos_ProductTransactionProvider();
     return sqlPos_ProductTransactionProvider.InsertPos_ProductTransaction(pos_ProductTransaction);
 }
示例#7
0
    public static bool UpdatePos_ProductTransaction(Pos_ProductTransaction pos_ProductTransaction)
    {
        SqlPos_ProductTransactionProvider sqlPos_ProductTransactionProvider = new SqlPos_ProductTransactionProvider();

        return(sqlPos_ProductTransactionProvider.UpdatePos_ProductTransaction(pos_ProductTransaction));
    }
示例#8
0
    public static int InsertPos_ProductTransaction(Pos_ProductTransaction pos_ProductTransaction)
    {
        SqlPos_ProductTransactionProvider sqlPos_ProductTransactionProvider = new SqlPos_ProductTransactionProvider();

        return(sqlPos_ProductTransactionProvider.InsertPos_ProductTransaction(pos_ProductTransaction));
    }
 public Pos_ProductTransaction GetPos_ProductTransactionFromReader(IDataReader reader)
 {
     try
     {
         Pos_ProductTransaction pos_ProductTransaction = new Pos_ProductTransaction
             (
                 (int)reader["Pos_ProductTransactionID"],
                 (int)reader["Pos_ProductID"],
                 (decimal)reader["Quantity"],
                 (int)reader["Pos_ProductTrasactionTypeID"],
                 (int)reader["Pos_ProductTransactionMasterID"],
                 reader["ExtraField1"].ToString(),
                 reader["ExtraField2"].ToString(),
                 reader["ExtraField3"].ToString(),
                 reader["ExtraField4"].ToString(),
                 reader["ExtraField5"].ToString(),
                 (int)reader["AddedBy"],
                 (DateTime)reader["AddedDate"],
                 (int)reader["UpdatedBy"],
                 (DateTime)reader["UpdatedDate"],
                 (int)reader["RowStatusID"]
             );
          return pos_ProductTransaction;
     }
     catch(Exception ex)
     {
         return null;
     }
 }
    public bool UpdatePos_ProductTransaction(Pos_ProductTransaction pos_ProductTransaction)
    {
        using (SqlConnection connection = new SqlConnection(this.ConnectionString))
        {
            SqlCommand cmd = new SqlCommand("GP_UpdatePos_ProductTransaction", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@Pos_ProductTransactionID", SqlDbType.Int).Value = pos_ProductTransaction.Pos_ProductTransactionID;
            cmd.Parameters.Add("@Pos_ProductID", SqlDbType.Int).Value = pos_ProductTransaction.Pos_ProductID;
            cmd.Parameters.Add("@Quantity", SqlDbType.Decimal).Value = pos_ProductTransaction.Quantity;
            cmd.Parameters.Add("@Pos_ProductTrasactionTypeID", SqlDbType.Int).Value = pos_ProductTransaction.Pos_ProductTrasactionTypeID;
            cmd.Parameters.Add("@Pos_ProductTransactionMasterID", SqlDbType.Int).Value = pos_ProductTransaction.Pos_ProductTransactionMasterID;
            cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = pos_ProductTransaction.ExtraField1;
            cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = pos_ProductTransaction.ExtraField2;
            cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = pos_ProductTransaction.ExtraField3;
            cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = pos_ProductTransaction.ExtraField4;
            cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = pos_ProductTransaction.ExtraField5;
            cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = pos_ProductTransaction.AddedBy;
            cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = pos_ProductTransaction.AddedDate;
            cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = pos_ProductTransaction.UpdatedBy;
            cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = pos_ProductTransaction.UpdatedDate;
            cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = pos_ProductTransaction.RowStatusID;
            connection.Open();

            int result = cmd.ExecuteNonQuery();
            return result == 1;
        }
    }