public userregistration SelectById(Int64 uid) { SqlDataAdapter da; DataSet ds = new DataSet(); userregistration objuserregistration = new userregistration(); try { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "userregistration_SelectById"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = ConnectionString; cmd.Parameters.AddWithValue("@uid", uid); ConnectionString.Open(); da = new SqlDataAdapter(cmd); da.Fill(ds); if (ds != null) { if (ds.Tables.Count > 0) { if (ds.Tables[0] != null) { if (ds.Tables[0].Rows.Count > 0) { { objuserregistration.uid = Convert.ToInt64(ds.Tables[0].Rows[0]["uid"]); objuserregistration.fname = Convert.ToString(ds.Tables[0].Rows[0]["fname"]); objuserregistration.mname = Convert.ToString(ds.Tables[0].Rows[0]["mname"]); objuserregistration.lname = Convert.ToString(ds.Tables[0].Rows[0]["lname"]); objuserregistration.email = Convert.ToString(ds.Tables[0].Rows[0]["email"]); objuserregistration.phone = Convert.ToString(ds.Tables[0].Rows[0]["phone"]); objuserregistration.password = Convert.ToString(ds.Tables[0].Rows[0]["password"]); objuserregistration.dob = Convert.ToString(ds.Tables[0].Rows[0]["dob"]); objuserregistration.address1 = Convert.ToString(ds.Tables[0].Rows[0]["address1"]); objuserregistration.address2 = Convert.ToString(ds.Tables[0].Rows[0]["address2"]); objuserregistration.isguest = string.IsNullOrEmpty(ds.Tables[0].Rows[0]["isguest"].ToString()) ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["isguest"]); objuserregistration.registrationdate = Convert.ToString(ds.Tables[0].Rows[0]["registrationdate"]); objuserregistration.uguid = Convert.ToString(ds.Tables[0].Rows[0]["uguid"]); objuserregistration.isactive = string.IsNullOrEmpty(ds.Tables[0].Rows[0]["isactive"].ToString()) ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["isactive"]); objuserregistration.isdelete = string.IsNullOrEmpty(ds.Tables[0].Rows[0]["isdelete"].ToString()) ? false : Convert.ToBoolean(ds.Tables[0].Rows[0]["isdelete"]); } } } } } } catch (Exception ex) { ErrHandler.writeError(ex.Message, ex.StackTrace); return(null); } finally { ConnectionString.Close(); } return(objuserregistration); }
public Int64 Update(userregistration objuserregistration) { Int64 result = 0; try { SqlCommand cmd = new SqlCommand(); cmd.CommandText = "userregistration_Update"; cmd.CommandType = CommandType.StoredProcedure; cmd.Connection = ConnectionString; SqlParameter param = new SqlParameter(); param.ParameterName = "@uid"; param.Value = objuserregistration.uid; param.SqlDbType = SqlDbType.BigInt; param.Direction = ParameterDirection.InputOutput; cmd.Parameters.Add(param); cmd.Parameters.AddWithValue("@fname", objuserregistration.fname); cmd.Parameters.AddWithValue("@mname", objuserregistration.mname); cmd.Parameters.AddWithValue("@lname", objuserregistration.lname); cmd.Parameters.AddWithValue("@email", objuserregistration.email); //cmd.Parameters.AddWithValue("@phone", objuserregistration.phone); //cmd.Parameters.AddWithValue("@password", objuserregistration.password); cmd.Parameters.AddWithValue("@dob", objuserregistration.dob); cmd.Parameters.AddWithValue("@address1", objuserregistration.address1); cmd.Parameters.AddWithValue("@address2", objuserregistration.address2); //cmd.Parameters.AddWithValue("@isguest", objuserregistration.isguest); //cmd.Parameters.AddWithValue("@registrationdate", objuserregistration.registrationdate); //cmd.Parameters.AddWithValue("@uguid", objuserregistration.uguid); cmd.Parameters.AddWithValue("@isactive", objuserregistration.isactive); cmd.Parameters.AddWithValue("@isdelete", objuserregistration.isdelete); ConnectionString.Open(); cmd.ExecuteNonQuery(); result = Convert.ToInt64(param.Value); } catch (Exception ex) { ErrHandler.writeError(ex.Message, ex.StackTrace); return(result); } finally { ConnectionString.Close(); } return(result); }