public bool UpdateAuthUserSite(DataTable dtNodes, string username)
{
try
{
IList <AuthUserSiteTransactionMap> authlist = new List <AuthUserSiteTransactionMap>();
int i;
for (i = 0; i < dtNodes.Rows.Count; i++)
{
AuthUserSiteTransactionMap auth = new AuthUserSiteTransactionMap();
auth.AuthTransactionCode = dtNodes.Rows[i]["Nodes"].ToString();
string str = dtNodes.Rows[i]["Nodes"].ToString();
auth = Context.AuthUserSiteTransactionMap.Where(a => a.UserID == username && a.AuthTransactionCode == str && a.SiteCode == CommonModel.SiteCode).FirstOrDefault();
if (auth != null)
{
auth.UPDATEDAT = CommonModel.SiteCode;
auth.UPDATEDBY = CommonModel.UserID;
auth.UPDATEDON = CommonModel.CurrentDate;
auth.STATUS = Convert.ToBoolean(dtNodes.Rows[i]["Status"]);
Context.SaveChanges();
}
else
{
AuthUserSiteTransactionMap auth1 = new AuthUserSiteTransactionMap();
auth1.UserID = username;
auth1.SiteCode = CommonModel.SiteCode;
auth1.AuthTransactionCode = dtNodes.Rows[i]["Nodes"].ToString();
auth1.Rights = true;
auth1.CREATEDAT = CommonModel.SiteCode;
auth1.CREATEDBY = CommonModel.UserID;
auth1.CREATEDON = CommonModel.CurrentDate;
auth1.UPDATEDAT = CommonModel.SiteCode;
auth1.UPDATEDBY = CommonModel.UserID;
auth1.UPDATEDON = CommonModel.CurrentDate;
auth1.STATUS = Convert.ToBoolean(dtNodes.Rows[i]["Status"]);
Context.AuthUserSiteTransactionMap.Add(auth1);
Context.SaveChanges();
}
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
public bool AddAuthUserSite(DataTable dtNodes, string username)
{
try
{
// AuthUserSiteTransactionMap auth=new AuthUserSiteTransactionMap();
IList <AuthUserSiteTransactionMap> authlist = new List <AuthUserSiteTransactionMap>();
int i;
for (i = 0; i < dtNodes.Rows.Count; i++)
{
AuthUserSiteTransactionMap auth = new AuthUserSiteTransactionMap();
auth.UserID = username;
auth.SiteCode = CommonModel.SiteCode;
auth.AuthTransactionCode = dtNodes.Rows[i]["Nodes"].ToString();
auth.Rights = true;
auth.CREATEDAT = CommonModel.SiteCode;
auth.CREATEDBY = CommonModel.UserID;
auth.CREATEDON = CommonModel.CurrentDate;
auth.UPDATEDAT = CommonModel.SiteCode;
auth.UPDATEDBY = CommonModel.UserID;
auth.UPDATEDON = CommonModel.CurrentDate;
auth.STATUS = Convert.ToBoolean(dtNodes.Rows[i]["Status"]);
authlist.Add(auth);
}
foreach (AuthUserSiteTransactionMap obj in authlist)
{
Context.AuthUserSiteTransactionMap.Add(obj);
Context.SaveChanges();
}
return(true);
}
catch (Exception ex)
{
throw ex;
}
}
