public Int64 InsertIntoUserRights(Int64 intUserIdno, Int32 intDesigIdno, Int32 empIdno)
{
Int64 intValue = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
var lst = (from FM in db.tblDesigRights where FM.Desig_Idno == intDesigIdno select FM).ToList();
foreach (var UR in lst)
{
tblUserRight objUserRight = new tblUserRight();
objUserRight.Emp_Idno = Convert.ToInt32(intUserIdno);
objUserRight.Form_Idno = UR.Form_Idno;
objUserRight.View = UR.View;
objUserRight.User_Idno = empIdno; // this is user idno is that idno = whi is updated , deleted , modified, inserted
objUserRight.Edit = UR.Edit;
objUserRight.Delete = UR.Delete;
objUserRight.Print = UR.Print;
objUserRight.ADD = UR.ADD;
db.tblUserRights.AddObject(objUserRight);
db.SaveChanges();
intValue = Convert.ToInt32(objUserRight.Emp_Idno);
}
}
}
catch (Exception ex)
{
}
return(intValue);
}
public bool CheckUserRights(int intFormIdno)
{
bool bvalue = false;
try
{
WebTransport.DAL.LoginDAL objLoginDAL = new WebTransport.DAL.LoginDAL();
UserIdno = Convert.ToInt32(Session["UserIdno"].ToString());
tblUserRight objUserRghts = objLoginDAL.SelectUserRights(UserIdno, intFormIdno);
UserRgt_Idno = Convert.ToInt32(objUserRghts.UserRgt_Idno);
Form_Idno = Convert.ToInt32(objUserRghts.Form_Idno);
ADD = Convert.ToBoolean(objUserRghts.ADD);
Edit = Convert.ToBoolean(objUserRghts.Edit);
View = Convert.ToBoolean(objUserRghts.View);
Delete = Convert.ToBoolean(objUserRghts.Delete);
Print = Convert.ToBoolean(objUserRghts.Print);
if (ADD == false && Edit == false && View == false && Delete == false && Print == false)
{
bvalue = false;
}
else
{
bvalue = true;
}
objLoginDAL = null;
return(bvalue);
}
catch (Exception Ex)
{
}
return(bvalue);
}
public Int32 UpdateAll(int intUserRghtsIdno, bool bAdd, bool bEdit, bool bView, bool bDelete, bool bPrint, Int32 UpdateEmpIdno)
{
int value = 0;
try
{
using (TransportMandiEntities db = new TransportMandiEntities(MultipleDBDAL.strDynamicConString()))
{
tblUserRight objtbltblUserRight = (from mast in db.tblUserRights
where mast.UserRgt_Idno == intUserRghtsIdno
select mast).FirstOrDefault();
if (objtbltblUserRight != null)
{
objtbltblUserRight.User_Idno = UpdateEmpIdno;
objtbltblUserRight.ADD = bAdd;
objtbltblUserRight.Edit = bEdit;
objtbltblUserRight.View = bView;
objtbltblUserRight.Delete = bDelete;
objtbltblUserRight.Print = bPrint;
db.SaveChanges();
value = 1;
}
}
}
catch (Exception ex)
{
}
return(value);
}
