public List <VehicleUsersMaster> vehicleusers_Update(VehicleUsersMaster input) { List <VehicleUsersMaster> listvehicleusers = new List <VehicleUsersMaster>(); using (MySqlDataReader reader = ExecuteDataReader("vehicleusers_InsertUpdateDelete", CreateParameter("UserId_", MySqlDbType.Int32, input.UserId), CreateParameter("CountryId_", MySqlDbType.Int32, input.CountryId), CreateParameter("StateId_", MySqlDbType.Int32, input.StateId), CreateParameter("CityId_", MySqlDbType.Int32, input.CityId), CreateParameter("DistrictId_", MySqlDbType.Int32, input.DistrictId), CreateParameter("Address_", MySqlDbType.VarChar, input.Address), CreateParameter("AdhaarNo_", MySqlDbType.VarChar, input.AdhaarNo), CreateParameter("DLExpiryDate_", MySqlDbType.DateTime, input.DLExpiryDate), CreateParameter("DLNo_", MySqlDbType.VarChar, input.DLNo), CreateParameter("EmailId_", MySqlDbType.VarChar, input.EmailId), CreateParameter("FullName_", MySqlDbType.VarChar, input.FullName), CreateParameter("Password_", MySqlDbType.VarChar, input.Password), CreateParameter("PhoneNo_", MySqlDbType.VarChar, input.PhoneNo), CreateParameter("UserName_", MySqlDbType.VarChar, input.UserName), CreateParameter("VoterId_", MySqlDbType.VarChar, input.VoterId), CreateParameter("Type_", MySqlDbType.Int32, 2))) { while (reader.Read()) { VehicleUsersMaster obj = new VehicleUsersMaster(); obj.CityId = Convert.ToInt32(reader["CityId"]); obj.StateId = Convert.ToInt32(reader["CityId"]); obj.CountryId = Convert.ToInt32(reader["CountryId"]); obj.DistrictId = Convert.ToInt32(reader["DistrictId"]); obj.UserId = Convert.ToInt32(reader["UserId"]); obj.UserName = reader["UserName"].ToString(); obj.FullName = reader["FullName"].ToString(); obj.PhoneNo = reader["PhoneNo"].ToString(); obj.EmailId = reader["EmailId"].ToString(); obj.AdhaarNo = reader["AdhaarNo"].ToString(); obj.Address = reader["Address"].ToString(); obj.VoterId = reader["VoterId"].ToString(); obj.DLNo = reader["DLNo"].ToString(); obj.DLExpiryDate = Convert.ToDateTime(reader["DLExpiryDate"]); obj.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]); obj.IsActive = Convert.ToBoolean(reader["IsActive"]); listvehicleusers.Add(obj); } } return(listvehicleusers); }
public List <VehicleUsersMaster> vehicleusers_RetrieveAll() { List <VehicleUsersMaster> listvehicleusers = new List <VehicleUsersMaster>(); using (MySqlDataReader reader = ExecuteDataReader("vehicleusers_Retrieve", CreateParameter("UserId_", MySqlDbType.Int32, -1))) { while (reader.Read()) { VehicleUsersMaster obj = new VehicleUsersMaster(); obj.CityId = Convert.ToInt32(reader["CityId"]); obj.StateId = Convert.ToInt32(reader["CityId"]); obj.CountryId = Convert.ToInt32(reader["CountryId"]); obj.DistrictId = Convert.ToInt32(reader["DistrictId"]); obj.UserId = Convert.ToInt32(reader["UserId"]); obj.UserName = reader["UserName"].ToString(); obj.FullName = reader["FullName"].ToString(); obj.PhoneNo = reader["PhoneNo"].ToString(); obj.EmailId = reader["EmailId"].ToString(); obj.AdhaarNo = reader["AdhaarNo"].ToString(); //obj.EmergencyContactName = reader["EmergencyContactName"].ToString(); //obj.EmergencyContactNo = reader["EmergencyContactNo"].ToString(); obj.Address = reader["Address"].ToString(); obj.VoterId = reader["VoterId"].ToString(); obj.DLNo = reader["DLNo"].ToString(); obj.DLExpiryDate = Convert.ToDateTime(reader["DLExpiryDate"]); obj.CreatedDate = Convert.ToDateTime(reader["CreatedDate"]); obj.IsActive = Convert.ToBoolean(reader["IsActive"]); listvehicleusers.Add(obj); } } return(listvehicleusers); }