public ActionResult Create(FormCollection collection) { try { // TODO: Add insert logic here Admin.Models.member.Member mem = new Admin.Models.member.Member(); var memberList = new List<Admin.Models.member.Member>() ; var encPassword = Encryptor.MD5Hash(collection.Get("Password")); //int roleid = Int32.Parse(collection.Get("RoleID").ToString()); int roleid = 1; model.Createmember(collection.Get("FirstName"), collection.Get("LastName"), collection.Get("Email"), collection.Get("Username"), encPassword,roleid); return RedirectToAction("Index"); } catch { return View(); } }
public Member GetRoleIDByMemberID(int memid) { Member mem = new Member(); SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = "select RoleID,MemberID from tbl_member where MemberID=@MemberID"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Command.Parameters.AddWithValue("@MemberID", memid); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { mem.RoleID = Int32.Parse(sqlConn.Reader["RoleID"].ToString()); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return mem; }
/// <summary> /// ///////////////////////////////////////////////////////////////////////////////////////////////////////////////// /// public List<Member> getonlymembers() { SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); Member mem = new Member(); var onlymemberlist = new List<Member>(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = " select MemberID,FirstName,LastName from tbl_memberinfo"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { onlymemberlist.Add(new Admin.Models.member.Member { MemberID = Int32.Parse(sqlConn.Reader["MemberID"].ToString()), FirstName = sqlConn.Reader["FirstName"].ToString(), LastName = sqlConn.Reader["LastName"].ToString() }); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return onlymemberlist; }
/////////////////////////////////////////////////////////////////////////////////////////////////////////////////// public List<Member> getNameByroleid() { SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); Member mem = new Member(); var onlyRoleName = new List<Member>(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = " select RoleID,Name from tbl_role"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { onlyRoleName.Add(new Admin.Models.member.Member { RoleID = Int32.Parse(sqlConn.Reader["RoleID"].ToString()), Name = sqlConn.Reader["Name"].ToString(), //.RoleILastName = sqlConn.Reader["LastName"].ToString() }); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return onlyRoleName; }
public Member GetMemberNameFromMemberId(int mid) { Member mem = new Member(); // string encPassword = ""; SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = "select MemberID, FirstName,Lastname from tbl_memberinfo where MemberID=@mid"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Command.Parameters.AddWithValue("@mid", mid); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { if (sqlConn.Reader.Read()) { mem.FirstName = sqlConn.Reader["FirstName"].ToString(); mem.LastName = sqlConn.Reader["LastName"].ToString(); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return mem; }
public Member GetMemberIDFromUsername(string username) { Member mem = new Member(); // string encPassword = ""; SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = "select MemberID from tbl_member as tbm where tbm.username=@username"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Command.Parameters.AddWithValue("@username", username); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { if (sqlConn.Reader.Read()) { mem.MemberID = Int32.Parse(sqlConn.Reader["MemberID"].ToString()); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return mem; }
public Member GetMemberByMemberID(int memID) { Member mem = new Member(); SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); // sqlConn.Query = "select Email,UserName,Password,FirstName,LastName from tbl_member,tbl_memberinfo where tbl_member.MemberID=tbl_memberinfo.MemberID"; sqlConn.Query = "select m.MemberID,m.Email,m.UserName,m.Password,mi.FirstName,mi.LastName from tbl_member as m join tbl_memberinfo as mi on m.MemberID = mi.MemberID where m.MemberID=@MemberID"; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Command.Parameters.AddWithValue("@MemberID", memID); sqlConn.Connection.Open(); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { mem.MemberID = Int32.Parse(sqlConn.Reader["MemberID"].ToString()); mem.Email = sqlConn.Reader["Email"].ToString(); mem.Username = sqlConn.Reader["UserName"].ToString(); mem.Password = sqlConn.Reader["Password"].ToString(); mem.FirstName = sqlConn.Reader["FirstName"].ToString(); mem.LastName = sqlConn.Reader["LastName"].ToString(); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return mem; }
/// ///////////////////////////////////////////////////////////////// /// </summary> /// /// // public class ImageResult : FileStreamResult // { // public ImageResult(Image input):this(input,input.Width,input.Height) { } // public ImageResult(Image input, int width,int height) : // base(GetMemoryStream(input,width,height,ImageFormat.Png), "image/png") //{ } // static MemoryStream GetMemoryStream(Image input,int width, // int height,ImageFormat fmt) // { // // maintain aspect ratio // if (input.Width > input.Height) // height = input.Height * width / input.Width; // else // width = input.Width * height / input.Height; // var bmp = new Bitmap(input, width, height); // var ms = new MemoryStream(); // bmp.Save(ms, ImageFormat.Png); // ms.Position = 0; // return ms; // } //} // /// // /// /// /// /// ///////////////// /// <returns></returns> public List<Member> GetAllmembers() { SQLManager.SQLManager sqlConn = new SQLManager.SQLManager(); Member mem = new Member(); var memberList = new List<Member>(); try { sqlConn.Connection = new SqlConnection(sqlConn.ConnectionString); sqlConn.Query = " select m.MemberID,m.Email,m.UserName,mi.FirstName,mi.LastName from tbl_member as m join tbl_memberinfo as mi on m.MemberID = mi.MemberID "; sqlConn.Command = new SqlCommand(sqlConn.Query, sqlConn.Connection); sqlConn.Connection.Open(); //var id = Convert.ToInt32(sqlConn.Command.ExecuteScalar()); using (sqlConn.Reader = sqlConn.Command.ExecuteReader()) { while (sqlConn.Reader.Read()) { memberList.Add(new Admin.Models.member.Member { MemberID = Int32.Parse(sqlConn.Reader["MemberID"].ToString()), Email = sqlConn.Reader["Email"].ToString(), Username = sqlConn.Reader["Username"].ToString(), // Password=sqlConn.Reader["Password"].ToString(), // string Password = GenerateRandomString(Password).ToString(); FirstName = sqlConn.Reader["FirstName"].ToString(), LastName = sqlConn.Reader["LastName"].ToString() }); } } } catch (Exception ex) { throw ex; } finally { if (sqlConn.Reader != null) sqlConn.Reader.Close(); sqlConn.Connection.Close(); sqlConn.Connection.Dispose(); } return memberList; }