private void btnSave_Click(object sender, EventArgs e)
{
ConsultBillService aConsultBillService = new ConsultBillService();
ConsultantCall aConsultantCall = new ConsultantCall();
aConsultantCall.OpId = txtPatientID.Text;
aConsultantCall.ConsultantId = searchLookUpEditConsultant.EditValue.ToString();
aConsultantCall.Id = Convert.ToInt32(txtVoucherNo.Text);
aConsultBillService.OPID = txtPatientID.Text;
aConsultBillService.ConsultId = searchLookUpEditConsultant.EditValue.ToString();
aConsultBillService.ConsultBillDate = dateServiceDate.Text;
aConsultBillService.ConFee = Convert.ToDouble(txtFee.Text);
aConsultBillService.ConQty = 1;
aConsultBillService.VchNo = Convert.ToInt64(txtVoucherNo.Text);
MessageModel message = new ConsultantCallManager().SaveConsultantCall(aConsultantCall, aConsultBillService);
if (message.MessageTitle == "Successful")
{
MetroFramework.MetroMessageBox.Show(this, message.MessageBody, message.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
Refresh();
}
else
{
MetroFramework.MetroMessageBox.Show(this, message.MessageBody, message.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
public int UpdateCosultBilling(ConsultBillService aConsultBillService)
{
Query = "Update tbl_ConsultBillService set OPID = @OPID ,ConsultId= @ConsultId,ConsultBillDate= @ConsultBillDate,ConFee= @ConFee,ConQty= @ConQty where VchNo = @VchNo ";
Command = new SqlCommand(Query, Connection);
Command.CommandType = CommandType.Text;
Command.Parameters.AddWithValue("@OpId", aConsultBillService.OPID);
Command.Parameters.AddWithValue("@ConsultId", aConsultBillService.ConsultId);
Command.Parameters.AddWithValue("@ConsultBillDate", aConsultBillService.ConsultBillDate);
Command.Parameters.AddWithValue("@ConFee", aConsultBillService.ConFee);
Command.Parameters.AddWithValue("@ConQty", aConsultBillService.ConQty);
Command.Parameters.AddWithValue("@VchNo", aConsultBillService.VchNo);
int count = Command.ExecuteNonQuery();
return(count);
}
public int SaveCosultBilling(ConsultBillService aConsultBillService)
{
Query = "INSERT INTO [tbl_ConsultBillService] ([OPID],[ConsultId],[ConsultBillDate],[ConFee],[ConQty],[VchNo])" +
"VALUES(@OPID,@ConsultId,@ConsultBillDate,@ConFee,@ConQty,@VchNo)";
Command = new SqlCommand(Query, Connection);
Command.CommandType = CommandType.Text;
Command.Parameters.AddWithValue("@OpId", aConsultBillService.OPID);
Command.Parameters.AddWithValue("@ConsultId", aConsultBillService.ConsultId);
Command.Parameters.AddWithValue("@ConsultBillDate", aConsultBillService.ConsultBillDate);
Command.Parameters.AddWithValue("@ConFee", aConsultBillService.ConFee);
Command.Parameters.AddWithValue("@ConQty", aConsultBillService.ConQty);
Command.Parameters.AddWithValue("@VchNo", aConsultBillService.VchNo);
int count = Command.ExecuteNonQuery();
return(count);
}
public MessageModel UpdateConsultantCall(ConsultantCall aConsultantCall, ConsultBillService aConsultBillService)
{
int rowAffect = 0;
MessageModel aMessageModel = new MessageModel();
rowAffect = new ConsultantCallGatWay().UpdateConsultantCall(aConsultantCall);
if (rowAffect > 0)
{
rowAffect = new ConsultantCallGatWay().UpdateCosultBilling(aConsultBillService);
if (rowAffect > 0)
{
aMessageModel.MessageTitle = "Successful";
aMessageModel.MessageBody = "Update Successfully";
}
}
else
{
aMessageModel.MessageTitle = "Warning!";
aMessageModel.MessageBody = "Save to failed. Please try again.";
}
return(aMessageModel);
}
