public MemberView CdRegisterfun(CdMember CdRegisterdata)
{
string validate = "小孩姓名重複";
var CountCdData = db.CdMember.Where(x => x.Account == CdRegisterdata.Account);
if (CountCdData.Count() < 5)
{
if (CountCdData.Where(x => x.CdName == CdRegisterdata.CdName).Count() == 0) //找尋同帳號內是否有重複的CdName
{
CdRegisterdata.Imageurl = ""; //預設給IMG URL 空字串
db.CdMember.Add(CdRegisterdata);
db.SaveChanges();
validate = "新增成功";
}
}
else
{
validate = "已達新增上限";
}
memberview.Account = CdRegisterdata.Account;
memberview.CdName = CdRegisterdata.CdName;
memberview.result = validate;
return(memberview);
}
public string EdlitCdPersonalPage(CdMember data)
{
using (SqlConnection conn = new SqlConnection("Server=163.17.135.185;DataBase=MemAnalyze;User Id=sa;Password=ftpms.2015"))
{
SqlCommand cmd = new SqlCommand();//設定語法與內容
cmd.CommandText = "update CdMember Set Birthday=@birthday,Gender=@gender where Account=@acc and CdName=@cdname";
cmd.Connection = conn;
cmd.Parameters.AddWithValue("@birthday", data.Birthday);//一一將參數帶入
cmd.Parameters.AddWithValue("@gender", data.Gender);
cmd.Parameters.AddWithValue("@acc", data.Account);
cmd.Parameters.AddWithValue("@cdname", data.CdName);
conn.Open();//連接開啟
try
{
cmd.ExecuteNonQuery();
}
catch (Exception ex)
{
return(ex.ToString());
}
conn.Close();
}
return("success");
}
public MemberView CdRegister(CdMember CdRegisterdata)
{
memberview = memberservice.CdRegisterfun(CdRegisterdata);
return(memberview);
}
public DataTable CdPersonalPage(CdMember data)
{
return(memberservice.ShowCdPersonalPage(data.Account, data.CdName));
}
