public ActionResult Delete(int id)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"];
ViewBag.roleid = Session["RoleID"];
//start Logging
int UserID = Convert.ToInt32(Session["UserId"]);
String Username = Session["Username"].ToString();
//string CompleteModificationdetail = "Deleted MachineDetails";
//Action = "Delete";
//ActiveLogStorage Obj = new ActiveLogStorage();
//Obj.SaveActiveLog(Action, Controller, Username, UserID, CompleteModificationdetail);
//End
tblmailid tmi = db.tblmailids.Find(id);
tmi.IsDeleted = 1;
tmi.ModifiedBy = UserID;
tmi.ModifiedOn = System.DateTime.Now;
db.Entry(tmi).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Create(tblmailid tmi)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"];
ViewBag.roleid = Session["RoleID"];
String Username = Session["Username"].ToString();
#region//ActiveLog Code
int UserID = Convert.ToInt32(Session["UserId"]);
//string CompleteModificationdetail = "New Creation";
//Action = "Create";
// ActiveLogStorage Obj = new ActiveLogStorage();
// Obj.SaveActiveLog(Action, Controller, Username, UserID, CompleteModificationdetail);
//End
#endregion
//MailID Details validation
string name = tmi.Name.ToString();
string emailid = tmi.EmailID.ToString();
string contactNo = tmi.ContactNo.ToString();
var doesTheseExists = db.tblmailids.Where(m => m.IsDeleted == 0 && (m.Name == name || m.EmailID == emailid || m.ContactNo == contactNo)).ToList();
if (doesTheseExists.Count == 0)
{
tmi.IsDeleted = 0;
tmi.CreatedBy = UserID;
tmi.CreatedOn = DateTime.Now;
db.tblmailids.Add(tmi);
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
Session["Error"] = null;
var doesNameExists = db.tblmailids.Where(m => m.IsDeleted == 0 && m.Name == name).ToList();
if (doesNameExists.Count > 0)
{
Session["Error"] += "Duplicate Name. ";
}
var doesMailIdExists = db.tblmailids.Where(m => m.EmailID == emailid).ToList();
if (doesMailIdExists.Count > 0)
{
Session["Error"] += " Duplicate Email ID. ";
}
var doesCnoExists = db.tblmailids.Where(m => m.IsDeleted == 0 && m.ContactNo == contactNo).ToList();
if (doesCnoExists.Count > 0)
{
Session["Error"] += " Duplicate Contact Number. ";
}
return(View(tmi));
}
}
public ActionResult Edit(int id)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"];
ViewBag.roleid = Session["RoleID"];
String Username = Session["Username"].ToString();
tblmailid tmi = db.tblmailids.Find(id);
if (tmi == null)
{
return(HttpNotFound());
}
return(View(tmi));
}
public ActionResult Index()
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"];
ViewBag.roleid = Session["RoleID"];
//String Username = Session["Username"].ToString();
EmailManageModel email = new EmailManageModel();
tblmailid em = new tblmailid();
email.Email = em;
email.EmailList = db.tblmailids.Where(m => m.IsDeleted == 0).ToList();
//var mailData = db.masteremailmanage_tbl.Where(m => m.IsDeleted == 0).ToList();
return(View(email));
}
public ActionResult Edit(tblmailid tmi)
{
if ((Session["UserId"] == null) || (Session["UserId"].ToString() == String.Empty))
{
return(RedirectToAction("Login", "Login", null));
}
ViewBag.Logout = Session["Username"];
ViewBag.roleid = Session["RoleID"];
String Username = Session["Username"].ToString();
int UserID = Convert.ToInt32(Session["UserID"]);
//MailID details validation
string name = tmi.Name.ToString();
string emailid = tmi.EmailID.ToString();
string contactNo = tmi.ContactNo.ToString();
int MailIDDetailsID = tmi.MailIDsID;
var doesTheseExists = db.tblmailids.Where(m => m.IsDeleted == 0 && (m.Name == name || m.EmailID == emailid || m.ContactNo == contactNo) && m.MailIDsID != MailIDDetailsID).ToList();
if (doesTheseExists.Count == 0)
{
#region Active Log Code
//tblmachinecategory OldData = db.tblmachinecategories.Find(tblmc.ID);
//IEnumerable<string> FullData = ActiveLog.EnumeratePropertyDifferences<tblmachinecategory>(OldData, tblmc);
//ICollection<tblmachinecategory> c = FullData as ICollection<tblmachinecategory>;
//int Count = c.Count;
//if (Count != 0)
//{
// string CompleteModificationdetail = null;
// for (int i = 0; i < Count; i++)
// {
// CompleteModificationdetail = CompleteModificationdetail + "-" + FullData.Take(i).ToArray();
// }
// Action = "Edit";
// ActiveLogStorage Obj = new ActiveLogStorage();
// Obj.SaveActiveLog(Action, Controller, Username, UserID, CompleteModificationdetail);
//}
#endregion //End Active Log
tmi.ModifiedBy = UserID;
tmi.ModifiedOn = DateTime.Now;
db.Entry(tmi).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
else
{
Session["Error"] = null;
var doesNameExists = db.tblmailids.Where(m => m.IsDeleted == 0 && m.Name == name && m.MailIDsID != MailIDDetailsID).ToList();
if (doesNameExists.Count > 0)
{
Session["Error"] += "Duplicate Name. ";
}
var doesMailIdExists = db.tblmailids.Where(m => m.EmailID == emailid && m.MailIDsID != MailIDDetailsID).ToList();
if (doesMailIdExists.Count > 0)
{
Session["Error"] += " Duplicate Email ID. ";
}
var doesCnoExists = db.tblmailids.Where(m => m.IsDeleted == 0 && m.ContactNo == contactNo && m.MailIDsID != MailIDDetailsID).ToList();
if (doesCnoExists.Count > 0)
{
Session["Error"] += " Duplicate Contact Number. ";
}
return(View(tmi));
}
}
