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;
}
