private void GetPartnerShare()
{
Price = Product.Price;
if (PriceAfterBuyerFee.Equals(0))
{
PriceAfterBuyerFee = Product.Price - Product.BuyerFee;
}
if (PriceAfterAuthorFee.Equals(0))
{
PriceAfterAuthorFee = PriceAfterBuyerFee - PriceAfterBuyerFee * Product.AuthorFee;
}
if (Tax.Equals(0))
{
Tax = PriceAfterBuyerFee * Country.Tax;
}
if (ReceivedAmount.Equals(0))
{
ReceivedAmount = PriceAfterAuthorFee - Tax;
}
if (Product.PartnerShare > 0)
{
PartnerShare = ReceivedAmount * Product.PartnerShare;
ReceivedAmount = ReceivedAmount - PartnerShare;
}
}
private void btnUpdate_Click(object sender, EventArgs e)
{
ReceivedAmount rcvAmnt = new ReceivedAmount();
MessageModel aMessageModel = new MessageModel();
rcvAmnt.VoucherNo = int.Parse(txtVoucherNo.Text);
rcvAmnt.PatientId = cmbPatientId.Text;
rcvAmnt.PatientName = txtPatientName.Text;
rcvAmnt.AdmissionDate = dateVoucher.Text;
rcvAmnt.BillNo = txtBillNo.Text;
rcvAmnt.ColType = cmbColType.Text;
rcvAmnt.PayType = cmbPayType.Text;
rcvAmnt.Discount = double.Parse(txtDiscount.Text);
rcvAmnt.NetAmount = double.Parse(txtNetAmount.Text);
rcvAmnt.Remarks = txtRemarks.Text;
rcvAmnt.ReceivedBy = MainWindow.userName;
rcvAmnt.Inword = lblInward.Text;
rcvAmnt.RefferedBy = Convert.ToInt32(cmbDiscountBy.Tag);
if (rdIndoor.Checked == true)
{
rcvAmnt.Status = "InDoor";
}
else
{
rcvAmnt.Status = "OutDoor";
}
var Message = amountManager.UpdateReceivedAmount(rcvAmnt);
MetroFramework.MetroMessageBox.Show(this, Message.MessageBody, Message.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
btnRefresh.PerformClick();
}
public MessageModel SaveReceivedAmount(ReceivedAmount rcvAmnt)
{
string Message;
MessageModel aMessageModel = new MessageModel();
Message = Ischecked(rcvAmnt);
if (Message != "Checked")
{
aMessageModel.MessageBody = Message;
aMessageModel.MessageTitle = "Warning!";
return(aMessageModel);
}
int rowAffected = rcvAmntGateway.SaveReceivedAmount(rcvAmnt);
if (rowAffected > 0)
{
aMessageModel.MessageBody = "Data Saved Successfully. \n Thank You";
aMessageModel.MessageTitle = "Successful";
return(aMessageModel);
}
else
{
aMessageModel.MessageBody = "Saved to failed. Try again.";
aMessageModel.MessageTitle = "Error!";
}
return(aMessageModel);
}
public int DeleteeceivedAmount(ReceivedAmount rcvAmount)
{
Query = "DELETE FROM tblIPVoucher WHERE VoucherNo='" + rcvAmount.VoucherNo + "'";
Command = new SqlCommand(Query, Connection);
int rowAffect = Command.ExecuteNonQuery();
return(rowAffect);
}
public MessageModel DeleteeceivedAmount(ReceivedAmount rcvAmount)
{
MessageModel aMessageModel = new MessageModel();
int rowAffect = rcvAmntGateway.DeleteeceivedAmount(rcvAmount);
if (rowAffect > 0)
{
aMessageModel.MessageTitle = "Successful";
aMessageModel.MessageBody = "Data Deleted Successfully.";
}
return(aMessageModel);
}
private void btnSave_Click(object sender, EventArgs e)
{
ReceivedAmount rcvAmnt = new ReceivedAmount();
rcvAmnt.VoucherNo = int.Parse(txtVoucherNo.Text);
rcvAmnt.PatientId = cmbPatientId.Text;
rcvAmnt.PatientName = txtPatientName.Text;
rcvAmnt.AdmissionDate = dateVoucher.Text;
rcvAmnt.BillNo = txtBillNo.Text;
rcvAmnt.Inword = lblInward.Text;
rcvAmnt.ReceivedBy = MainWindow.userName;
if (cmbColType.Text == "Advance" || cmbColType.Text == "Settlement")
{
rcvAmnt.ColType = cmbColType.Text;
}
rcvAmnt.PayType = cmbPayType.Text;
rcvAmnt.Discount = double.Parse(txtDiscount.Text);
rcvAmnt.NetAmount = double.Parse(txtNetAmount.Text);
rcvAmnt.Remarks = txtRemarks.Text;
rcvAmnt.ReceivedBy = txtRecieveBy.Text;
rcvAmnt.RefferedBy = Convert.ToInt32(cmbDiscountBy.Tag);
if (rdIndoor.Checked)
{
rcvAmnt.Status = "InDoor";
}
if (rdNICU.Checked)
{
rcvAmnt.Status = "NICU";
}
if (rdOutDoor.Checked)
{
rcvAmnt.Status = "OutDoor";
}
MessageModel message = new RceivedAmountManager().SaveReceivedAmount(rcvAmnt);
if (message.MessageTitle == "Successful")
{
MetroFramework.MetroMessageBox.Show(this, message.MessageBody, message.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
PopulateGridViewBillCollection();
btnRefresh.PerformClick();
}
else
{
MetroFramework.MetroMessageBox.Show(this, message.MessageBody, message.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Warning);
}
}
private void btnDelete_Click(object sender, EventArgs e)
{
DialogResult dr = MessageBox.Show("Are you sure to delete this row?", "Confirmation Message",
MessageBoxButtons.YesNo);
if (dr == DialogResult.Yes)
{
ReceivedAmount rcvAmnt = new ReceivedAmount();
rcvAmnt.VoucherNo = Convert.ToInt32(txtVoucherNo.Text);
MessageModel aMessageModel = new MessageModel();
aMessageModel = amountManager.DeleteeceivedAmount(rcvAmnt);
if (aMessageModel.MessageTitle == "Successfull")
{
MessageBox.Show(aMessageModel.MessageBody, aMessageModel.MessageTitle, MessageBoxButtons.OK, MessageBoxIcon.Information);
Refresh();
}
}
}
public int SaveReceivedAmount(ReceivedAmount rcvAmount)
{
Command = new SqlCommand("SP_SAVE_tblIPVoucher", Connection)
{
CommandType = CommandType.StoredProcedure
};
Command.Parameters.Add("@VoucherNo", SqlDbType.Int);
Command.Parameters.Add("@PatientId", SqlDbType.VarChar, 50);
Command.Parameters.Add("@PatientName", SqlDbType.VarChar, 50);
Command.Parameters.Add("@AdmissionDate", SqlDbType.VarChar, 50);
Command.Parameters.Add("@BillNo", SqlDbType.VarChar, 50);
Command.Parameters.Add("@ColType", SqlDbType.VarChar, 50);
Command.Parameters.Add("@PayType", SqlDbType.VarChar, 50);
Command.Parameters.Add("@Discount", SqlDbType.Float, 50);
Command.Parameters.Add("@NetAmount", SqlDbType.Float);
Command.Parameters.Add("@Remarks", SqlDbType.VarChar, 50);
Command.Parameters.Add("@ReceivedBy", SqlDbType.VarChar, 50);
Command.Parameters.Add("@Status", SqlDbType.VarChar, 50);
Command.Parameters.Add("@DiscountBy", SqlDbType.Int);
Command.Parameters.Add("@Inword", SqlDbType.VarChar);
Command.Parameters[0].Value = rcvAmount.VoucherNo;
Command.Parameters[1].Value = rcvAmount.PatientId;
Command.Parameters[2].Value = rcvAmount.PatientName;
Command.Parameters[3].Value = rcvAmount.AdmissionDate;
Command.Parameters[4].Value = rcvAmount.BillNo;
Command.Parameters[5].Value = rcvAmount.ColType;
Command.Parameters[6].Value = rcvAmount.PayType;
Command.Parameters[7].Value = rcvAmount.Discount;
Command.Parameters[8].Value = rcvAmount.NetAmount;
Command.Parameters[9].Value = rcvAmount.Remarks;
Command.Parameters[10].Value = rcvAmount.ReceivedBy;
Command.Parameters[11].Value = rcvAmount.Status;
Command.Parameters[12].Value = rcvAmount.RefferedBy;
Command.Parameters[13].Value = rcvAmount.Inword;
int count = Command.ExecuteNonQuery();
return(count);
}
private string Ischecked(ReceivedAmount rcvAmnt)
{
string message = "";
if (String.IsNullOrEmpty(rcvAmnt.ColType))
{
message = "Please select collection type.\n Thank You";
}
else if (rcvAmnt.PatientId == String.Empty)
{
message = "Please select a Patient.\n Thank You";
}
else if (rcvAmnt.NetAmount == 0 || rcvAmnt.NetAmount == null)
{
message = "Please enter an amount. \n Thank You";
}
//GetValueOrDefault
else
{
message = "Checked";
}
return(message);
}
private void add_Click(object sender, EventArgs e)
{
int a = 0;
//count rows
//int rows = Orderdgv.Rows.Count;
//rows = rows - 1;
int insertid = 0;
//Count number of products from grid view
int sum = 0;
for (int i = 0; i < Orderdgv.Rows.Count; ++i)
{
sum += Convert.ToInt32(Orderdgv.Rows[i].Cells[3].Value);
}
// MessageBox.Show(sum.ToString()) ;
//Remaining amount checks
if (ReceivedAmount.Text == "")
{
if (Convert.ToInt32(TotalPrice.Text) < 0)
{
ReceivedAmount.Text = TotalPrice.Text;
ReceivedAmount.Text = "-" + ReceivedAmount.Text;
}
ReceivedAmount.Text = TotalPrice.Text;
}
//inseted bill id
int remaining = Convert.ToInt32(ReceivedAmount.Text) - Convert.ToInt32(TotalPrice.Text);
if (remaining < 0)
{
MessageBox.Show("INVALID AMOUNT RECEIVED");
}
else
{
try
{
//Add BIll details into billdb
// only add billid,qty,amount , seller name
MessageBox.Show(a.ToString());
a++;
DateTime dateTime = DateTime.Now;
Con.Open();
String query = "insert into billdb (items, amount, seller,date) values('" + sum.ToString() + "','" + TotalPrice.Text + "','"
+ Form1.SetValueForText1 + "','" + dateTime.ToShortDateString() + "'); select @@identity;";
SqlCommand cmd = new SqlCommand(query, Con);
//cmd.ExecuteNonQuery();
insertid = int.Parse(cmd.ExecuteScalar().ToString());
MessageBox.Show(insertid.ToString());
Con.Close();
}
catch (Exception ex) {
MessageBox.Show(ex.Message);
}
int check = Convert.ToInt32(TotalPrice.Text);
if (check < 0)
{
MessageBox.Show("Total Products = " + sum.ToString() + "\n" + "Total Bill = " + TotalPrice.Text + "\n" + "Customer Remaining Change = " + remaining);
}
if (check > 0)
{
//Show the change
MessageBox.Show("Total Products = " + sum.ToString() + "\n" + "Total Bill = " + TotalPrice.Text + "\n" + "Amount Recieved= " + ReceivedAmount.Text + "\n" + "Change = " + remaining);
}
int i = 0;
//MessageBox.Show("Yahan se");
//
//Insert items into table
//
for (i = 0; i < Orderdgv.Rows.Count - 1; i++)
{
try
{
Con.Open();
// MessageBox.Show("Yahse");
string StrQuery = "INSERT INTO solditems (pid,billid, pname, pprice,pqty,total) VALUES ('" + Orderdgv.Rows[i].Cells[0].Value + "', '" + insertid + "', '"
+ Orderdgv.Rows[i].Cells[1].Value + "', '" + Orderdgv.Rows[i].Cells[2].Value + "', '" + Orderdgv.Rows[i].Cells[3].Value + "', '" + Orderdgv.Rows[i].Cells[4].Value + "')";
SqlCommand cmd = new SqlCommand(StrQuery, Con);
cmd.ExecuteNonQuery();
Con.Close();
}
catch (Exception ex)
{
MessageBox.Show(ex.Message);
Con.Close();
}
}
Orderdgv.Rows.Clear();
ProQty.Clear();
ProName.Clear();
ProPrice.Clear();
TotalPrice.Clear();
ReceivedAmount.Clear();
}
}
