public void InsertLuckyMemberInfo(LukyMembersInfo lukyMembersInfo)
{
SQLConn sQLConn = new SQLConn();
string query = @"insert into LuckyMemberInfo(MPhone , MName , SEngineNo ,LDate )
values(@MPhone , @MName , @SEngineNo , @LDate)";
SqlCommand sqlCommand = new SqlCommand(query, sQLConn.GetConnToLocalDb());
SqlParameter sqlParameter = new SqlParameter
{
ParameterName = "MPhone",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = lukyMembersInfo.MPhone
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "MName",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = lukyMembersInfo.MName
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "SEngineNo",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = lukyMembersInfo.SEngineNo
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "LDate",
SqlDbType = System.Data.SqlDbType.Date,
Value = lukyMembersInfo.LDate
};
sqlCommand.Parameters.Add(sqlParameter);
sqlCommand.ExecuteNonQuery();
}
public LukyMembersInfo GetLuckyMemberInfo(string CSEngine, string CMPhone)
{
SQLConn sQLConn = new SQLConn();
string query = @"select * from luckymemberinfo where MPhone = @CMPhone and SEngine = @ESEngine";
SqlCommand sqlCommand = new SqlCommand(query, sQLConn.GetConnToLocalDb());
SqlParameter sqlParameter = new SqlParameter
{
ParameterName = "CMPhone",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = MPhone
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "CSEngineNo",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = MName
};
sqlCommand.Parameters.Add(sqlParameter);
SqlDataReader sqlDataReader = sqlCommand.ExecuteReader();
if (sqlDataReader.Read())
{
LukyMembersInfo luckyMembersInfo = new LukyMembersInfo
{
MName = sqlDataReader[0].ToString(),
MPhone = sqlDataReader[1].ToString(),
SEngineNo = sqlDataReader[2].ToString(),
LDate = DateTime.Parse(sqlDataReader[4].ToString())
};
return(luckyMembersInfo);
}
return(null);
}
public void UpdateLuckyMemberInfo(LukyMembersInfo lukyMembersInfo, string CSEngine, string CMPhone)
{
SQLConn sQLConn = new SQLConn();
string query = @"Update LuckyMemberInfo set
MPhone = @MPhone , MName = @MName , SEngineNo = @SEngineNo
,LDate = @LDate
where Mphone = @CMPhone and SEngineNo = @CSEngine";
SqlCommand sqlCommand = new SqlCommand(query, sQLConn.GetConnToLocalDb());
SqlParameter sqlParameter = new SqlParameter
{
ParameterName = "MPhone",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = lukyMembersInfo.MPhone
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "MName",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = lukyMembersInfo.MName
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "SEngineNo",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = lukyMembersInfo.SEngineNo
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "LDate",
SqlDbType = System.Data.SqlDbType.Date,
Value = lukyMembersInfo.LDate
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "CSEngineNo",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = CSEngine
};
sqlCommand.Parameters.Add(sqlParameter);
sqlParameter = new SqlParameter
{
ParameterName = "CMPhone",
SqlDbType = System.Data.SqlDbType.NVarChar,
Value = CMPhone
};
sqlCommand.Parameters.Add(sqlParameter);
sqlCommand.ExecuteNonQuery();
}
