/// <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(DateTime TaxDate, string PAN)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblLowRateMaster RateMast = new tblLowRateMaster();
RateMast = (from objRate in db.tblLowRateMasters
where objRate.PAN == PAN &&
objRate.Date == TaxDate
select objRate).SingleOrDefault();
var lst = (from objRate1 in db.tblLowRateMasters
where objRate1.PAN == PAN &&
objRate1.Date == TaxDate
select objRate1).ToList();
if (lst.Count > 0)
{
return(true);
}
else
{
return(false);
}
}
}
public Int64 Insert(Int64 AcntIdno, string PanNo, double rate, int compID, DateTime TaxDate, Int32 empIdno)
{
Int64 RateIdno = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
if (IsExists(TaxDate, PanNo) == false)
{
tblLowRateMaster TaxMast = new tblLowRateMaster();
TaxMast.Acnt_Idno = AcntIdno;
TaxMast.PAN = PanNo;
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.Date = TaxDate;
TaxMast.Status = 1;
db.AddTotblLowRateMasters(TaxMast);
db.SaveChanges();
RateIdno = Convert.ToInt32(TaxMast.LowRateMast_Idno);
}
else
{
RateIdno = -1;
}
}
}
catch
{
}
return(RateIdno);
}
private void Populate(int TaxMastID)
{
LowRateMastDAL objRateMast = new LowRateMastDAL();
tblLowRateMaster RateMast = objRateMast.SelectTaxByID(TaxMastID);
objRateMast = null;
if (RateMast != null)
{
txtDate.Text = Convert.ToString(Convert.ToDateTime(RateMast.Date).ToString("dd-MM-yyyy"));
drpPrtyName.SelectedValue = Convert.ToString(RateMast.Acnt_Idno);
drpPrtyName_SelectedIndexChanged(null, null);
//this.BindPanNo();
//drpPanNo. = RateMast.PAN.ToString();
drpPanNo.Items.FindByText(RateMast.PAN.ToString()).Selected = true;
taxRate.Text = Convert.ToString(RateMast.Tax_Rate);
hidTaxid.Value = RateMast.LowRateMast_Idno.ToString();
}
}
/// <summary>
/// Update Tax Master
/// </summary>
/// <param name="CityMast">table of Tax Master</param>
/// <returns>return o or >0</returns>
public Int64 Update(int id, Int64 AcntIdno, string PanNo, double rate, int compID, DateTime TaxDate, Int32 empIdno)
{
Int64 TaxIdno = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
if (IsExists(TaxDate, PanNo) == true)
{
tblLowRateMaster RateMast = (from objRate in db.tblLowRateMasters
where objRate.PAN == PanNo &&
objRate.Date == TaxDate &&
objRate.LowRateMast_Idno == id
select objRate).SingleOrDefault();
if (RateMast != null)
{
RateMast.Acnt_Idno = AcntIdno;
RateMast.PAN = PanNo;
RateMast.Tax_Rate = rate;
RateMast.Emp_Idno = empIdno;
RateMast.Date_Modified = DateTime.Now.Date;// ApplicationFunction.GetIndianDateTime().Date;
RateMast.Comp_Idno = compID;
RateMast.Date = TaxDate;
db.SaveChanges();
TaxIdno = Convert.ToInt32(RateMast.LowRateMast_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 RateMastID)
{
int value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblLowRateMaster RateMast = (from objRateTyp in db.tblLowRateMasters
where objRateTyp.LowRateMast_Idno == RateMastID
select objRateTyp).SingleOrDefault();
if (RateMast != null)
{
db.tblLowRateMasters.DeleteObject(RateMast);
db.SaveChanges();
value = 1;
}
}
}
catch
{
}
return(value);
}
