public ServiceNoteEdit(ServiceNote serviceNote, string roomName, bool canEdit)
        {
            Init();
            Load += ServiceNoteEdit_Load;
            if (canEdit)
            {
                Text = "Edit service note";
            }
            else
            {
                Text = "Detail service note";
                btnSave.Text = "Close";
                btnSaveAndExport.Enabled = false;
            }

            txtId.Text = serviceNote.Id;
            dateTimePickerDate.Text = serviceNote.Date;
            cmbRoom.SelectedIndex = cmbRoom.FindStringExact(roomName);
            cmbRoom.Enabled = false;
            txtContractID.Text = serviceNote.Conntractid;
            txtTotalMoney.Text = serviceNote.Total.ToString();

            //Load service note detail here
            var searchInfo = new ServiceNoteDetail()
            {
                Servicenoteid = serviceNote.Id
            };

            dgvServiceNoteDetail.DataSource = serviceNoteBLT.searchServiceNoteDetail(searchInfo);
        }
 public DataTable searchServiceNoteDetail(ServiceNoteDetail rt)
 {
     return serviceNoteDAT.searchServiceNoteDetail(rt);
 }
        public DataTable searchServiceNoteDetail(ServiceNoteDetail svcnd)
        {
            try
            {
                string[] names = new string[8];
                object[] values = new object[8];

                names[0] = "@p_ID"; values[0] = svcnd.Id;
                names[1] = "@p_SERVICENOTEID"; values[1] = svcnd.Servicenoteid;
                names[2] = "@p_SERVICEID"; values[2] = svcnd.Serviceid;
                names[3] = "@p_NUMBEROLD"; values[3] = svcnd.Numberold;
                names[4] = "@p_NUMBERNEW"; values[4] = svcnd.Numbernew;
                names[5] = "@p_NUMBERUSED"; values[5] = svcnd.NumberUsed;
                names[6] = "@p_TOTAL"; values[6] = svcnd.Total;
                names[7] = "@p_TOP"; values[7] = 0;

                return this.ExcuteStoreProcedure("SERVICENOTEDETAIL_Search", names, values);
            }
            catch (System.Exception ex)
            {
                Console.WriteLine("Message = {1}", ex.Message);
            }

            return null;
        }