public DataTable InsertRecord(Objects.Recovery obj)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_RecoveryInsert";
cmd.Parameters.AddWithValue("@RecoveryDate", obj.RecoveryDate);
cmd.Parameters.AddWithValue("@SalesmanID", obj.SalesmanID);
cmd.Parameters.AddWithValue("@TotalRecovery", obj.TotalRecovery);
cmd.Parameters.AddWithValue("@UserID", obj.UserID);
cmd.Parameters.AddWithValue("@Remarks", obj.Remarks);
return(new Database(connectionstring).ExecuteForDataTable(cmd));
}
catch (Exception exc)
{
throw exc;
}
}
public void UpdateRecord(Objects.Recovery obj)
{
try
{
SqlCommand cmd = new SqlCommand();
cmd.CommandType = CommandType.StoredProcedure;
cmd.CommandText = "SP_RecoveryUpdate";
cmd.Parameters.AddWithValue("@RecoveryID", obj.RecoveryID);
cmd.Parameters.AddWithValue("@RecoveryDate", obj.RecoveryDate);
cmd.Parameters.AddWithValue("@SalesmanID", obj.SalesmanID);
cmd.Parameters.AddWithValue("@TotalRecovery", obj.TotalRecovery);
cmd.Parameters.AddWithValue("@UserID", obj.UserID);
cmd.Parameters.AddWithValue("@Remarks", obj.Remarks);
new Database(connectionstring).ExecuteNonQueryOnly(cmd);
}
catch (Exception exc)
{
throw exc;
}
}
private void btnSave_Click(object sender, EventArgs e)
{
try
{
int vSalesmanID = 0;
int.TryParse(cboSalesman.SelectedValue.ToString(), out vSalesmanID);
if (vSalesmanID == 0)
{
MessageBox.Show("Please Select Salesman", "Information Missing");
cboSalesman.Focus();
return;
}
if (Grid.Rows.Count == 0)
{
MessageBox.Show("Please Insert Recovery Customers", "Detail Missing");
txtCustomerID.Focus();
return;
}
decimal vTotal = 0;
decimal.TryParse(txtTotal.Text, out vTotal);
Objects.Recovery BAL = new Objects.Recovery();
BAL.RecoveryID = Int64.Parse(txtInvNo.Text);
BAL.RecoveryDate = dtRecoveryDate.Value;
BAL.SalesmanID = vSalesmanID;
BAL.TotalRecovery = vTotal;
BAL.Remarks = txtRemarks.Text;
BAL.UserID = vUserID;
if (vOpenMode)
{
objDAL.UpdateRecord(BAL);
objDAL.DeleteRecordBody(Int64.Parse(txtInvNo.Text));
}
else
{
DataTable dt = objDAL.InsertRecord(BAL);
BAL.RecoveryID = Int64.Parse(dt.Rows[0]["RecoveryID"].ToString());
}
//Save Detail
foreach (DataGridViewRow dr in Grid.Rows)
{
if (dr.Cells[0].Value != null)
{
Objects.RecoveryBody objBody = new Objects.RecoveryBody();
objBody.RecoveryID = BAL.RecoveryID;
objBody.CustomerID = Int64.Parse(dr.Cells["PartyID"].Value.ToString());
objBody.AmountRecoverd = decimal.Parse(dr.Cells["AmountRecoverd"].Value.ToString(), System.Globalization.NumberStyles.AllowDecimalPoint);
objBody.Remarks = string.Empty;
objDAL.InsertRecordBody(objBody);
}
}
Message.ShowMessage(MyMessages.MessageType.SaveRecord);
ClearFields();
}
catch (Exception exc)
{
Message.ShowMessage(MyMessages.MessageType.Error, exc.Message);
}
}