public void setvalue(string[,] set)
{
int i = 0;
int ModuleID = 0;
string Modulename = set[0, 8];
int RlId = Convert.ToInt32(set[0, 7]);
var note = (from n in db.tblmodulemasters where n.ModuleName == Modulename select n).First();
if (note != null)
{
ModuleID = note.ModuleID;
}
//Checking Role and dodule In DB
int Count = 0;
try
{
var RoleModule = (from n in db.tblroleplaymasters where (n.ModuleID == ModuleID && n.RolePlayID == RlId) select n).First();
if (RoleModule != null)
{
Count = 1;
}
}
catch { }
if (Count == 0)
{
//Taking moduleId From Table
for (int j = 0; j < 1; j++)
{
tblroleplaymaster rl = new tblroleplaymaster();
rl.IsAdded = Convert.ToBoolean(set[j, 0]);
rl.IsAll = Convert.ToBoolean(set[j, 1]);
rl.IsDeleted = Convert.ToInt32(set[j, 2]);
rl.IsEdited = Convert.ToBoolean(set[j, 3]);
rl.IsHidden = Convert.ToBoolean(set[j, 4]);
rl.IsReadOnly = Convert.ToBoolean(set[j, 5]);
rl.IsRemoved = Convert.ToBoolean(set[j, 6]);
rl.RoleID = Convert.ToInt32(set[j, 7]);
rl.ModuleID = ModuleID;
rl.CreatedBy = Convert.ToInt32(Session["UserID"]);
rl.CreatedOn = System.DateTime.Now;
db.tblroleplaymasters.Add(rl);
db.SaveChanges();
}
}
}
public ActionResult Create(List <tblmodulehelper> tblRolePlayHolder, int RoleID1)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"];
ViewBag.roleid = Session["RoleID"];
if (Request.Cookies["YourApLogin&"] != null)
{
string username = Request.Cookies["YourAppLogin"].Values["username"];
string RoleID = Request.Cookies["YourAppLogin"].Values["RoleID"];
string UserID = Request.Cookies["YourAppLogin"].Values["UserId"];
Session["Username"] = username;
Session["RoleID"] = RoleID;
Session["UserId"] = UserID;
}
else if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
else
{
ViewBag.Logout = Session["Username"];
ViewBag.roleid = Session["RoleID"];
String Username = Session["Username"].ToString();
}
int UserID1 = Convert.ToInt32(Session["UserID"].ToString());
int Role = 0;
int count = 0;
string[,] sss = new string[2, 11];
if (tblRolePlayHolder != null)
{
int i = 0;
foreach (var plan in tblRolePlayHolder)
{
tblroleplaymaster rl = new tblroleplaymaster();
sss[i, 0] = plan.IsAdded.ToString();
sss[i, 1] = plan.IsAll.ToString();
sss[i, 2] = plan.IsDeleted.ToString();
sss[i, 3] = plan.IsEdited.ToString();
sss[i, 4] = plan.IsHidden.ToString();
sss[i, 5] = plan.IsReadonly.ToString();
sss[i, 6] = plan.IsRemoved.ToString();
sss[i, 7] = RoleID1.ToString();
sss[i, 8] = plan.ModuleID.ToString();
sss[i, 9] = Convert.ToInt32(Session["UserID"]).ToString();
sss[i, 10] = System.DateTime.Now.ToString();
setvalue(sss);
count++;
}
//db.Entry(rl).State = EntityState.Modified;
//db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.ErrorMsg = "No daily plan details";
ViewBag.PrimaryRole = new SelectList(db.tblroles.Where(m => m.IsDeleted == 0), "Role_ID", "RoleName");
var tblRolPlayMaster1 = db.tblroleplaymasters.Include(t => t.tblmodulemaster).Where(m => m.IsDeleted == 0);
return(View(tblRolPlayMaster1.ToList()));
}
