public void InsertMembersInfo(MembersInfo membersInfo)
{
string query = @"insert into MembersInfo(MCnic , MName , MAddress , MPhone ) values(@MCnic , @MName , @MAddress , @MPhone)";
SqlCommand sqlCommand = new SqlCommand(query, GetConnToLocalDb());
SqlParameter sqlParameter = new SqlParameter
{
ParameterName = "MCnic",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = membersInfo.MCnic
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "MName",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = membersInfo.MName
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "MAddress",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = membersInfo.MAddress
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "MPhone",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = membersInfo.MPhone
};
sqlCommand.Parameters.Add(sqlParameter);
sqlCommand.ExecuteNonQuery();
}
public MembersInfo GetMembersInfo(string MPhone, string MName)
{
SQLConn sQLConn = new SQLConn();
string query = @"select * from membersinfo where MPhone = @MPhone and MName = @MName";
SqlCommand sqlCommand = new SqlCommand(query, sQLConn.GetConnToLocalDb());
SqlParameter sqlParameter = new SqlParameter
{
ParameterName = "MPhone",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = MPhone
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "MName",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = MName
};
sqlCommand.Parameters.Add(sqlParameter);
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
if (sqlDataReader.Read())
{
MembersInfo membersInfo = new MembersInfo
{
MCnic = sqlDataReader[0].ToString(),
MName = sqlDataReader[1].ToString(),
MAddress = sqlDataReader[2].ToString(),
MPhone = sqlDataReader[3].ToString()
};
return(membersInfo);
}
return(null);
}
public void UpdateMembersInfo(MembersInfo membersInfo, string CName, string CPhone)
{
string query = @"update MembersInfo set MCnic=@MCnic , MName=@MName , MAddress=@MAddress , MPhone=@MPhone Where MPhone = @CPhone and MName = @CName";
SqlCommand sqlCommand = new SqlCommand(query, GetConnToLocalDb());
SqlParameter sqlParameter = new SqlParameter
{
ParameterName = "CPhone",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = CPhone
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "CName",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = CName
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "MCnic",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = membersInfo.MCnic
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "MName",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = membersInfo.MName
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "MAddress",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = membersInfo.MAddress
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "MPhone",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = membersInfo.MPhone
};
sqlCommand.Parameters.Add(sqlParameter);
sqlCommand.ExecuteNonQuery();
}