public static int AddNewLandLord(mLandLords pLandlord) { int isSucess = 0; using (SqlConnection con = new SqlConnection(Global.connString)) { con.Open(); using (SqlCommand command = new SqlCommand("INSERT INTO tblLandlord ( LandLordName, LandLordEmail , LandLordPassword , LandLordPicture, IsEmailVerified, LandLordSignupDate, LastLoginDateTime, IsActive) " + " VALUES (@LandLordName, @LandLordEmail, @LandLordPassword , @LandLordPicture, @IsEmailVerified, @LandLordSignupDate, @LastLoginDateTime, @IsActive) select CAST(scope_identity() AS int) ", con)) { command.Parameters.AddWithValue("@LandLordName", pLandlord.LandLordName); command.Parameters.AddWithValue("@LandLordEmail", pLandlord.LandLordEmail); command.Parameters.AddWithValue("@LandLordPassword", pLandlord.LandLordPassword); command.Parameters.AddWithValue("@LandLordPicture", pLandlord.LandLordPicture); command.Parameters.AddWithValue("@IsEmailVerified", pLandlord.IsEmailVerified); command.Parameters.AddWithValue("@LandLordSignupDate", DateTime.Now); command.Parameters.AddWithValue("@LastLoginDateTime", DateTime.Now); command.Parameters.AddWithValue("@IsActive", pLandlord.IsActive); isSucess = Convert.ToInt32(command.ExecuteScalar()); } } return(isSucess); }
public static mLandLords VerifyLandLordInformation(string pLandLordEmail, string pLandLordPassword) { mLandLords collectmLandLord = new mLandLords(); using (SqlConnection con = new SqlConnection(Global.connString)) { con.Open(); using (SqlCommand command = new SqlCommand("select * from tblLandlord where LandLordEmail =@LandLordEmail and LandLordPassword=@LandLordPassword", con)) { command.Parameters.AddWithValue("@LandLordEmail", pLandLordEmail); command.Parameters.AddWithValue("@LandLordPassword", pLandLordPassword); using (SqlDataReader reader = command.ExecuteReader()) { if (reader.HasRows) { while (reader.Read()) { collectmLandLord.LandLordID = Convert.ToInt32(reader.GetValue(reader.GetOrdinal("LandLordID"))); collectmLandLord.LandLordIDEncrypted = ucEDOperations.EncryptString(Global.gEDKey, Convert.ToString(reader.GetValue(reader.GetOrdinal("LandLordID")))); collectmLandLord.LandLordName = reader.GetValue(reader.GetOrdinal("LandLordName")).ToString(); if (reader.GetValue(reader.GetOrdinal("LandLordEmail")) == null) { collectmLandLord.LandLordEmail = null; } else { collectmLandLord.LandLordEmail = reader.GetValue(reader.GetOrdinal("LandLordEmail")).ToString(); } //collectmLandLord.LastLogin = reader.GetDateTime(reader.GetOrdinal("LastLogin")); //reader.GetDateTime(16); collectmLandLord.IsActive = reader.GetBoolean(reader.GetOrdinal("IsActive")); //reader.GetBoolean(17); collectmLandLord.IsEmailVerified = reader.GetBoolean(reader.GetOrdinal("IsEmailVerified")); //reader.GetBoolean(17); } } else { collectmLandLord = null; } } } } return(collectmLandLord); }