C# (CSharp) DataAccessLayer Cls_LoaiPhong_DTA Examples

Example #1

File: Cls_LoaiPhong_DTA.cs Project: MHHHK1/Karaoke

 public Cls_LoaiPhong_DTA(Cls_LoaiPhong_DTA LPhong_Data)
 {
     MaLoai = LPhong_Data.MaLoai;
     TenLoai = LPhong_Data.TenLoai;
     GioCD = LPhong_Data.GioCD;
     GioBT = LPhong_Data.GioBT;
 }

Example #2

File: Cls_LoaiPhong_DTA.cs Project: 51503613/karaoke

 public Cls_LoaiPhong_DTA(Cls_LoaiPhong_DTA LPhong_Data)
 {
     MaLoai  = LPhong_Data.MaLoai;
     TenLoai = LPhong_Data.TenLoai;
     GioCD   = LPhong_Data.GioCD;
     GioBT   = LPhong_Data.GioBT;
 }

Example #3

File: Cls_LoaiPhong_BUS.cs Project: MHHHK1/Karaoke

         public void Insert_Update_Delete(Cls_LoaiPhong_DTA LP_Data, string sThucThi)
         {
             sConn.Open();

             SqlCommand cmd = new SqlCommand();
             cmd.CommandText = "SP_LoaiPhong";
             cmd.Connection = this.sConn;
             cmd.CommandType = CommandType.StoredProcedure;

             cmd.Parameters.Add("@MaLoai", SqlDbType.Char);
             cmd.Parameters["@MaLoai"].Value = LP_Data.MaLoai;

             cmd.Parameters.Add("@TenPhong", SqlDbType.NVarChar);
             cmd.Parameters["@TenPhong"].Value = LP_Data.TenLoai;

             cmd.Parameters.Add("@GioCD", SqlDbType.Float);
             cmd.Parameters["@GioCD"].Value = LP_Data.GioCD;

             cmd.Parameters.Add("@GioBT", SqlDbType.Float);
             cmd.Parameters["@GioBT"].Value = LP_Data.GioBT;
           

             cmd.Parameters.Add("@sqlTemp", SqlDbType.NVarChar);
             if (sThucThi == "Insert" || sThucThi == "Delete" || sThucThi == "Update")
                 cmd.Parameters["@sqlTemp"].Value = sThucThi;
             cmd.ExecuteNonQuery();

             sConn.Close();
         }

Example #4

File: Cls_LoaiPhong_PTA.cs Project: MHHHK1/Karaoke

 public void Insert_Update_Delete(Cls_LoaiPhong_DTA LP_Data,string sThucThi)
 {
     LP_Bus.Insert_Update_Delete(LP_Data, sThucThi);
 }