protected void btn_Save_Click(object sender, EventArgs e)
{
lblSaveFlag.Text = "Save";
if (lblEdit.Text == "Edit")
{
KycFormSave();
lblAutoExtend.Text = "";
return;
}
else
{
OtherBAL ObjBal = new OtherBAL();
DataSet ds = ObjBal.Idv_Chetana_Get_KycForm_GetMasterCust(txtCustCode.Text, Convert.ToInt32(Session["FY"]), "ChkCode");
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
ModalPopupExtenderNew.Show();
return;
}
else
{
KycFormSave();
lblAutoExtend.Text = "";
}
}
}
protected void btn_PrintSave_Click(object sender, EventArgs e)
{
lblSaveFlag.Text = "SavePrint";
if (lblEdit.Text == "Edit")
{
KycFormSave();
Page.ClientScript.RegisterStartupScript(
this.GetType(), "OpenWindow", "window.open('KycFormReport.aspx?KycNo=" + lblAutoExtend.Text + "');", true);
lblAutoExtend.Text = "";
return;
}
else
{
OtherBAL ObjBal = new OtherBAL();
DataSet ds = ObjBal.Idv_Chetana_Get_KycForm_GetMasterCust(txtCustCode.Text, Convert.ToInt32(Session["FY"]), "ChkCode");
DataTable dt = ds.Tables[0];
if (dt.Rows.Count > 0)
{
ModalPopupExtenderNew.Show();
return;
}
else
{
KycFormSave();
Page.ClientScript.RegisterStartupScript(
this.GetType(), "OpenWindow", "window.open('KycFormReport.aspx?KycNo=" + KycMax.ToString() + "');", true);
lblAutoExtend.Text = "";
}
}
}
private void BindReport()
{
//if (rdbAll.Checked == true)
//{
// All = "All".ToString();
// DDLSuperZone.SelectedValue = "0";
// DDLZone.SelectedValue = "0";
//}
//else if (rdbAmount.Checked == true)
//{
// Amount = Convert.ToInt32(txtAmount.Text == "" ? "0" : txtAmount.Text);
// DDLSuperZone.SelectedValue = "0";
// DDLZone.SelectedValue = "0";
//}
DataSet ds = OtherBAL.Idv_Chetana_PANReport(Convert.ToInt32(DDLSuperZone.SelectedValue.ToString()), Convert.ToInt32(DDLZone.SelectedValue.ToString()), Convert.ToInt32(Session["FY"]), "", "", "", "");
if (ds.Tables[0].Rows.Count > 0)
{
ReportDocument rd = new ReportDocument();
rd.Load(Server.MapPath("~/Report/PANReport.rpt"));
rd.SetDataSource(ds.Tables[0]);
//rd.SetParameterValue("SuperZoneName", DDLSuperZone.SelectedValue.ToString() == "0" ? "-" : DDLSuperZone.SelectedItem.Text);
//rd.SetParameterValue("ZoneName", DDLZone.SelectedValue.ToString() == "0" ? "-" : DDLZone.SelectedItem.Text);
CrystalPanReport.ReportSource = rd;
}
else
{
MessageBox("No record found");
DDLSuperZone.Focus();
return;
}
}
private void GetInvoice()
{
StringBuilder objste = new StringBuilder("-");
try
{
DataSet dsMailParams = OtherNewClass.AutoMail.AutoMailParams("customerinv", "", "", "", "", "", "", "", "");
DataTable dtmaildesc = dsMailParams.Tables[0];
DataSet ds = OtherBAL.GetInvoiceLog("System", "", "", "");
DataTable dt = ds.Tables[0];
DoLog(objste, "Get Mail setting Count >> " + dt.Rows.Count.ToString());
//DataTable dtmaildesc = ds.Tables[2];
string FirstPath = string.Empty;
string SecondPath = string.Empty;
DoLog(objste, "Generating 1 File");
FirstPath = "../AutoEmailAttachment/AutoInvoice/" + DateTime.Now.ToString("MM_dd_yyyy_HH_MM") + "/";
SecondPath = "";
DirectoryManagement(FirstPath);
DoLog(objste, "Main Dataset >> ");
Response.Write(generatefiles(ds, FirstPath, dtmaildesc));
DoLog(objste, "Wrote Data >> ");
}
catch (Exception ex)
{
Response.Write("Error >> " + DoLog(objste, "Error >> " + ex.Message).ToString());
} Response.End();
}
private void ChekedData()
{
Session["TokenPendingReport"] = null;
Other_Z.OtherBAL ObjBAL = new OtherBAL();
OtherBAL.Token_Register_Property ObjProperty = new OtherBAL.Token_Register_Property();
int tokenid;
Session["TokenPendingReport"] = null;
ObjProperty.R1 = "UpdateTransaction";
ObjProperty.createdBy = Session["UserName"].ToString();
ObjProperty.FY = Convert.ToInt32(Session["FY"]);
string TokenNo = "";
StringBuilder sb = new StringBuilder("<r>");
StringBuilder sb1 = new StringBuilder();
try
{
foreach (RepeaterItem i in Rptrpending.Items)
{
CheckBox chk = (CheckBox)i.FindControl("chkRepeater");
if (chk.Checked == true)
{
sb.Append("<i>");
TokenNo = Convert.ToInt32(((CheckBox)chk.Parent.FindControl("chkRepeater")).Text).ToString();
sb.Append("<x>" + TokenNo + "</x>");
sb.Append("</i>");
sb1.Append(TokenNo + ",");
}
}
sb.Append("</r>");
if (TokenNo == "")
{
MessageBox("Please Checked The Record");
return;
}
ObjProperty.R2 = sb.ToString();
ObjBAL.Idv_Chetana_Save_Token_Register(ObjProperty, out tokenid);
//DataTable dt = FillGridView("TokenTransferReport", sb1.ToString());
//Session["TokenPendingReport"] = dt;
Rptrpending.DataSource = FillGridView("TokenPending", "");
Rptrpending.DataBind();
DataTable dt = DataPrint("print", sb1.ToString());
Session["TokenPendingReport"] = dt;
bindreport(dt);
//Page.ClientScript.RegisterStartupScript(
//this.GetType(), "OpenWindow", "window.open('Token_Register_Report.aspx');", true);
}
catch
{
throw;
}
}
private DataTable updateGrid(string R3)
{
string Id = "";
string R1 = "";
string R2 = "";
string PrintId = "";
string strTemp = "";
string FromDate = DateTime.Now.ToString("MM/dd/yyyy");
string ToDate = DateTime.Now.ToString("MM/dd/yyyy");
int TokenKyc = 0;
int FY = Convert.ToInt32(Session["FY"]);
Other_Z.OtherBAL ObjBAL = new OtherBAL();
DataTable dtgrid = new DataTable();
if (rbtnToken.Checked)
{
TokenKyc = Convert.ToInt32(txtTokenFind.Text.Trim());
strTemp = "TokenNo";
}
else if (rbtnKyc.Checked)
{
TokenKyc = Convert.ToInt32(txtKycFind.Text.Trim());
strTemp = "KycNo";
}
else if (rbtDatewise.Checked)
{
FromDate = txtFromDate.Text.Split('/')[1] + "/" + txtFromDate.Text.Split('/')[0] + "/" + txtFromDate.Text.Split('/')[2];
ToDate = txtToDate.Text.Split('/')[1] + "/" + txtToDate.Text.Split('/')[0] + "/" + txtToDate.Text.Split('/')[2];
}
DataSet ds = ObjBAL.Idv_Chetana_Get_Token_Register(Id, R1, R2, R3, FY, TokenKyc, PrintId,
rbtDatewise.Checked == true ? Convert.ToDateTime(FromDate):Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy")),
rbtDatewise.Checked == true ? Convert.ToDateTime(ToDate): Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy")));
dtgrid = ds.Tables[0];
if (dtgrid.Rows.Count == 0)
{
if (rbtDatewise.Checked)
{
MessageBox("Record Not Found ");
txtFromDate.Focus();
}
else if (rbtnKyc.Checked)
{
MessageBox("Record Not Found ");
txtKycFind.Focus();
}
else if (rbtnToken.Checked)
{
MessageBox("Record Not Found ");
txtTokenFind.Focus();
}
}
return(dtgrid);
}
private bool CheckedCustomerExists()
{
bool flage = false;
Other_Z.OtherBAL ObjBAL = new OtherBAL();
string CustCode = txtCustomerName.Text.Split(':')[0].ToString().Trim();
if (CustCode != "")
{
DataSet ds = ObjBAL.Token_Register_Validation(CustCode, Convert.ToInt32(txtKycNo.Text == "" ? 0 : Convert.ToInt32(txtKycNo.Text)), Convert.ToInt32(strFY), "", "");
if (ds.Tables[0].Rows[0][0].ToString() == "BlackList")
{
MessageBox("This customer is in black list");
txtCustomerName.Focus();
flage = false;
return(flage);
}
if (ds.Tables[0].Rows[0][0].ToString() == "Kyc no not match this Customer")
{
MessageBox("Kyc no not match this Customer");
txtCustomerName.Focus();
flage = false;
return(flage);
}
if (ds.Tables[0].Rows[0][0].ToString() == "Kyc No is mandatory")
{
MessageBox("Kyc No is mandatory");
txtKycNo.Focus();
flage = false;
return(flage);
}
else if (ds.Tables[0].Rows[0][0].ToString() == "Invalid Kyc no")
{
MessageBox("Invalid Kyc no");
txtKycNo.Focus();
txtKycNo.Text = "";
flage = false;
return(flage);
}
else if (ds.Tables[0].Rows[0][0].ToString() == "Invalid Customer")
{
MessageBox("Invalid Customer");
txtCustomerName.Focus();
txtCustomerName.Text = "";
flage = false;
return(flage);
}
else
{
flage = true;
}
}
return(flage);
}
private void PrintData()
{
string Fromdate = txtFromDate.Text.Split('/')[1] + "/" + txtFromDate.Text.Split('/')[0] + "/" + txtFromDate.Text.Split('/')[2];
string Todate = txtToDate.Text.Split('/')[1] + "/" + txtToDate.Text.Split('/')[0] + "/" + txtToDate.Text.Split('/')[2];
ReportDocument rd = new ReportDocument();
if (rbtSalesman.Checked == true)
{
if (txtMRCode.Text != "")
{
DataTable dt = OtherBAL.ReportSpecimanLedger(txtMRCode.Text.Split(':')[0].ToString(), Convert.ToInt32(strFY), "", Fromdate, Todate, chk_AmountWise.Checked == true ? "1" : "0", "").Tables[0];
if (dt.Rows.Count > 0)
{
SalesmanLedger.Visible = true;
rd.Load(Server.MapPath("~/Report/SpecimanLedger.rpt"));
rd.SetDataSource(dt);
if (chk_AmountWise.Checked == true)
{
rd.SetParameterValue("Header", "Amount Wise Ledger");
rd.SetParameterValue("Qty", "Order Amt");
rd.SetParameterValue("InvQty", "Inv Amt");
rd.SetParameterValue("CNQty", "CN Amt");
rd.SetParameterValue("Total", "Speciman Sold");
}
else
{
rd.SetParameterValue("Header", "Salesman Ledger");
rd.SetParameterValue("Qty", "Ord. Qty");
rd.SetParameterValue("InvQty", "Inv. Qty");
rd.SetParameterValue("CNQty", "CN Qty");
rd.SetParameterValue("Total", "Total Speciman");
}
rd.SetParameterValue("Saleman", txtMRCode.Text.Split(':')[2]);
rd.SetParameterValue("SalemanText", "Saleman Name");
rd.SetParameterValue("Fromdate", Fromdate);
rd.SetParameterValue("Todate", Todate);
SalesmanLedger.ReportSource = rd;
}
else
{
MessageBox("Record Not Found");
txtMRCode.Focus();
return;
}
}
}
else
{
MessageBox("BookSet Wise is in progress");
rd = null;
return;
//Amount Wise
}
}
private DataTable updateGridWithCustName(string R3)
{
string Id = "";
string R1 = txtCustomerName.Text;
string R2 = "";
int FY = Convert.ToInt32(Session["FY"]);
Other_Z.OtherBAL ObjBAL = new OtherBAL();
DataTable dtgrid = new DataTable();
DataSet ds = ObjBAL.Idv_Chetana_Get_Token_Register(Id, R1, R2, R3, FY, 0, "", DateTime.Now, DateTime.Now);
dtgrid = ds.Tables[0];
return(dtgrid);
}
public void KycFormPrintDocument()
{
if (Request.QueryString["KycNo"] != null)
{
int KycNo = Convert.ToInt32(Request.QueryString["KycNo"].ToString());
Other_Z.OtherBAL ObjBAL = new OtherBAL();
string strFy = Session["FY"].ToString();
DataSet ds = ObjBAL.Idv_Chetana_Report_KycForm(KycNo, Convert.ToInt32(strFy), "kycprint");
ReportDocument rd = new ReportDocument();
rd.Load(Server.MapPath("~/Report/KycForm.rpt"));
rd.SetDataSource(ds.Tables[0]);
KycFormReportDoc.ReportSource = rd;
}
}
protected void btnDelete_Click(object sender, EventArgs e)
{
OtherBAL.KycForm_Property ObjProperty = new OtherBAL.KycForm_Property();
OtherBAL ObjBal = new OtherBAL();
int KycId, KycMax;
ObjProperty.R1 = "Del";
ObjProperty.KycNo = Convert.ToInt32(lblKycId.Text);
ObjBal.Idv_Chetana_Save_KycForm(ObjProperty, out KycId, out KycMax);
Message("Record Delete successfully Kyc Form No is " + KycId.ToString());
lblAutoExtend.Text = "";
btnDelete.Visible = false;
Clear();
}
public DataTable DataPrint(string R3, string PrintId)
{
string Id = "";
string R1 = "";
string R2 = "";
int TokenKyc = 0;
int FY = Convert.ToInt32(Session["FY"]);
Other_Z.OtherBAL ObjBAL = new OtherBAL();
DataTable dtgrid = new DataTable();
DataSet ds = ObjBAL.Idv_Chetana_Get_Token_Register(Id, R1, R2, R3, FY, TokenKyc, PrintId, Convert.ToDateTime(null),
Convert.ToDateTime(null));
return(dtgrid = ds.Tables[0]);
}
private void PrintData()
{
if (Request.QueryString["SpecNo"] != "0")
{
int FY = Convert.ToInt32(Session["FY"].ToString());
if (FY != 0)
{
OtherBAL ObjBAL = new OtherBAL();
DataSet ds = ObjBAL.Idv_Chetana_Get_Godown_Speciman_Head(Convert.ToInt32(Request.QueryString["SpecNo"].ToString()), FY, "SpecimanPrint");
ReportDocument rd = new ReportDocument();
rd.Load(Server.MapPath("~/Report/GetPassOutSpecimen.rpt"));
rd.SetDataSource(ds.Tables[0]);
GetPassSpecimen.ReportSource = rd;
}
}
}
protected void txtCustCode_TextChanged(object sender, EventArgs e)
{
OtherBAL ObjBal = new OtherBAL();
string CustCode = txtCustCode.Text.ToString().Split(':')[0].Trim() + "!" + Session["UserName"].ToString();
DataSet ds = ObjBal.Idv_Chetana_Get_KycForm_CusCode(CustCode, Convert.ToInt32(Session["FY"]), "");
DataTable dt = ds.Tables[1];
if (dt.Rows.Count > 0)
{
Clear();
if (ds.Tables[1].Columns.Contains("BlackList"))
{
Message("This customer is in black list");
txtCustCode.Text = CustCode.Split('!')[0].Trim();
return;
}
else
{
txtCustCode.Text = CustCode.Split('!')[0].Trim();
txtCustName.Text = dt.Rows[0]["CustName"].ToString();
txtCustAdd.Text = dt.Rows[0]["Address"].ToString();
txtArea.Text = dt.Rows[0]["AreaCode"].ToString();
txtCity.Text = dt.Rows[0]["cityname"].ToString();
txtZipCode.Text = dt.Rows[0]["Zip"].ToString();
txtZoneCode.Text = dt.Rows[0]["ZoneCode"].ToString();
lblZoneCode.Text = dt.Rows[0]["ZoneName"].ToString();
txtTelephone.Text = dt.Rows[0]["telephone_exel"].ToString();
txtMobile.Text = dt.Rows[0]["Phone1"].ToString();
lblOS.Text = dt.Rows[0]["OutStanding"].ToString();
lblAvg.Text = dt.Rows[0]["TotalAvg"].ToString();
txtDelAdd.Text = dt.Rows[0]["Address"].ToString();
lblprvyeardisc.Text = dt.Rows[0]["prevdiscount"].ToString();
lblpreyeartitles.Text = dt.Rows[0]["Titles"].ToString();
txtCustName.Focus();
}
}
else
{
Clear();
}
}
private DataTable FillGridView(string R3, string PrintId)
{
string Id = "";
string R1 = "";
string R2 = "";
string strTemp = "";
string FromDate = DateTime.Now.ToString("MM/dd/yyyy");
string ToDate = DateTime.Now.ToString("MM/dd/yyyy");
int TokenKyc = 0;
int FY = Convert.ToInt32(Session["FY"]);
Other_Z.OtherBAL ObjBAL = new OtherBAL();
DataTable dt = new DataTable();
DataSet ds = ObjBAL.Idv_Chetana_Get_Token_Register(Id, R1, R2, R3, FY, TokenKyc, PrintId,
R3 == strTemp ? Convert.ToDateTime(FromDate) : Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy")),
R3 == strTemp ? Convert.ToDateTime(ToDate) : Convert.ToDateTime(DateTime.Now.ToString("MM/dd/yyyy")));
dt = ds.Tables[0];
return(dt);
}
private DataTable FillGridData(string R3, string PrintId)
{
string Id = "";
string R1 = "";
string R2 = "";
int TokenKyc = 0;
int FY = Convert.ToInt32(Session["FY"]);
Other_Z.OtherBAL ObjBAL = new OtherBAL();
DataTable dtgrid = new DataTable();
string FromDate = txtFromDate.Text.Split('/')[1] + "/" + txtFromDate.Text.Split('/')[0] + "/" + txtFromDate.Text.Split('/')[2];
string ToDate = txtToDate.Text.Split('/')[1] + "/" + txtToDate.Text.Split('/')[0] + "/" + txtToDate.Text.Split('/')[2];
DataSet ds = ObjBAL.Idv_Chetana_Get_Token_Register(Id, R1, R2, R3, FY, TokenKyc, PrintId,
Convert.ToDateTime(FromDate),
Convert.ToDateTime(ToDate)
);
dtgrid = ds.Tables[0];
return(dtgrid);
}
protected void btnRemove_Click(object sender, ImageClickEventArgs e)
{
#region Delete Data
Other_Z.OtherBAL ObjBAL = new OtherBAL();
int TokenId = 0;
OtherBAL.Token_Register_Property ObjProperty = new OtherBAL.Token_Register_Property();
ImageButton btn = ((ImageButton)sender);
ObjProperty.TokenNo = Convert.ToInt32(((Label)btn.Parent.FindControl("lblTokenId")).Text);
ObjProperty.FY = Convert.ToInt32(Session["FY"]);
ObjProperty.createdBy = Session["UserName"].ToString();
ObjProperty.R1 = "del";
ObjBAL.Idv_Chetana_Save_Token_Register(ObjProperty, out TokenId);
if (TokenId == Convert.ToInt32("-1"))
{
MessageBox("Transaction exists in dc master");
txtCustomerName.Focus();
return;
}
else
{
DataTable dt = GetSessionDataTable();
if (dt != null)
{
bool isedit = false;
DataRow[] rows = dt.Select("TokenNo=" + TokenId);
DataRow dr = null;
if (rows.Length > 0)
{
dr = rows[0];
dr.Delete();
BindGridWithSession();
Clear();
}
}
}
#endregion
}
private void Print()
{
string FromDate = DateTime.Now.ToString("MM/dd/yyyy");
string ToDate = DateTime.Now.ToString("MM/dd/yyyy");
FromDate = txtFromDate.Text.Split('/')[1] + "/" + txtFromDate.Text.Split('/')[0] + "/" + txtFromDate.Text.Split('/')[2].ToString();
ToDate = txttoDate.Text.Split('/')[1] + "/" + txttoDate.Text.Split('/')[0] + "/" + txttoDate.Text.Split('/')[2].ToString();
DataSet ds = OtherBAL.GetDebitVsCreditReport(txtcustomerid.Text.Split(':')[0].ToString(), Convert.ToDateTime(FromDate), Convert.ToDateTime(ToDate), Convert.ToInt32(Session["FY"]), "", "");
if (ds.Tables[0].Rows.Count > 0)
{
ReportDocument rd = new ReportDocument();
rd.Load(Server.MapPath("~/Report/DebitVsCredit.rpt"));
rd.SetDataSource(ds.Tables[0]);
DebitCredit.ReportSource = rd;
}
else
{
MessageBox("Record not found");
txtcustomerid.Focus();
return;
}
}
protected void btn_CashEntry(object sender, EventArgs e)
{
Other_Z.OtherBAL ObjDal = new OtherBAL();
DataSet ds = ObjDal.idv_Chetana_Get_Bank_Cash_Entries(txtbankcode.Text, Convert.ToInt32(ddlMonth.SelectedValue.ToString()), Convert.ToInt32(Session["FY"]), Convert.ToDecimal("0.0"), "", "", "", "");
if (ds.Tables[0].Rows.Count > 0)
{
DataView d = new DataView(ds.Tables[0]);
d.RowFilter = "DebitAmount > 0";
d.Sort = "Party ASC";
if (d.ToTable().Rows.Count > 0)
{
PanelPopup.Visible = true;
grdPopup.DataSource = null;
grdPopup.DataSource = d.ToTable();
grdPopup.DataBind();
}
}
else
{
MessageBox("Cash entry not found");
}
}
protected void btnAdd_Click(object sender, EventArgs e)
{
bool flage1 = true;
flage1 = DateValidation();
if (flage1 == false)
{
return;
}
#region Insert Update Click Add Button
bool flage = true;
flage = CheckedCustomerExists();
if (flage == false)
{
return;
}
if (Convert.ToBoolean(Session["GetDataValidation"]) == true)
{
Session["TokenRegsterDataTable"] = null;
}
if (Session["UserName"] != null)
{
string OrderDate = DateTime.Now.ToString("MM/dd/yyyy");
string DeliveryDate = DateTime.Now.ToString("MM/dd/yyyy");
OrderDate = txtOrderDate.Text.Split('/')[1] + "/" + txtOrderDate.Text.Split('/')[0] + "/" + txtOrderDate.Text.Split('/')[2];
DeliveryDate = txtDeliveryDate.Text.Split('/')[1] + "/" + txtDeliveryDate.Text.Split('/')[0] + "/" + txtDeliveryDate.Text.Split('/')[2];
Other_Z.OtherBAL ObjBAL = new OtherBAL();
OtherBAL.Token_Register_Property ObjProperty = new OtherBAL.Token_Register_Property();
ObjProperty.TokenNo = Convert.ToInt32(lblTokenNo.Text.Trim());
ObjProperty.KYC_No = txtKycNo.Text.Trim() == "" ? "0" : txtKycNo.Text.Trim();
ObjProperty.CustCode = txtCustomerName.Text.Trim();
ObjProperty.DeliveryDate = Convert.ToDateTime(DeliveryDate);
ObjProperty.ReceivedVia = ddlReceived.Text.Trim();
ObjProperty.HandOver = txtHandedOverTo.Text.Trim();
ObjProperty.Ord_Rec_Date = Convert.ToDateTime(OrderDate);
ObjProperty.Remark = txtRemark.Text.Trim();
ObjProperty.createdBy = Session["UserName"].ToString();
ObjProperty.FY = Convert.ToInt32(Session["FY"]);
ObjProperty.R1 = "";
ObjProperty.R2 = "";
ObjProperty.R3 = "";
int tokenid;
ObjBAL.Idv_Chetana_Save_Token_Register(ObjProperty, out tokenid);
MessageBox("Record save successfully Token No is " + tokenid.ToString());
DataTable CustNamedt = updateGrid("CustName");
DataTable dt = GetSessionDataTable();
if (dt != null)
{
bool isedit = false;
DataRow[] rows = dt.Select("TokenNo=" + tokenid);
DataRow dr = null;
if (rows.Length > 0)
{
dr = rows[0];
isedit = true;
Session["GetDataValidation"] = false;
}
else
{
dr = dt.NewRow();
}
dr["TokenNo"] = tokenid;
dr["KYC_No"] = ObjProperty.KYC_No == "0" ? "" : ObjProperty.KYC_No;
dr["Ord_Rec_Date"] = ObjProperty.Ord_Rec_Date.ToString("dd/MM/yyyy");
dr["CustCode"] = ObjProperty.CustCode;
dr["CustName"] = CustNamedt.Rows[0][0].ToString();
dr["DeliveryDate"] = ObjProperty.DeliveryDate.ToString("dd/MM/yyyy");
dr["ReceivedVia"] = ObjProperty.ReceivedVia;
dr["HandOver"] = ObjProperty.HandOver;
dr["Remark"] = ObjProperty.Remark;
if (!isedit)
{
addRow(dr);
Session["GetDataValidation"] = false;
}
else
{
}
}
BindGridWithSession();
Clear();
ChekGetValue = false;
}
#endregion
}
private void KycFormSave()
{
OtherBAL.KycForm_Property ObjProperty = new OtherBAL.KycForm_Property();
OtherBAL ObjBal = new OtherBAL();
#region Checkbox Values Get
string rbtnval = "";
if (rbtnChr.Checked == true)
{
rbtnval = "CH RECD";
}
else if (rbtnSch.Checked == true)
{
rbtnval = "SCH";
}
else if (rbtnWcp.Checked == true)
{
rbtnval = "WCP";
}
else if (rbtnCod.Checked == true)
{
rbtnval = "COD";
}
else
{
rbtnval = "";
}
if (txtDisYear.Text == "")
{
txtDisYear.Text = "0";
}
if (txtTitlesYear.Text == "")
{
txtTitlesYear.Text = "0";
}
#endregion
//string OrderDate = txtOrderRecdDate.Text.Split('/')[1] + "/" + txtOrderRecdDate.Text.Split('/')[0] + "/" + txtOrderRecdDate.Text.Split('/')[2];
ObjProperty.KycNo = Convert.ToInt32(lblKycId.Text);
ObjProperty.CustCode = txtCustCode.Text.Split(':')[0].ToString();
ObjProperty.CustName = txtCustName.Text;
ObjProperty.CustAdd = txtCustAdd.Text;
ObjProperty.Area = txtArea.Text;
ObjProperty.City = txtCity.Text;
ObjProperty.ZipCode = txtZipCode.Text;
ObjProperty.ZoneCode = txtZoneCode.Text;
ObjProperty.Telepone = txtTelephone.Text;
ObjProperty.MobileNo = txtMobile.Text;
ObjProperty.IfBookseller = rbtnval;
ObjProperty.DelAdd = txtDelAdd.Text;
ObjProperty.Transport = txtTransport.SelectedValue;
ObjProperty.DisCurrentYear = float.Parse(txtDisYear.Text);
ObjProperty.TitleCurrentYear = Convert.ToInt32(txtTitlesYear.Text);
ObjProperty.PrevDic = float.Parse(lblprvyeardisc.Text);
ObjProperty.PrevTitle = Convert.ToInt32(lblpreyeartitles.Text == ""?"0":lblpreyeartitles.Text);
ObjProperty.ChkSchemeLetter = Convert.ToInt32(ChkScheme.Checked);
ObjProperty.ChkAddCommFrm = Convert.ToInt32(ChkAddComminsion.Checked);
ObjProperty.ChkDisForm = Convert.ToInt32(ChkDisForm.Checked);
ObjProperty.Remark = txtRemrk.Text;
ObjProperty.FY = Convert.ToInt32(Session["FY"]);
ObjProperty.CreatedBy = Session["UserName"].ToString();
ObjProperty.OS = Convert.ToSingle(lblOS.Text);
ObjProperty.R1 = lblAvg.Text;
ObjProperty.R2 = "";
ObjProperty.R3 = "";
ObjProperty.R4 = "";
ObjBal.Idv_Chetana_Save_KycForm(ObjProperty, out KycId, out KycMax);
if (lblEdit.Text == "Edit")
{
Message("Record save successfully Kyc Form No is " + KycId.ToString());
lblKycId.Text = "0";
lblEdit.Text = "";
btnDelete.Visible = false;
Clear();
}
else
{
Message("Record save successfully Kyc Form No is " + KycMax.ToString());
lblKycId.Text = "0";
lblEdit.Text = "";
btnDelete.Visible = false;
Clear();
}
}
public void fillReport()
{
bool IsCustomer = false;
Other_Z.OtherBAL Objbal = new OtherBAL();
string CustCode = txtcustomerid.Text.ToString();
DataTable dt = new DataTable();
if (lblCustName.Text.ToString().Split(':')[0].Trim().ToLower() == CustCode.ToLower())
{
CustCode = lblCustName.Text;
}
lblCustName.Text = CustCode;
txtcustomerid.Text = CustCode.ToString().Split(':')[0].Trim();
if (CustCode.Split('[').Length > 1)
{
if (CustCode.Split('[')[1].ToString().Split(']')[0].ToLower() == "cust")
{
//dt = DCMaster.Get_Name(CustCode.ToString().Split(':')[0].Trim(), "Customer").Tables[0];
IsCustomer = true;
}
else
{
IsCustomer = false;
}
}
txtcustomerid.Focus();
DataSet ds = new DataSet();
if (txtFromDate.Text.Split('/').Length > 1 && txttoDate.Text.Split('/').Length > 1)
{
try
{
//string FROMdate = txtFromDate.Text;
//string tOdate = txttoDate.Text;
string FROMdate = txtFromDate.Text.Split('/')[1] + "/" + txtFromDate.Text.Split('/')[0] + "/" + txtFromDate.Text.Split('/')[2];
string tOdate = txttoDate.Text.Split('/')[1] + "/" + txttoDate.Text.Split('/')[0] + "/" + txttoDate.Text.Split('/')[2];
ds = Objbal.Idv_Chetana_C_AccountingLedger(CustCode.ToString().Split(':')[0].Trim(), Convert.ToDateTime(FROMdate), Convert.ToDateTime(tOdate), "", Convert.ToInt32(Session["FY"]));
//ds = Objbal.Idv_Chetana_C_AccountingLedger("T05",Convert.ToDateTime("01/04/2015"),Convert.ToDateTime("31/03/2016"), "",Convert.ToInt32(2));
}
catch (Exception ex)
{
lblCustName.Text = "Date is incorrect";
txtcustomerid.Text = "";
txtFromDate.Text = "";
txttoDate.Text = "";
totAlAmt1.Visible = false;
totAlAmt.Visible = false;
}
}
if (ds.Tables.Count > 0)
{
if (ds.Tables[0].Rows.Count > 0)
{
ReportDocument rd = new ReportDocument();
rd.Load(Server.MapPath("~/CNF/report/CNFLedger.rpt"));
rd.SetDataSource(ds.Tables[0]);
rd.SetParameterValue("IsPrint", Convert.ToBoolean(IsPrint.Checked));
Cnfaccountingledger.ReportSource = rd;
totAlAmt1.Visible = true;
totAlAmt.Visible = true;
Button1.Visible = true;
btnPrint.Visible = true;
//lbloutstndamt.Text = ds.Tables[1].Rows[0]["Closin_bal"].ToString();
//lblopbal1.Text = ds.Tables[1].Rows[0]["Closin_bal"].ToString();
}
else
{
totAlAmt1.Visible = false;
totAlAmt.Visible = false;
MessageBox("No Records Found");
Button1.Visible = false;
btnPrint.Visible = false;
lbloutstndamt.Text = "0";
lblopbal1.Text = "0";
}
}
else
{
totAlAmt1.Visible = false;
totAlAmt.Visible = false;
MessageBox("No Records Found");
Button1.Visible = false;
btnPrint.Visible = false;
lbloutstndamt.Text = "0";
lblopbal1.Text = "0";
txtcustomerid.Focus();
}
}
protected void BtnGetDCDetails_Click(object sender, EventArgs e)
{
OtherBAL ObjBal = new OtherBAL();
string RadioVal = "";
DataSet ds = ObjBal.Idv_Chetana_Get_KycForm(Convert.ToInt32(txtDocIdEdit.Text), Convert.ToInt32(Session["FY"]), Convert.ToInt32("0"), Convert.ToInt32("0"), "", "", "", "");
DataTable dt = ds.Tables[1];
if (dt.Rows.Count > 0)
{
#region Radio Button Checked
RadioVal = dt.Rows[0]["IfBkseller"].ToString();
if (RadioVal == "CH RECD")
{
rbtnChr.Checked = true;
}
else if (RadioVal == "SCH")
{
rbtnSch.Checked = true;
}
else if (RadioVal == "WCP")
{
rbtnWcp.Checked = true;
}
else if (RadioVal == "COD")
{
rbtnCod.Checked = true;
}
else
{
RadioVal = "";
}
#endregion
lblKycId.Text = dt.Rows[0]["KycNo"].ToString();
txtCustCode.Text = dt.Rows[0]["CustCode"].ToString();
txtCustName.Text = dt.Rows[0]["CustName"].ToString();
txtCustAdd.Text = dt.Rows[0]["CustAddress"].ToString();
txtArea.Text = dt.Rows[0]["Area"].ToString();
txtCity.Text = dt.Rows[0]["City"].ToString();
txtZipCode.Text = dt.Rows[0]["ZipCode"].ToString();
txtZoneCode.Text = dt.Rows[0]["ZoneCode"].ToString();
txtTelephone.Text = dt.Rows[0]["TelNo"].ToString();
txtMobile.Text = dt.Rows[0]["MobileNo"].ToString();
txtDelAdd.Text = dt.Rows[0]["DelAddr"].ToString();
txtTitlesYear.Text = dt.Rows[0]["Titles"].ToString();
txtDisYear.Text = dt.Rows[0]["Dis"].ToString();
//Prev Year Dicount And Title
lblprvyeardisc.Text = dt.Rows[0]["PrevDis"].ToString();
lblpreyeartitles.Text = dt.Rows[0]["PrevTitle"].ToString();
ChkScheme.Checked = Convert.ToBoolean(dt.Rows[0]["SchLTR"].ToString());
ChkAddComminsion.Checked = Convert.ToBoolean(dt.Rows[0]["AddCommFrm"].ToString());
ChkDisForm.Checked = Convert.ToBoolean(dt.Rows[0]["DisForm"].ToString());
lblOS.Text = Convert.ToSingle(dt.Rows[0]["OS"]).ToString();
lblAvg.Text = dt.Rows[0]["TotalAvg"].ToString();
txtRemrk.Text = dt.Rows[0]["Remark"].ToString();
// txtPersonInchrg.Text = dt.Rows[0]["PersonInchrg"].ToString();
txtTransport.SelectedValue = dt.Rows[0]["Transport"].ToString();
lblAutoExtend.Text = lblKycId.Text;
txtCustCode.Focus();
lblEdit.Text = "Edit";
}
else
{
Message("Info! : \\r\\n Kyc No. " + txtDocIdEdit.Text.Trim() + " Not Found!!!");
ModalPopUpDocNum.Show();
txtDocIdEdit.Text = "";
txtDocIdEdit.Focus();
}
}
