public Int32 UpdateStatus(int intIGrpIdno, bool Status, Int32 empIdno)
{
int value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblIGrpMast objIGrpMast = (from mast in db.tblIGrpMasts
where mast.IGrp_Idno == intIGrpIdno
select mast).FirstOrDefault();
if (objIGrpMast != null)
{
objIGrpMast.Status = Status;
objIGrpMast.Emp_Idno = empIdno;
objIGrpMast.Date_Modified = System.DateTime.Now;
db.SaveChanges();
value = 1;
}
}
}
catch (Exception ex)
{
}
return(value);
}
/// <summary>
/// Delete Record from tblIGrpMast
/// </summary>
/// <param name="intIGropIdno"></param>
/// <returns></returns>
public int Delete(int intIGropIdno)
{
int intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblIGrpMast objIGrpMast = (from mast in db.tblIGrpMasts
where mast.IGrp_Idno == intIGropIdno
select mast).FirstOrDefault();
if (objIGrpMast != null)
{
db.tblIGrpMasts.DeleteObject(objIGrpMast);
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>
/// Insert records in tblIGrpMast
/// </summary>
/// <param name="strIGroupName"></param>
/// <param name="intIGrpType"></param>
/// <param name="bStatus"></param>
/// <returns></returns>
public Int64 Insert(string strIGroupName, int intIGrpType, bool bStatus, Int32 empIdno)
{
Int64 intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblIGrpMast objIGrpMast = new tblIGrpMast();
objIGrpMast.IGrp_Name = strIGroupName;
objIGrpMast.IGrp_Type = intIGrpType;
objIGrpMast.Status = bStatus;
objIGrpMast.Emp_Idno = empIdno;
objIGrpMast.Date_Added = System.DateTime.Now;
if (IsExists(strIGroupName, 0) == true)
{
intValue = -1;
}
else
{
db.tblIGrpMasts.AddObject(objIGrpMast);
db.SaveChanges();
intValue = objIGrpMast.IGrp_Idno;
}
}
}
catch (Exception ex)
{
//ApplicationFunction.ErrorLog(ex.ToString());
}
return(intValue);
}
/// <summary>
/// To Check data Already Exist or Not
/// </summary>
/// <param name="strIGroupName"></param>
/// <param name="intIGropIdno"></param>
/// <returns></returns>
public bool IsExists(string strIGroupName, int intIGropIdno)
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblIGrpMast objIGrpMast = new tblIGrpMast();
if (intIGropIdno <= 0)
{
objIGrpMast = (from mast in db.tblIGrpMasts
where mast.IGrp_Name == strIGroupName
select mast).FirstOrDefault();
}
else if (intIGropIdno > 0)
{
objIGrpMast = (from mast in db.tblIGrpMasts
where mast.IGrp_Name == strIGroupName &&
mast.IGrp_Idno != intIGropIdno
select mast).FirstOrDefault();
}
if (objIGrpMast != null)
{
return(true);
}
else
{
return(false);
}
}
}
/// <summary>
/// To Update Record in tblIGrpMast
/// </summary>
/// <param name="strIGroupName"></param>
/// <param name="intIGrpType"></param>
/// <param name="bStatus"></param>
/// <param name="intIGropIdno"></param>
/// <returns></returns>
public int Update(string strIGroupName, int intIGrpType, bool bStatus, int intIGropIdno, Int32 empIdno)
{
int intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblIGrpMast objIGrpMast = (from mast in db.tblIGrpMasts
where mast.IGrp_Idno == intIGropIdno
select mast).FirstOrDefault();
if (objIGrpMast != null)
{
objIGrpMast.IGrp_Name = strIGroupName;
objIGrpMast.IGrp_Type = intIGrpType;
objIGrpMast.Status = bStatus;
objIGrpMast.Emp_Idno = empIdno;
objIGrpMast.Date_Modified = System.DateTime.Now;
if (IsExists(strIGroupName, intIGropIdno) == true)
{
intValue = -1;
}
else
{
db.SaveChanges();
intValue = intIGropIdno;
}
}
}
}
catch (Exception ex)
{
//ApplicationFunction.ErrorLog(ex.ToString());
}
return(intValue);
}
