Example #1
0
 public Pos_ProductTransactionMaster GetPos_ProductTransactionMasterFromReader(IDataReader reader)
 {
     try
     {
         Pos_ProductTransactionMaster pos_ProductTransactionMaster = new Pos_ProductTransactionMaster
                                                                     (
             (int)reader["Pos_ProductTransactionMasterID"],
             (DateTime)reader["TransactionDate"],
             (int)reader["TransactionID"],
             (int)reader["ToOrFromID"],
             reader["Record"].ToString(),
             reader["Particulars"].ToString(),
             (int)reader["WorkSatationID"],
             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_ProductTransactionMaster);
     }
     catch (Exception ex)
     {
         return(null);
     }
 }
Example #2
0
    public bool UpdatePos_ProductTransactionMaster(Pos_ProductTransactionMaster pos_ProductTransactionMaster)
    {
        using (SqlConnection connection = new SqlConnection(this.ConnectionString))
        {
            SqlCommand cmd = new SqlCommand("GP_UpdatePos_ProductTransactionMaster", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@Pos_ProductTransactionMasterID", SqlDbType.Int).Value = pos_ProductTransactionMaster.Pos_ProductTransactionMasterID;
            cmd.Parameters.Add("@TransactionDate", SqlDbType.DateTime).Value           = pos_ProductTransactionMaster.TransactionDate;
            cmd.Parameters.Add("@TransactionID", SqlDbType.Int).Value    = pos_ProductTransactionMaster.TransactionID;
            cmd.Parameters.Add("@ToOrFromID", SqlDbType.Int).Value       = pos_ProductTransactionMaster.ToOrFromID;
            cmd.Parameters.Add("@Record", SqlDbType.NVarChar).Value      = pos_ProductTransactionMaster.Record;
            cmd.Parameters.Add("@Particulars", SqlDbType.NText).Value    = pos_ProductTransactionMaster.Particulars;
            cmd.Parameters.Add("@WorkSatationID", SqlDbType.Int).Value   = pos_ProductTransactionMaster.WorkSatationID;
            cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = pos_ProductTransactionMaster.ExtraField1;
            cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = pos_ProductTransactionMaster.ExtraField2;
            cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = pos_ProductTransactionMaster.ExtraField3;
            cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = pos_ProductTransactionMaster.ExtraField4;
            cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = pos_ProductTransactionMaster.ExtraField5;
            cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value          = pos_ProductTransactionMaster.AddedBy;
            cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value   = pos_ProductTransactionMaster.AddedDate;
            cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value        = pos_ProductTransactionMaster.UpdatedBy;
            cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = pos_ProductTransactionMaster.UpdatedDate;
            cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value      = pos_ProductTransactionMaster.RowStatusID;
            connection.Open();

            int result = cmd.ExecuteNonQuery();
            return(result == 1);
        }
    }
    public static Pos_ProductTransactionMaster GetPos_ProductTransactionMasterByID(int id)
    {
        Pos_ProductTransactionMaster            pos_ProductTransactionMaster            = new Pos_ProductTransactionMaster();
        SqlPos_ProductTransactionMasterProvider sqlPos_ProductTransactionMasterProvider = new SqlPos_ProductTransactionMasterProvider();

        pos_ProductTransactionMaster = sqlPos_ProductTransactionMasterProvider.GetPos_ProductTransactionMasterByID(id);
        return(pos_ProductTransactionMaster);
    }
 public Pos_ProductTransactionMaster GetPos_ProductTransactionMasterFromReader(IDataReader reader)
 {
     try
     {
         Pos_ProductTransactionMaster pos_ProductTransactionMaster = new Pos_ProductTransactionMaster
             (
                 (int)reader["Pos_ProductTransactionMasterID"],
                 (DateTime)reader["TransactionDate"],
                 (int)reader["TransactionID"],
                 (int)reader["ToOrFromID"],
                 reader["Record"].ToString(),
                 reader["Particulars"].ToString(),
                 (int)reader["WorkSatationID"],
                 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_ProductTransactionMaster;
     }
     catch(Exception ex)
     {
         return null;
     }
 }
    public bool UpdatePos_ProductTransactionMaster(Pos_ProductTransactionMaster pos_ProductTransactionMaster)
    {
        using (SqlConnection connection = new SqlConnection(this.ConnectionString))
        {
            SqlCommand cmd = new SqlCommand("GP_UpdatePos_ProductTransactionMaster", connection);
            cmd.CommandType = CommandType.StoredProcedure;
            cmd.Parameters.Add("@Pos_ProductTransactionMasterID", SqlDbType.Int).Value = pos_ProductTransactionMaster.Pos_ProductTransactionMasterID;
            cmd.Parameters.Add("@TransactionDate", SqlDbType.DateTime).Value = pos_ProductTransactionMaster.TransactionDate;
            cmd.Parameters.Add("@TransactionID", SqlDbType.Int).Value = pos_ProductTransactionMaster.TransactionID;
            cmd.Parameters.Add("@ToOrFromID", SqlDbType.Int).Value = pos_ProductTransactionMaster.ToOrFromID;
            cmd.Parameters.Add("@Record", SqlDbType.NVarChar).Value = pos_ProductTransactionMaster.Record;
            cmd.Parameters.Add("@Particulars", SqlDbType.NText).Value = pos_ProductTransactionMaster.Particulars;
            cmd.Parameters.Add("@WorkSatationID", SqlDbType.Int).Value = pos_ProductTransactionMaster.WorkSatationID;
            cmd.Parameters.Add("@ExtraField1", SqlDbType.NVarChar).Value = pos_ProductTransactionMaster.ExtraField1;
            cmd.Parameters.Add("@ExtraField2", SqlDbType.NVarChar).Value = pos_ProductTransactionMaster.ExtraField2;
            cmd.Parameters.Add("@ExtraField3", SqlDbType.NVarChar).Value = pos_ProductTransactionMaster.ExtraField3;
            cmd.Parameters.Add("@ExtraField4", SqlDbType.NVarChar).Value = pos_ProductTransactionMaster.ExtraField4;
            cmd.Parameters.Add("@ExtraField5", SqlDbType.NVarChar).Value = pos_ProductTransactionMaster.ExtraField5;
            cmd.Parameters.Add("@AddedBy", SqlDbType.Int).Value = pos_ProductTransactionMaster.AddedBy;
            cmd.Parameters.Add("@AddedDate", SqlDbType.DateTime).Value = pos_ProductTransactionMaster.AddedDate;
            cmd.Parameters.Add("@UpdatedBy", SqlDbType.Int).Value = pos_ProductTransactionMaster.UpdatedBy;
            cmd.Parameters.Add("@UpdatedDate", SqlDbType.DateTime).Value = pos_ProductTransactionMaster.UpdatedDate;
            cmd.Parameters.Add("@RowStatusID", SqlDbType.Int).Value = pos_ProductTransactionMaster.RowStatusID;
            connection.Open();

            int result = cmd.ExecuteNonQuery();
            return result == 1;
        }
    }
    public static bool UpdatePos_ProductTransactionMaster(Pos_ProductTransactionMaster pos_ProductTransactionMaster)
    {
        SqlPos_ProductTransactionMasterProvider sqlPos_ProductTransactionMasterProvider = new SqlPos_ProductTransactionMasterProvider();

        return(sqlPos_ProductTransactionMasterProvider.UpdatePos_ProductTransactionMaster(pos_ProductTransactionMaster));
    }
    public static int InsertPos_ProductTransactionMaster(Pos_ProductTransactionMaster pos_ProductTransactionMaster)
    {
        SqlPos_ProductTransactionMasterProvider sqlPos_ProductTransactionMasterProvider = new SqlPos_ProductTransactionMasterProvider();

        return(sqlPos_ProductTransactionMasterProvider.InsertPos_ProductTransactionMaster(pos_ProductTransactionMaster));
    }