protected void drpState_SelectedIndexChanged(object sender, EventArgs e)
{
TaxMastDAL objTaxMastBLL = new TaxMastDAL();
var lst = (IList)null;
if (Convert.ToInt32(drpdownTaxType.SelectedValue) <= 0)
{
lst = objTaxMastBLL.SelectAllTaxByID(Convert.ToInt32(drpState.SelectedValue), cOMPiD);
}
else
{
lst = objTaxMastBLL.SelectAllTaxTypeByID(Convert.ToInt32(Convert.ToString(drpState.SelectedValue) == "" ? 0 : Convert.ToInt32(drpState.SelectedValue)), Convert.ToInt32(Convert.ToString(drpdownTaxType.SelectedValue) == "" ? 0 : Convert.ToInt32(drpdownTaxType.SelectedValue)), 1);
}
if (lst.Count > 0)
{
DivGridShow.Visible = true;
objTaxMastBLL = null;
grdMain.DataSource = lst;
grdMain.DataBind();
}
else
{
this.BindGrid();
}
drpdownTaxType.Focus();
}
private void SelectPANType()
{
TaxMastDAL objTaxMastBLL = new TaxMastDAL();
var lst = objTaxMastBLL.SelectPANType();
objTaxMastBLL = null;
ddlPANType.DataSource = lst;
ddlPANType.DataTextField = "PANType_Name";
ddlPANType.DataValueField = "PANType_Idno";
ddlPANType.DataBind();
ddlPANType.Items.Insert(0, new ListItem("--Select--", "0"));
}
private void BindState()
{
drpState.DataSource = null;
TaxMastDAL accountDAL = new TaxMastDAL();
var lst = accountDAL.SelectState(0);
accountDAL = null;
drpState.DataSource = lst;
drpState.DataTextField = "State_Name";
drpState.DataValueField = "State_Idno";
drpState.DataBind();
drpState.Items.Insert(0, new ListItem("--Select State--", "0"));
}
protected void grdMain_RowCommand(object sender, GridViewCommandEventArgs e)
{
if (e.CommandName == "cmdedit")
{
int TaxMastID = Convert.ToInt32(e.CommandArgument);
this.Populate(TaxMastID);
}
else if (e.CommandName == "cmddelete")
{
TaxMastDAL objTaxMastBLL = new TaxMastDAL();
int TaxMastID = Convert.ToInt32(e.CommandArgument);
objTaxMastBLL.Delete(TaxMastID);
objTaxMastBLL = null;
this.ClearControls();
this.BindGrid();
}
}
protected void drpdownTaxType_SelectedIndexChanged(object sender, EventArgs e)
{
try
{
if (drpdownTaxType.SelectedItem.Text.Trim() == "TDS")
{
ddlPANType.Enabled = txtLorryFrom.Enabled = txtlorryto.Enabled = chkCalOnDF.Enabled = true;
}
else
{
ddlPANType.Enabled = txtLorryFrom.Enabled = txtlorryto.Enabled = chkCalOnDF.Enabled = false;
}
if (drpdownTaxType.SelectedItem.Text.Trim() == "UGST" || drpdownTaxType.SelectedItem.Text.Trim() == "IGST" || drpdownTaxType.SelectedItem.Text.Trim() == "CGST" || drpdownTaxType.SelectedItem.Text.Trim() == "SGST")
{
ddlPANType.Enabled = txtLorryFrom.Enabled = txtlorryto.Enabled = chkCalOnDF.Enabled = drpState.Enabled = RequiredFieldValidator1.Enabled = false;
}
else
{
ddlPANType.Enabled = txtLorryFrom.Enabled = txtlorryto.Enabled = chkCalOnDF.Enabled = drpState.Enabled = RequiredFieldValidator1.Enabled = true;
}
TaxMastDAL objTaxMastBLL = new TaxMastDAL();
var lst = objTaxMastBLL.SelectAllTaxTypeByID(Convert.ToInt32(Convert.ToString(drpState.SelectedValue) == "" ? 0 : Convert.ToInt32(drpState.SelectedValue)), Convert.ToInt32(Convert.ToString(drpdownTaxType.SelectedValue) == "" ? 0 : Convert.ToInt32(drpdownTaxType.SelectedValue)), 1);
if (lst.Count > 0)
{
objTaxMastBLL = null;
DivGridShow.Visible = true;
grdMain.DataSource = lst;
grdMain.DataBind();
}
else
{
this.BindGrid();
}
}
catch (Exception Ex)
{
}
txtDate.Focus();
}
private void Populate(int TaxMastID)
{
TaxMastDAL objTaxMastBLL = new TaxMastDAL();
tblTaxMaster TaxMast = objTaxMastBLL.SelectTaxByID(TaxMastID);
objTaxMastBLL = null;
if (TaxMast != null)
{
txtDate.Text = string.IsNullOrEmpty(Convert.ToString(TaxMast.Tax_Date))?"":Convert.ToString(Convert.ToDateTime(TaxMast.Tax_Date).ToString("dd-MM-yyyy"));
drpdownTaxType.SelectedValue = string.IsNullOrEmpty(Convert.ToString(TaxMast.TaxTyp_Idno))?"0": TaxMast.TaxTyp_Idno.ToString();
drpState.SelectedValue = string.IsNullOrEmpty(Convert.ToString(TaxMast.State_Idno))?"0":TaxMast.State_Idno.ToString();
drpdownTaxType.Enabled = false;
drpState.Enabled = false;
taxRate.Text = string.IsNullOrEmpty(Convert.ToString(TaxMast.Tax_Rate)) ? "0.00" : Convert.ToString(TaxMast.Tax_Rate);
hidTaxid.Value = string.IsNullOrEmpty(Convert.ToString(TaxMast.TaxMast_Idno))?"0":TaxMast.TaxMast_Idno.ToString();
ddlPANType.SelectedValue = string.IsNullOrEmpty(Convert.ToString(TaxMast.PANTyp_Idno))?"0":Convert.ToString(TaxMast.PANTyp_Idno);
txtlorryto.Text = string.IsNullOrEmpty(Convert.ToString(TaxMast.LorryCnt_To))?"0": Convert.ToString(TaxMast.LorryCnt_To);
txtLorryFrom.Text = string.IsNullOrEmpty(Convert.ToString(TaxMast.LorryCnt_From)) ? "0" : Convert.ToString(TaxMast.LorryCnt_From);
chkCalOnDF.Checked = string.IsNullOrEmpty((Convert.ToString(TaxMast.CalOn_DF))) ? false : Convert.ToBoolean(TaxMast.CalOn_DF);
//chkLowRate.Checked = Convert.ToBoolean(TaxMast.LowRateWise) == true ? true : false;
}
}
private void BindGrid()
{
TaxMastDAL objTaxMastBLL = new TaxMastDAL();
IList lstGridData = objTaxMastBLL.Select(0, Convert.ToInt32(Convert.ToString(drpState.SelectedValue) == "" ? 0 : Convert.ToInt32(drpState.SelectedValue)), Convert.ToInt32(Convert.ToString(drpdownTaxType.SelectedValue) == "" ? 0 : Convert.ToInt32(drpdownTaxType.SelectedValue)));
objTaxMastBLL = null;
grdMain.DataSource = lstGridData;
grdMain.DataBind();
if (lstGridData != null)
{
if (lstGridData.Count > 0)
{
DivGridShow.Visible = true;
lblTotalRecord.Text = "Total Record (s): " + lstGridData.Count;
int startRowOnPage = (grdMain.PageIndex * grdMain.PageSize) + 1;
int lastRowOnPage = startRowOnPage + grdMain.Rows.Count - 1;
lblcontant.Text = "Showing " + startRowOnPage.ToString() + " - " + lastRowOnPage.ToString() + " of " + lstGridData.Count.ToString();
lblcontant.Visible = true;
divpaging.Visible = true;
}
else
{
DivGridShow.Visible = false;
lblTotalRecord.Text = "Total Record (s): 0";
lblcontant.Visible = false;
divpaging.Visible = false;
}
}
else
{
DivGridShow.Visible = false;
lblTotalRecord.Text = "Total Record (s): 0";
lblcontant.Visible = false;
divpaging.Visible = false;
}
}
protected void lnkbtnSave_OnClick(object sender, EventArgs e)
{
Int32 empIdno = Convert.ToInt32((Session["UserIdno"] == null) ? "0" : Session["UserIdno"].ToString());
string smsg = string.Empty;
if ((Convert.ToDouble(Convert.ToDouble(taxRate.Text.Trim())) <= 0) || (Convert.ToDouble(Convert.ToDouble(taxRate.Text.Trim())) >= 100))
{
if (Convert.ToDouble(taxRate.Text.Trim()) <= 0)
{
ShowMessageErr("Please Enter Tax Rate!");
}
else
{
ShowMessageErr("Tax rate cannot be greater than or equal to 100");
}
taxRate.Focus();
return;
}
if (Convert.ToString(drpdownTaxType.SelectedValue) == "2")
{
if (txtLorryFrom.Text == "")
{
txtLorryFrom.Text = "0";
}
if (txtlorryto.Text == "")
{
txtlorryto.Text = "0";
}
if (Convert.ToInt32(txtLorryFrom.Text.Trim()) <= 0)
{
ShowMessageErr("Please Enter Lorry From!");
txtLorryFrom.Focus();
return;
}
if (Convert.ToInt32(txtlorryto.Text.Trim()) <= 0)
{
ShowMessageErr("Please Enter Lorry To!");
txtlorryto.Focus();
return;
}
if (Convert.ToInt32(txtlorryto.Text.Trim()) <= Convert.ToInt32(txtLorryFrom.Text.Trim()))
{
ShowMessageErr("Lorry From Should be smaller than Lorry To!");
txtLorryFrom.Focus();
return;
}
}
TaxMastDAL objTaxMastBLL = new TaxMastDAL();
Int64 TaxId = 0;
int compID = 0;//Convert.ToInt32(UsessionValue.CompId);
// DateTime dateModified = DateTime.Now;
int taxtypeIdno = Convert.ToInt32(drpdownTaxType.SelectedValue);
int stateIdno = Convert.ToInt32(drpState.SelectedValue);
double rate = Convert.ToDouble(Convert.ToString(taxRate.Text));
int PANtype = Convert.ToInt32(Convert.ToString(ddlPANType.SelectedValue) == "" ? 0 : Convert.ToInt32(ddlPANType.SelectedValue));
int lorryfrom = Convert.ToInt32(Convert.ToString(txtLorryFrom.Text));
int lorryto = Convert.ToInt32(Convert.ToString(txtlorryto.Text));
bool CalonDf = Convert.ToBoolean((chkCalOnDF.Checked) == true ? 1 : 0);
//bool LowRate = Convert.ToBoolean((chkLowRate.Checked) == true ? 1 : 0);
if (drpdownTaxType.SelectedItem.Text.Trim() == "UGST" || drpdownTaxType.SelectedItem.Text.Trim() == "IGST" || drpdownTaxType.SelectedItem.Text.Trim() == "CGST" || drpdownTaxType.SelectedItem.Text.Trim() == "SGST")
{
PANtype = 0; lorryfrom = 0; lorryto = 0; CalonDf = false; stateIdno = 0;
}
if (string.IsNullOrEmpty(hidTaxid.Value) == true)
{
TaxId = objTaxMastBLL.Insert(taxtypeIdno, stateIdno, rate, compID, Convert.ToDateTime(ApplicationFunction.mmddyyyyDash(txtDate.Text.Trim())), PANtype, lorryfrom, lorryto, CalonDf, empIdno);
}
else
{
TaxId = objTaxMastBLL.Update(Convert.ToInt32(hidTaxid.Value), taxtypeIdno, stateIdno, rate, compID, Convert.ToDateTime(ApplicationFunction.mmddyyyyDash(txtDate.Text.Trim())), PANtype, lorryfrom, lorryto, CalonDf, empIdno);
}
if (TaxId == 0)
{
ShowMessageErr("Record Not Saved ");
}
else if (TaxId < 0)
{
ShowMessageErr("Record already exists.");
}
else if (TaxId > 0)
{
if (hidTaxid.Value == "")
{
ShowMessage("Record Saved Successfully");
}
else
{
ShowMessage("Record Updated Successfully.");
drpState.Enabled = true;
}
this.ClearControls();
this.BindGrid();
}
}
