public int DL_InsUpdTaxGroupDetail(ML_TaxDetail objML_TaxDetail)
{
SqlParameter[] par = { new SqlParameter("@TaxGroupID", objML_TaxDetail.ID),
new SqlParameter("@TaxRateID", objML_TaxDetail.TaxRateID),
new SqlParameter("@Taxrate", objML_TaxDetail.TaxRate),
new SqlParameter("@Is_Default", objML_TaxDetail.Is_Default) };
return(SqlHelper.ExecuteNonQuery(con, "SPCN_Insert_Tax_Group_Detail", par));
}
public int DL_InsUpdTaxGroup(ML_TaxDetail objML_TaxDetail)
{
SqlParameter[] par = { new SqlParameter("@TaxGroupID", objML_TaxDetail.ID),
new SqlParameter("@TaxGroupName", objML_TaxDetail.TaxGroup),
new SqlParameter("@IsActive", objML_TaxDetail.isActive),
new SqlParameter("@CreatedBy", objML_TaxDetail.CreatedBy),
new SqlParameter("@ModifyBy", objML_TaxDetail.ModifyBy) };
return(SqlHelper.ExecuteNonQuery(con, "SPCN_Insert_Tax_Group_Master", par));
}
public DataTable DL_BindTaxGroup(ML_TaxDetail objML_TaxDetail)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_TaxDetail.ID) };
return(SqlHelper.ExecuteDataset(con, "SPCN_Tax_Group_Bind", par).Tables[0]);
}
public int DL_DeleteTaxGroupDetail(ML_TaxDetail objML_TaxDetail)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_TaxDetail.ID), };
return(SqlHelper.ExecuteNonQuery(con, "SPCN_Tax_Group_Detail_Delete", par));
}
public DataTable DL_SelectTaxRateDetail(ML_TaxDetail objML_TaxDetail)
{
SqlParameter[] par = { new SqlParameter("@ID", objML_TaxDetail.ID) };
return(SqlHelper.ExecuteDataset(con, "SPCN_Tax_Rate_Select", par).Tables[0]);
}
public int DL_DeleteTaxRateMaster(ML_TaxDetail objML_TaxDetail)
{
SqlParameter[] par = { new SqlParameter("@TaxRateID", objML_TaxDetail.ID), };
return(SqlHelper.ExecuteNonQuery(con, "SPCN_Tax_Rate_Master_Delete", par));
}
public DataTable BL_SelectTaxGroupDetail(ML_TaxDetail objML_TaxDetail)
{
return(objDL_TaxDetail.DL_SelectTaxGroupDetail(objML_TaxDetail));
}
public DataTable BL_BindTaxGroup(ML_TaxDetail objML_TaxDetail)
{
return(objDL_TaxDetail.DL_BindTaxGroup(objML_TaxDetail));
}
public int BL_InsUpdTaxGroup(ML_TaxDetail objML_TaxDetail)
{
return(objDL_TaxDetail.DL_InsUpdTaxGroup(objML_TaxDetail));
}
public int BL_DeleteTaxGroupDetail(ML_TaxDetail objML_TaxDetail)
{
return(objDL_TaxDetail.DL_DeleteTaxGroupDetail(objML_TaxDetail));
}
public int BL_DeleteTaxRateMaster(ML_TaxDetail objML_TaxDetail)
{
return(objDL_TaxDetail.DL_DeleteTaxRateMaster(objML_TaxDetail));
}
public DataTable BL_BindTaxRateinfo(ML_TaxDetail objML_TaxDetail)
{
return(objDL_TaxDetail.DL_BindTaxRateinfo(objML_TaxDetail));
}
public int BL_InsUpdTaxRateDetail(ML_TaxDetail objML_TaxDetail)
{
return(objDL_TaxDetail.DL_InsUpdTaxRateDetail(objML_TaxDetail));
}