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 bool addServiceNote(ServiceNote rt, XElement xml, out string ServiceNoteId) { var result = serviceNoteDAT.addServiceNote(rt, xml); if (result.Rows[0].ItemArray[0].ToString() == "0") { ServiceNoteId = result.Rows[0].ItemArray[1].ToString(); return true; } ServiceNoteId = ""; return false; }
public ServiceNoteEdit(ServiceNote serviceNote) { Init(); Text = "Edit service note"; txtId.Text = serviceNote.Id; dateTimePickerDate.Text = serviceNote.Date; cmbContractId.SelectedText = serviceNote.Conntractid; txtRoomName.Text = serviceNote.RoomName; txtTotalMoney.Text = serviceNote.Total.ToString(); //Load service note detail here this.dgvServiceNoteDetail.DataSource = serviceNoteBLT.getListServiceNoteDetailById(serviceNote.Id); }
private void btnEdit_Click(object sender, EventArgs e) { if (txtId.Text == string.Empty) { MessageBox.Show("You don't choose a service note to edit!", "Infomations", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { ServiceNote svcn = new ServiceNote() { Id = txtId.Text, Date = dateTimePickerDate.Text, Conntractid=cmbContractId.SelectedText, RoomName = cmbRoomName.SelectedText, Total = decimal.Parse(txtTotalMoney.Text.Trim()) }; ServiceNoteEdit serviceNoteEdit = new ServiceNoteEdit(svcn); serviceNoteEdit.EditCompletedHandler += FormServiceNoteEdit_Completed; serviceNoteEdit.ShowDialog(); } }
public DataTable addServiceNote(ServiceNote svcn, XElement xml) { try { string[] names = new string[5]; object[] values = new object[5]; names[0] = "@p_ID"; values[0] = svcn.Id; names[1] = "@p_CONTRACTID"; values[1] = svcn.Conntractid; names[2] = "@p_DATE"; values[2] = svcn.Date; names[3] = "@p_TOTAL"; values[3] = svcn.Total; names[4] = "@p_XML_DATA"; values[4] = xml.ToString(); return this.ExcuteStoreProcedure("SERVICENOTE_Ins", names, values); } catch (System.Exception ex) { Console.WriteLine("Message = {1}", ex.Message); } return null; }
private void btnSave_Click(object sender, EventArgs e) { ServiceNote svcn = new ServiceNote() { Id = txtId.Text, Date = dateTimePickerDate.Text, Total = decimal.Parse(txtTotalMoney.Text.Trim() == "" ? "0" : txtTotalMoney.Text.Trim()), Conntractid = ""//.Text.Trim(), }; if (this.Text == "Edit service note") { //Edit if (serviceNoteBLT.updateServiceNote(svcn)) { MessageBox.Show("Update " + txtId.Text.Trim().ToUpper() + " successfully!"); EditCompletedHandler(txtId.Text.Trim()); this.Close(); } else MessageBox.Show("Update " + txtId.Text.ToUpper() + " fail!"); } else { //Insert string id; if (serviceNoteBLT.addServiceNote(svcn, out id)) { MessageBox.Show("Insert service note of " + txtRoomName.Text.Trim().ToUpper() + " successfully!\nThe new service note Id = " + id + "."); EditCompletedHandler(id); this.Close(); } else MessageBox.Show("Insert fail! Try again later."); } }
private void CheckEditContract(string contractId) { var temp = new ServiceNote() { Conntractid = contractId }; DataTable result = serviceNoteBLT.searchServiceNote(temp, ""); if (result != null && result.Rows.Count > 0) { //this.btnEdit.Text = "View detail"; this.btnDelete.Enabled = false; } else { //this.btnEdit.Text = "Edit"; this.btnDelete.Enabled = true; } }
public bool updateServiceNote(ServiceNote rt, XElement xml) { var result = serviceNoteDAT.updateServiceNote(rt, xml); if (result.Rows[0].ItemArray[0].ToString() == "0") { return true; } return false; }
public DataTable searchServiceNote(ServiceNote rt, string roomName) { return serviceNoteDAT.searchServiceNote(rt, roomName); }
private string SaveServiceNote() { string serviceNoteId = null; if (checkContraints()) { try { XElement xmlData = ConvertToXmlData(); ServiceNote svcn = new ServiceNote() { Id = txtId.Text, Date = dateTimePickerDate.Text, Total = decimal.Parse(txtTotalMoney.Text.Trim() == "" ? "0" : txtTotalMoney.Text.Trim()), Conntractid = txtContractID.Text.Trim() }; if (this.Text == "Edit service note") { //Edit if (serviceNoteBLT.updateServiceNote(svcn, xmlData)) { MessageBox.Show("Update " + txtId.Text.Trim().ToUpper() + " successfully!"); EditCompletedHandler(txtId.Text.Trim()); serviceNoteId = txtId.Text.Trim(); //this.Close(); } else MessageBox.Show("Update " + txtId.Text.ToUpper() + " fail!"); } else { //Insert string id; if (serviceNoteBLT.addServiceNote(svcn, xmlData, out id)) { MessageBox.Show("Insert service note of " + txtContractID.Text.Trim().ToUpper() + " successfully!\nThe new service note Id = " + id + "."); EditCompletedHandler(id); serviceNoteId = id; //this.Close(); } else MessageBox.Show("Insert fail! Try again later."); } } catch (Exception ex) { MessageBox.Show(ex.Message); } } return serviceNoteId; }
private void btnEdit_Click(object sender, EventArgs e) { if (txtId.Text == string.Empty) { MessageBox.Show("You don't choose a service note to " + btnEdit.Text + "!", "Infomations", MessageBoxButtons.OK, MessageBoxIcon.Information); } else { ServiceNote svcn = new ServiceNote() { Id = txtId.Text.Trim(), Date = dateTimePickerDate.Text, Conntractid = (cmbContractId.SelectedValue == null) ? "" : cmbContractId.SelectedValue.ToString(), Total = decimal.Parse(txtTotalMoney.Text.Trim() == "" ? "0" : txtTotalMoney.Text.Trim()) }; ServiceNoteEdit serviceNoteEdit = new ServiceNoteEdit(svcn, (cmbRoomName.SelectedValue == null) ? "" : cmbRoomName.SelectedValue.ToString(), btnEdit.Text=="Edit"?true:false); if(btnEdit.Text=="Edit") serviceNoteEdit.EditCompletedHandler += FormServiceNoteEdit_Completed; serviceNoteEdit.ShowDialog(); } }
private void btnSearch_Click(object sender, EventArgs e) { if (btnSearch.Text == "Reset") { this.resetUI(); this.changeModeEditUI(true); } else { ServiceNote svcn = new ServiceNote() { Id = txtId.Text.Trim(), Date = dateTimePickerDate.Text, Conntractid = (cmbContractId.SelectedValue == null) ? "" : cmbContractId.SelectedValue.ToString(), Total= decimal.Parse(txtTotalMoney.Text.Trim() == "" ? "0" : txtTotalMoney.Text.Trim()) }; this.dgvServiceNote.DataSource = serviceNoteBLT.searchServiceNote(svcn, (cmbRoomName.SelectedIndex < 0) ? "" : cmbRoomName.SelectedValue.ToString()); } }
public bool updateServiceNote(ServiceNote rt) { return serviceNoteDAT.updateServiceNote(rt); }
public DataTable searchServiceNote(ServiceNote rt) { return serviceNoteDAT.searchServiceNote(rt); }
public DataTable searchServiceNote(ServiceNote svcn, string roomName) { try { string[] names = new string[6]; object[] values = new object[6]; names[0] = "@p_ID"; values[0] = svcn.Id; names[1] = "@p_CONTRACTID"; values[1] = svcn.Conntractid; names[2] = "@p_DATE"; values[2] = svcn.Date; names[3] = "@p_TOTAL"; values[3] = svcn.Total; names[4] = "@p_ROOMNAME"; values[4] = roomName; names[5] = "@p_TOP"; values[5] = 0; return this.ExcuteStoreProcedure("SERVICENOTE_Search", names, values); } catch (System.Exception ex) { Console.WriteLine("Message = {1}", ex.Message); } return null; }