/// <summary>
/// Insert Branch Master
/// </summary>
/// <param name="objBrnchMst">table of Branch Master</param>
/// <returns>return 0 or >0</returns>
public Int64 Insert(tblTaxMaster TaxMast)
{
Int64 TaxIdno = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var objtbl = (from obj in db.tblTaxMasters where obj.State_Idno == TaxMast.State_Idno && obj.TaxTyp_Idno == TaxMast.TaxTyp_Idno select obj).ToList();
if (objtbl.Count > 0)
{
for (int i = 0; i < objtbl.Count; i++)
{
objtbl[i].Status = 0;
db.SaveChanges();
}
//objtbl[0].Status = 0;
}
db.AddTotblTaxMasters(TaxMast);
db.SaveChanges();
TaxIdno = Convert.ToInt32(TaxMast.TaxTyp_Idno);
}
}
catch (Exception ex)
{
//ApplicationFunction.ErrorLog(ex.ToString());
}
return(TaxIdno);
}
public bool UpdateTax(TaxMasterVM _TaxVM)
{
try
{
if (_TaxVM != null)
{
tblTaxMaster _tax = _TaxRepository.GetById(_TaxVM.TaxId);
_tax.TaxId = _TaxVM.TaxId;
_tax.TaxName = _TaxVM.TaxName;
_tax.TaxValue = _TaxVM.TaxValue;
_tax.IsActive = (bool)_TaxVM.IsActive;
_tax.IsDeleted = false;
_TaxRepository.Update(_tax);
_unitOfWork.Complete();
return(true);
}
else
{
return(false);
}
}
catch (Exception e)
{
throw e;
}
}
/// <summary>
/// Record exists or not if TaxTyp_Idno>0 then check for update else check for insert
/// </summary>
/// <param name="brnchName">Name of Tax Master</param>
/// <param name="CompIdno">Id of company</param>
/// <param name="brnchIdno">Id of Tax Master</param>
/// <returns>return single record</returns>
public bool IsExists(int Id, int stateIdno, DateTime TaxDate, int taxtypeIdno, int PANtype, int lorryfrom, int lorryto)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblTaxMaster TaxMast = new tblTaxMaster();
if (Id <= 0)
{
TaxMast = (from objTaxTyp in db.tblTaxMasters
where objTaxTyp.TaxTyp_Idno == taxtypeIdno &&
objTaxTyp.PANTyp_Idno == PANtype && objTaxTyp.State_Idno == stateIdno &&
objTaxTyp.Tax_Date == TaxDate && objTaxTyp.LorryCnt_From == lorryfrom && objTaxTyp.LorryCnt_To == lorryto
select objTaxTyp).SingleOrDefault();
var lst = (from objTaxTyp in db.tblTaxMasters
where objTaxTyp.TaxTyp_Idno == taxtypeIdno &&
objTaxTyp.PANTyp_Idno == PANtype && objTaxTyp.State_Idno == stateIdno &&
objTaxTyp.Tax_Date == TaxDate
select objTaxTyp).ToList();
if (lst.Count > 0)
{
foreach (var check in lst)
{
if (lorryfrom <= check.LorryCnt_From || lorryto <= check.LorryCnt_To || lorryfrom <= check.LorryCnt_To)
{
return(true);
}
}
}
}
else if (Id > 0)
{
TaxMast = (from objTaxTyp in db.tblTaxMasters
where objTaxTyp.TaxTyp_Idno == taxtypeIdno &&
objTaxTyp.PANTyp_Idno == PANtype && objTaxTyp.State_Idno == stateIdno &&
objTaxTyp.Tax_Date == TaxDate && objTaxTyp.LorryCnt_From == lorryfrom && objTaxTyp.LorryCnt_To == lorryto &&
objTaxTyp.TaxMast_Idno != Id
select objTaxTyp).SingleOrDefault();
var lst = (from objTaxTyp in db.tblTaxMasters
where objTaxTyp.TaxTyp_Idno == taxtypeIdno &&
objTaxTyp.PANTyp_Idno == PANtype && objTaxTyp.State_Idno == stateIdno &&
objTaxTyp.Tax_Date == TaxDate && objTaxTyp.LorryCnt_To <= lorryto &&
objTaxTyp.TaxMast_Idno != Id
select objTaxTyp).ToList();
if (lst.Count > 0)
{
foreach (var check in lst)
{
if (lorryfrom <= check.LorryCnt_From || lorryto <= check.LorryCnt_To || lorryfrom <= check.LorryCnt_To)
{
return(true);
}
}
}
}
return(false);
}
}
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;
}
}
/// <summary>
/// Update Branch Master
/// </summary>
/// <param name="objBrnchMst">table of Branch Master</param>
/// <returns>return o or >0</returns>
public Int64 Update(tblTaxMaster TaxMast, Int32 id)
{
Int64 TaxIdno = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblTaxMaster objTaxMast = (from objTaxTyp in db.tblTaxMasters
where objTaxTyp.TaxTyp_Idno == TaxMast.TaxTyp_Idno && objTaxTyp.State_Idno == TaxMast.State_Idno &&
objTaxTyp.Tax_Date == TaxMast.Tax_Date && objTaxTyp.PANTyp_Idno == TaxMast.PANTyp_Idno &&
objTaxTyp.TaxMast_Idno == id
select objTaxTyp).SingleOrDefault();
if (objTaxMast != null)
{
objTaxMast.TaxTyp_Idno = TaxMast.TaxTyp_Idno;
objTaxMast.State_Idno = TaxMast.State_Idno;
objTaxMast.Tax_Rate = TaxMast.Tax_Rate;
objTaxMast.Date_Added = TaxMast.Date_Added;
objTaxMast.Date_Modified = TaxMast.Date_Modified;
objTaxMast.Comp_Idno = TaxMast.Comp_Idno;
objTaxMast.Tax_Date = TaxMast.Tax_Date;
objTaxMast.Emp_Idno = TaxMast.Emp_Idno;
objTaxMast.PANTyp_Idno = TaxMast.PANTyp_Idno;
objTaxMast.LorryCnt_From = TaxMast.LorryCnt_From;
objTaxMast.LorryCnt_To = TaxMast.LorryCnt_To;
objTaxMast.CalOn_DF = TaxMast.CalOn_DF;
db.SaveChanges();
TaxIdno = Convert.ToInt32(objTaxMast.TaxTyp_Idno);
}
}
}
catch (Exception ex)
{
//ApplicationFunction.ErrorLog(ex.ToString());
}
return(TaxIdno);
}
public Int64 Insert(int taxtypeIdno, int stateIdno, double rate, int compID, DateTime TaxDate, int PANtype, int lorryfrom, int lorryto, bool CalonDf, Int32 empIdno)
{
Int64 TaxIdno = 0;
try
{
if (IsExists(0, stateIdno, TaxDate, taxtypeIdno, PANtype, lorryfrom, lorryto) == false)
{
tblTaxMaster TaxMast = new tblTaxMaster();
TaxMast.TaxTyp_Idno = taxtypeIdno;
TaxMast.State_Idno = stateIdno;
TaxMast.Emp_Idno = empIdno;
TaxMast.Tax_Rate = rate;
TaxMast.Date_Added = DateTime.Now.Date;// ApplicationFunction.GetIndianDateTime().Date;
TaxMast.Date_Modified = DateTime.Now.Date;
TaxMast.Comp_Idno = compID;
TaxMast.Tax_Date = TaxDate;
TaxMast.PANTyp_Idno = PANtype;
TaxMast.LorryCnt_From = lorryfrom;
TaxMast.LorryCnt_To = lorryto;
TaxMast.CalOn_DF = CalonDf;
TaxMast.Status = 1;
TaxMastDAL objTaxMastDLL = new TaxMastDAL();
TaxIdno = objTaxMastDLL.Insert(TaxMast);
objTaxMastDLL = null;
TaxIdno = Convert.ToInt32(TaxMast.TaxTyp_Idno);
}
else
{
TaxIdno = -1;
}
}
catch
{
}
return(TaxIdno);
}
/// <summary>
/// Set status false not deleting the Tax Master
/// </summary>
/// <returns>retun 0 or >0 </returns>
public int Delete(int TaxMastID)
{
int value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblTaxMaster TaxMast = (from objTaxTyp in db.tblTaxMasters
where objTaxTyp.TaxMast_Idno == TaxMastID
select objTaxTyp).SingleOrDefault();
if (TaxMast != null)
{
db.tblTaxMasters.DeleteObject(TaxMast);
db.SaveChanges();
value = 1;
}
}
}
catch
{
}
return(value);
}
