private void fnClear()
{
txt_BillNo.Text = "";
txt_EmailAddress.Text = "";
txt_MobilNo.Text = "";
txt_Name.Text = "";
txt_OrderNo.Text = "";
txt_PrdNm.Text = "";
txt_Qty.Text = "";
txt_Rate.Text = "";
txt_Value.Text = "";
txt_Remarks.Text = "";
Chk_Delivered.Checked = false;
txt_Address.Text = "";
lbl_Gst.Text = "0.00";
lbl_RoundOff.Text = "0.00";
lbl_Taxable.Text = "0.00";
//lbl_Advance.Text = "Advance Received : 0.00";
lbl_Total.Text = "0.00";
txt_Discount.Text = "0.00";
dat_BillDate.Text = DateTime.Now.ToString(); //.ToString("dd/MM/yyyy");
dat_ProofDate.Text = DateTime.Now.AddDays(1).ToString(); // DateTime.Now.ToString("dd/MM/yyyy");
dat_DeliveryDate.Text = DateTime.Now.AddDays(7).ToString(); //.ToString("dd/MM/yyyy");
dat_DeliveredDate.Text = DateTime.Now.ToString();
paymnt = new PaymentDetails();
fnGetBilNo();
OrderDtls_DS.Clear();
_RefKey = 0;
isOrderClosed = false;
lbl_Balance.Visible = false;
}
private void metroButton2_Click(object sender, EventArgs e)
{
this.paymentDetails = null;
this.Close();
}
private void fnGetData()
{
DataSet HdrXML = new DataSet();
OleDbCommand OledbCmd = new OleDbCommand();
OleDbDataAdapter OledbAdp = new OleDbDataAdapter();
try
{
OledbCmd.Connection = CommonClass.fnGetConnection();
OledbCmd.CommandTimeout = 0;
OledbCmd.CommandType = CommandType.StoredProcedure;
OledbCmd.CommandText = "PrcBillSystem";
OledbCmd.Parameters.Add("@Action", "S");
OledbCmd.Parameters.Add("@HdrXML", DBNull.Value);
OledbCmd.Parameters.Add("@GrdXML", DBNull.Value);
OledbCmd.Parameters.Add("@DocPk", _RefKey);
OledbAdp.SelectCommand = OledbCmd;
OledbAdp.Fill(HdrXML);
int docRef = _RefKey;
fnClear();
_RefKey = docRef;
txt_BillNo.Text = HdrXML.Tables[0].Rows[0]["InvBilNo"].ToString();
txt_EmailAddress.Text = HdrXML.Tables[0].Rows[0]["InvEmailId"].ToString();
txt_MobilNo.Text = HdrXML.Tables[0].Rows[0]["InvMobNo"].ToString();
txt_Name.Text = HdrXML.Tables[0].Rows[0]["InvCusNm"].ToString();
txt_OrderNo.Text = HdrXML.Tables[0].Rows[0]["InvOrdNo"].ToString();
txt_Remarks.Text = HdrXML.Tables[0].Rows[0]["InvRmks"].ToString();
txt_Address.Text = HdrXML.Tables[0].Rows[0]["Add"].ToString();
lbl_Gst.Text = HdrXML.Tables[0].Rows[0]["InvVAT"].ToString();
txt_Discount.Text = HdrXML.Tables[0].Rows[0]["Dis"].ToString();
lbl_RoundOff.Text = HdrXML.Tables[0].Rows[0]["Rnd"].ToString();
lbl_Taxable.Text = HdrXML.Tables[0].Rows[0]["InvGross"].ToString();
lbl_Total.Text = HdrXML.Tables[0].Rows[0]["InvNett"].ToString();
dat_ProofDate.Text = HdrXML.Tables[0].Rows[0]["InvProfDt"].ToString();
dat_BillDate.Text = HdrXML.Tables[0].Rows[0]["InvBilDt"].ToString();
dat_DeliveryDate.Text = HdrXML.Tables[0].Rows[0]["InvDelDt"].ToString();
dat_DeliveredDate.Text = HdrXML.Tables[0].Rows[0]["DelyDt"].ToString();
isOrderClosed = Convert.ToBoolean(HdrXML.Tables[0].Rows[0]["DelySt"]);
if (isOrderClosed == true)
{
Chk_Delivered.Checked = true;
}
else
{
Chk_Delivered.Checked = false;
}
lbl_Balance.Text = string.Format("Balance Amount : {0}", HdrXML.Tables[0].Rows[0]["Bal"].ToString());
lbl_Balance.Visible = true;
paymnt = new PaymentDetails();
paymnt.AmountPaid = Convert.ToDecimal(HdrXML.Tables[0].Rows[0]["InvAmntRcvd"].ToString());
//txt_Bal.Text = HdrXML.Tables[0].Rows[0]["Bal"].ToString();
foreach (DataRow dRow in HdrXML.Tables[1].Rows)
{
OrderDtls_DS.Tables[0].ImportRow(dRow);
}
dataGridView1.DataSource = OrderDtls_DS.Tables[0].DefaultView;
dataGridView1.Refresh();
}
catch { }
finally
{
HdrXML.Dispose(); HdrXML = null; OledbCmd.Dispose(); OledbCmd = null;
OledbAdp.Dispose(); OledbAdp = null;
}
}
private void btn_Save_Click(object sender, EventArgs e)
{
String ErrMsg = "";
if (txt_Name.Text == "")
{
ErrMsg = ErrMsg + "Customer Name Cannot be Empty. \n";
}
if (txt_MobilNo.Text == "")
{
ErrMsg = ErrMsg + "Mobile No Cannot be Empty. \n";
}
if (txt_BillNo.Text == "")
{
ErrMsg = ErrMsg + "Bill No Cannot be Empty. \n";
}
if (OrderDtls_DS.Tables[0].Rows.Count == 0)
{
ErrMsg = ErrMsg + "Product Details Cannot be Empty. \n";
}
if (isOrderClosed && _RefKey != 0)
{
ErrMsg = ErrMsg + "Cannot update the deliverd orders, Contact Administrator. \n";
}
if (!string.IsNullOrEmpty(ErrMsg))
{
MetroMessageBox.Show(this, ErrMsg, "Error - Billing System");
return;
}
frmReceiveAmount frm = new frmReceiveAmount();
if (paymnt == null)
{
paymnt = new PaymentDetails();
}
paymnt.AmountReceived = 0;
paymnt.TotalAmount = string.IsNullOrEmpty(lbl_Total.Text) ? 0 : Convert.ToDecimal(lbl_Total.Text);
frm.paymentDetails = paymnt;
frm.ShowDialog();
if (frm == null || frm.paymentDetails == null)
{
return;
}
paymnt = frm.paymentDetails;
DataSet HdrXML = new DataSet();
OleDbCommand OledbCmd = new OleDbCommand();
try
{
HdrXML.Tables.Add();
HdrXML.Tables.Add(new DataTable());
HdrXML.Tables[0].Columns.Add("CusNm", typeof(string));
HdrXML.Tables[0].Columns.Add("MobNo", typeof(string));
HdrXML.Tables[0].Columns.Add("EmailId", typeof(string));
HdrXML.Tables[0].Columns.Add("OrdNo", typeof(string));
HdrXML.Tables[0].Columns.Add("ProfDt", typeof(string));
HdrXML.Tables[0].Columns.Add("DelDt", typeof(string));
HdrXML.Tables[0].Columns.Add("BilNo", typeof(string));
HdrXML.Tables[0].Columns.Add("BilDt", typeof(string));
HdrXML.Tables[0].Columns.Add("Rmks", typeof(string));
HdrXML.Tables[0].Columns.Add("AmntRcvd", typeof(decimal));
HdrXML.Tables[0].Columns.Add("DelySts", typeof(int));
HdrXML.Tables[0].Columns.Add("DelyDt", typeof(string));
HdrXML.Tables[0].Columns.Add("Add", typeof(string));
HdrXML.Tables[0].Columns.Add("Dis", typeof(decimal));
HdrXML.Tables[0].Columns.Add("CGST", typeof(decimal));
HdrXML.Tables[0].Columns.Add("SGST", typeof(decimal));
HdrXML.Tables[0].Columns.Add("Rnd", typeof(decimal));
HdrXML.Tables[0].Columns.Add("CashAmnt", typeof(decimal));
HdrXML.Tables[0].Columns.Add("CardAmnt", typeof(decimal));
HdrXML.Tables[0].Columns.Add("Transfer", typeof(decimal));
HdrXML.Tables[0].Columns.Add("WriteOff", typeof(decimal));
//txt_AmtRcvd
String CusNm = "", MobNo = "", EmailId = "", OrdNo = "", ProfDt = "", DelDt = "", BilNo = "", BilDt = "", Rmks = "", DelyDt = "", Address = "";
decimal AmntRcvd = 0, Discount = 0, CGST = 0, SGST = 0, Rnd = 0, CashAmnt = 0, CardAmnt = 0, Transfer = 0, WriteOff = 0;
int DelySts = 0;
CusNm = txt_Name.Text;
MobNo = txt_MobilNo.Text;
EmailId = txt_EmailAddress.Text;
OrdNo = txt_OrderNo.Text;
BilNo = txt_BillNo.Text;
Rmks = txt_Remarks.Text;
ProfDt = dat_ProofDate.Text;
DelDt = dat_DeliveryDate.Text;
BilDt = dat_BillDate.Text;
DelyDt = dat_DeliveredDate.Text;
Address = txt_Address.Text;
DelySts = (Chk_Delivered.Checked == true ? 1 : 0);
CashAmnt = paymnt.Cash;
CardAmnt = paymnt.Card;
Transfer = paymnt.NetTransfer;
WriteOff = paymnt.WriteOff;
AmntRcvd = paymnt.AmountReceived;
Discount = string.IsNullOrEmpty(txt_Discount.Text) ? 0 : Math.Round(Convert.ToDecimal(txt_Discount.Text), 2);
Rnd = string.IsNullOrEmpty(lbl_RoundOff.Text) ? 0 : Math.Round(Convert.ToDecimal(lbl_RoundOff.Text), 2);
CGST = Convert.ToDecimal(OrderDtls_DS.Tables[0].AsEnumerable().Sum(row => Convert.ToDecimal(row["CGST"])));
SGST = Convert.ToDecimal(OrderDtls_DS.Tables[0].AsEnumerable().Sum(row => Convert.ToDecimal(row["SGST"])));
if (DelySts == 1 && paymnt.Balance > 0)
{
MetroMessageBox.Show(this, "Delivered Order Needs to pay the full amount", "Error - Billing System");
return;
}
// Header Details
if (HdrXML != null)
{
HdrXML.Tables[0].Rows.Add(CusNm, MobNo, EmailId, OrdNo, ProfDt, DelDt, BilNo, BilDt, Rmks, AmntRcvd, DelySts, DelyDt, Address, Discount, CGST, SGST, Rnd, CashAmnt, CardAmnt, Transfer, WriteOff);
}
foreach (DataColumn dCol in HdrXML.Tables[0].Columns)
{
dCol.ColumnMapping = MappingType.Attribute;
}
// GridDetails
foreach (DataColumn dCol in OrderDtls_DS.Tables[0].Columns)
{
dCol.ColumnMapping = MappingType.Attribute;
}
OledbCmd.Connection = CommonClass.fnGetConnection();
OledbCmd.CommandTimeout = 0;
OledbCmd.CommandType = CommandType.StoredProcedure;
OledbCmd.CommandText = "PrcBillSystem";
if (_RefKey == 0)
{
OledbCmd.Parameters.Add("@Action", "A");
}
else
{
OledbCmd.Parameters.Add("@Action", "E");
}
OledbCmd.Parameters.Add("@HdrXML", HdrXML.GetXml());
OledbCmd.Parameters.Add("@GrdXML", OrderDtls_DS.GetXml());
OledbCmd.Parameters.Add("@DocPk", _RefKey);
_RefKey = Convert.ToInt32(OledbCmd.ExecuteScalar());
if (MetroMessageBox.Show(this, "Saved Sucessfully, You want to generate Invoice Print", "Billing System", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
fnPrint();
}
fnClear();
_RefKey = 0;
}
catch (Exception E)
{
MetroMessageBox.Show(this, E.Message, "Error - Billing System");
}
finally
{
HdrXML.Dispose(); HdrXML = null; OledbCmd.Dispose(); OledbCmd = null;
}
}
