public void InsertRecordBody(Objects.PurReturnBody obj)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_PurReturnBodyInsert";
cmd.Parameters.AddWithValue("@PurReturnID", obj.PurReturnID);
cmd.Parameters.AddWithValue("@ProductID", obj.ProductID);
cmd.Parameters.AddWithValue("@Qty", obj.Qty);
cmd.Parameters.AddWithValue("@Price", obj.Price);
cmd.Parameters.AddWithValue("@Discount", obj.Discount);
cmd.Parameters.AddWithValue("@TotalValue", obj.TotalValue);
new Database(connectionstring).ExecuteNonQueryOnly(cmd);
}
catch (Exception exc)
{
throw exc;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
if (string.IsNullOrEmpty(txt_InvNo.Text.Trim()))
{
MessageBox.Show("Please Load a Purchase First!!!", "Information Missing");
btnOpenPur.Focus();
return;
}
bool vHasSelectedRows = false;
foreach (DataGridViewRow dr in Grid.Rows)
{
if (Convert.ToBoolean(dr.Cells["Select"].Value) == true)
{
vHasSelectedRows = true;
break;
}
}
if (!vHasSelectedRows)
{
MessageBox.Show("Please Select Products to Save..", "Detail Missing");
Grid.Focus();
return;
}
decimal vCashPaid = 0;
decimal.TryParse(txtCashPaid.Text, out vCashPaid);
Objects.PurReturn BAL = new Objects.PurReturn();
BAL.PurReturnID = Int64.Parse(txtReturnID.Text);
BAL.PurchaseID = Int64.Parse(txt_InvNo.Text);
BAL.EntryDate = dt_Entry.Value;
BAL.VendorID = int.Parse(txtVendorID.Text);
BAL.GrossValue = decimal.Parse(txt_Gross.Text, System.Globalization.NumberStyles.AllowDecimalPoint);
BAL.CashReceived = vCashPaid;
BAL.Narration = txt_Narration.Text;
BAL.UserID = vUserID;
if (vOpenMode)
{
objDAL.UpdateRecord(BAL);
objDAL.DeleteRecordBody(Int64.Parse(txtReturnID.Text));
}
else
{
BAL.PurReturnID = objDAL.getNextNo();
objDAL.InsertRecord(BAL);
}
//Save Detail
foreach (DataGridViewRow dr in Grid.Rows)
{
if (dr.Cells[0].Value != null && Convert.ToBoolean(dr.Cells["Select"].Value) == true)
{
Objects.PurReturnBody objBody = new Objects.PurReturnBody();
objBody.PurReturnID = Int64.Parse(txtReturnID.Text);
objBody.ProductID = Int32.Parse(dr.Cells["ProductID"].Value.ToString());
objBody.Qty = decimal.Parse(dr.Cells["Qty"].Value.ToString());
objBody.Price = decimal.Parse(dr.Cells["Price"].Value.ToString());
objBody.Discount = decimal.Parse(dr.Cells["Disc"].Value.ToString());
objBody.TotalValue = decimal.Parse(dr.Cells["TotalValue"].Value.ToString());
objDAL.InsertRecordBody(objBody);
}
}
MessageBox.Show("Record Saved Successfully.", "Task Completed");
SetMode(false);
}
catch (Exception exc)
{
MessageBox.Show(exc.Message.ToString(), "Error");
}
}
