public JsonResult Fetch_Data() { ecommerceEntities1 db = new ecommerceEntities1(); var list = db.Tbl_Contact_Type.ToList(); return(Json(list, JsonRequestBehavior.AllowGet)); }
public string Add_Contact(string contact_Type) { if (contact_Type.Equals("")) { return("no"); } else { ecommerceEntities1 db = new ecommerceEntities1(); var checkUser = db.Tbl_Contact_Type.Where(rowHere => rowHere.Contact_Type.ToLower() == contact_Type.ToLower()).FirstOrDefault(); if (checkUser != null) { return("Already Present"); } else { Tbl_Contact_Type tbl_Contact_Type = new Tbl_Contact_Type { Contact_Type = contact_Type }; db.Tbl_Contact_Type.Add(tbl_Contact_Type); db.SaveChanges(); return("Added Successfully"); } } }
// this function is inserting data in 4 tables users, roles, status and register type. public string Register_User(string name, string email, string pass, string re_pass) { if (email.Equals("") || pass.Equals("") || re_pass.Equals("") || pass != re_pass) { return("no"); } else { ecommerceEntities1 db = new ecommerceEntities1(); var checkUser = db.Tbl_User.Where(rowHere => rowHere.Email.ToLower() == email.ToLower()).FirstOrDefault(); if (checkUser != null) { return("Already Present"); } else { int Reg_Mode_Type_Id = 1, Role_Type_Id = 1, Status_Type_Id = 5, User_Id = 0; Tbl_User tbl_User = new Tbl_User { Name = name, Email = email, Password = Encode.EncodePasswordToBase64(pass), Role_Type_Id = Role_Type_Id, Reg_Mode_Type_Id = Reg_Mode_Type_Id, Status_Type_Id = Status_Type_Id }; db.Tbl_User.Add(tbl_User); db.SaveChanges(); var users = db.Tbl_User.ToList(); foreach (var user in users) { if (@user.Email == email) { User_Id = user.User_Id; } } // MY FIRST OFFICIAL STORED FROCEDURE db.Insert_To_Tbl_Role(User_Id, Role_Type_Id); db.Insert_To_Tbl_Status(User_Id, Status_Type_Id); db.Insert_To_Tbl_Reg_Mode(User_Id, Reg_Mode_Type_Id); return("Registered Successfully, check mail to confirm"); } } }