/// <summary>
/// Insert records in AcntSubHead
/// </summary>
/// <param name="strASubHeadName"></param>
/// <param name="intAHeadIdno"></param>
/// <param name="bStatus"></param>
/// <returns></returns>
public Int64 InsertAcntHead(string strASubHeadName, Int64 intAHeadIdno, bool bStatus, Int32 empIdno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
Int64 value;
Int32 intCompIdno = 1;
AcntSubHead ObjAcntSubHead = new AcntSubHead();
if (IsExists(strASubHeadName, 0))
{
value = -1;
}
else
{
ObjAcntSubHead.ASubHead_Name = strASubHeadName;
ObjAcntSubHead.AHead_Idno = intAHeadIdno;
ObjAcntSubHead.Emp_Idno = empIdno;
ObjAcntSubHead.Status = bStatus;
ObjAcntSubHead.Comp_Idno = intCompIdno;
ObjAcntSubHead.Date_Added = System.DateTime.Now;
db.AddToAcntSubHeads(ObjAcntSubHead);
db.SaveChanges();
value = ObjAcntSubHead.ASubHead_Idno;
}
return(value);
}
}
public Int32 UpdateStatus(int intASubHeadIdno, bool bStatus, Int32 empIdno)
{
int value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
AcntSubHead objAcntSubHead = (from mast in db.AcntSubHeads
where mast.ASubHead_Idno == intASubHeadIdno
select mast).FirstOrDefault();
if (objAcntSubHead != null)
{
objAcntSubHead.Status = bStatus;
objAcntSubHead.Emp_Idno = empIdno;
objAcntSubHead.Date_Modified = System.DateTime.Now;
db.SaveChanges();
value = 1;
}
}
}
catch (Exception ex)
{
}
return(value);
}
/// <summary>
/// To check record existence in AcntSubHead
/// </summary>
/// <param name="strASubHeadName"></param>
/// <param name="intAHeadIdno"></param>
/// <param name="intAHeadIdno"></param>
/// <returns></returns>
public bool IsExists(string strASubHeadName, Int64 intASubHeadIdno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
AcntSubHead objAcntSubHead = null;
if (intASubHeadIdno > 0)///for update
{
objAcntSubHead = (from AH in db.AcntSubHeads
where AH.ASubHead_Name == strASubHeadName &&
AH.ASubHead_Idno != intASubHeadIdno
select AH).FirstOrDefault();
}
else /// for insert
{
objAcntSubHead = (from AH in db.AcntSubHeads
where AH.ASubHead_Name == strASubHeadName
select AH).FirstOrDefault();
}
if (objAcntSubHead != null)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// Delete record from AcntSubHead
/// </summary>
/// <param name="intColrIdno"></param>
/// <returns></returns>
public int Delete(int intASubHeadIdno)
{
int intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
AcntSubHead objMast = (from mast in db.AcntSubHeads
where mast.ASubHead_Idno == intASubHeadIdno
select mast).FirstOrDefault();
if (objMast != null)
{
db.DeleteObject(objMast);
db.SaveChanges();
intValue = 1;
}
}
}
catch (Exception Ex)
{
if (Convert.ToBoolean(Ex.InnerException.Message.Contains("The DELETE statement conflicted with the REFERENCE constraint")) == true)
{
intValue = -1;
}
}
return(intValue);
}
/// <summary>
/// Update records in AcntSubHead
/// </summary>
/// <param name="strASubHeadName"></param>
/// <param name="bStatus"></param>
/// <param name="intAHeadIdno"></param>
/// <param name="intAHeadIdno"></param>
/// <returns></returns>
public Int64 UpdateAcntHead(string strASubHeadName, Int64 intAHeadIdno, Int64 intASubHeadIdno, bool bStatus, Int32 empIdno)
{
Int64 value = 0;
Int32 intCompIdno = 1;
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
AcntSubHead objAcntSubHead = (from mast in db.AcntSubHeads
where mast.ASubHead_Idno == intASubHeadIdno
select mast).FirstOrDefault();
if (objAcntSubHead != null)
{
objAcntSubHead.ASubHead_Name = strASubHeadName;
objAcntSubHead.AHead_Idno = intAHeadIdno;
objAcntSubHead.Emp_Idno = empIdno;
objAcntSubHead.Status = bStatus;
objAcntSubHead.Comp_Idno = intCompIdno;
objAcntSubHead.Date_Modified = System.DateTime.Now;
if (IsExists(strASubHeadName, intASubHeadIdno) == true)
{
value = -1;
}
else
{
db.SaveChanges();
value = intAHeadIdno;
}
}
}
return(value);
}
