public CActAdd ActAddEvent(int actID, int memberID)
{
var loginMember = db.tMember.Where(t => t.f會員編號 == memberID).FirstOrDefault();
string[] blackList = { };
if (!string.IsNullOrEmpty(loginMember.f會員黑名單))
{
blackList = loginMember.f會員黑名單.Split(',');
}
var targetAct = db.tActivity.Where(t => t.f活動編號 == actID).FirstOrDefault();
string[] attendGuysID = { };
tMember[] attendGuys = { };
if (!string.IsNullOrEmpty(targetAct.f活動參加的會員編號))
{
attendGuysID = targetAct.f活動參加的會員編號.Split(',');
attendGuys = new tMember[attendGuysID.Length];
for (int i = 0; i < attendGuys.Length; i++)
{
if (string.IsNullOrEmpty(attendGuysID[i]))
{
continue;
}
int temp = Convert.ToInt32(attendGuysID[i]);
attendGuys[i] = db.tMember.Where(t => t.f會員編號 == temp).FirstOrDefault();
}
}
string[] wantGuysID = { };
tMember[] wantGuys = { };
if (!string.IsNullOrEmpty(targetAct.f活動審核名單))
{
wantGuysID = targetAct.f活動審核名單.Split(',');
wantGuys = new tMember[wantGuysID.Length];
for (int i = 0; i < wantGuys.Length; i++)
{
if (string.IsNullOrEmpty(wantGuysID[i]))
{
continue;
}
int temp = Convert.ToInt32(wantGuysID[i]);
wantGuys[i] = db.tMember.Where(t => t.f會員編號 == temp).FirstOrDefault();
}
}
CActAdd result = new CActAdd();
result.TargetAct = targetAct;
result.AttendGuys = attendGuys;
result.BlackList = blackList;
result.WantGuys = wantGuys;
return(result);
}
public ActionResult e修改(int?id)
{
if (id == null)
{
RedirectToAction("List");
}
dbJoutaEntities db = new dbJoutaEntities();
tMember x = new tMember();
x = db.tMember.FirstOrDefault(m => m.f會員編號 == id);
return(View(x));
}
protected void btnUpDate_Click(object sender, EventArgs e)
{
tMember x = db.tMember.First(t => t.fIdMember == id);
x.fAddress = txtAddress.Text;
x.fEmail = txtEmail.Text;
x.fPhone = txtPhone.Text;
x.fName = txtName.Text;
//更新
db.SubmitChanges();
lblMsg.Text = "更新資料成功";
lblMsg.Visible = true;
Response.Redirect("memberCenter_New.aspx?tab=1&success=1");
}
// GET: tMembers/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tMember tMember = db.tMembers.Find(id);
if (tMember == null)
{
return(HttpNotFound());
}
return(View(tMember));
}
// GET: Admin/tMembers/Edit/5
public ActionResult Edit(string id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
tMember tMember = db.tMember.Find(id);
if (tMember == null)
{
return(HttpNotFound());
}
return(View(tMember));
}
public ActionResult Add(tActivity p)
{
tMember Member = (tMember)Session["member"];
//判別登入會員其活動時段是否已占用
var NowMember = db.tMember.Where(t => t.f會員編號 == Member.f會員編號).FirstOrDefault();
if (!string.IsNullOrEmpty(NowMember.f會員已占用時間))
{
string[] usedTime = NowMember.f會員已占用時間.Split(',');
string[] used;
foreach (var item in usedTime)
{
if (!string.IsNullOrEmpty(item))
{
used = item.Split('~'); //used[0] 已佔用的開始時間，used[1] 已佔用的結束時間
if (string.Compare(p.f活動開始時間, used[1]) > 0 || string.Compare(used[0], p.f活動結束時間) > 0)
{
}
else
{
return(RedirectToAction("EatIndex", "Eat", new { msg = "錯誤! 新增的活動與既有活動時間相衝" }));
}
}
}
}
//添加占用時間
NowMember.f會員已占用時間 += "," + p.f活動開始時間 + "~" + p.f活動結束時間;
p.f會員編號 = Member.f會員編號;
p.f活動類型 = "飯局";
p.f活動參加的會員編號 = "," + Member.f會員編號;
db.tActivity.Add(p);
db.SaveChanges();
int ID = db.tActivity.Where(t => t.f會員編號 == Member.f會員編號)
.OrderByDescending(t => t.f活動發起日期).Select(t => t.f活動編號).FirstOrDefault();
NowMember.f會員發起的活動編號 += "," + ID;
NowMember.f會員參加的活動編號 += "," + ID;
HttpPostedFileBase PicFile = Request.Files["PicFile"];
if (PicFile != null)
{
var NewFileName = Guid.NewGuid() + Path.GetExtension(PicFile.FileName);
var NewFilePath = Path.Combine(Server.MapPath("~/Content/images/"), NewFileName);
PicFile.SaveAs(NewFilePath);
p.f活動團圖 = NewFileName;
}
db.SaveChanges();
return(RedirectToAction("EatIndex"));
}
public ActionResult Signup(tMember items)
{
FitnessEntities db = new FitnessEntities();
items.fMember_time = DateTime.Now + TimeSpan.FromMinutes(10);
string number = randnum();
items.fMember_Num = number;
CSendEmail.sendemail(new string[] { items.fMemberEmail }, CSendEmail.getnum(number));
items.fMemberPicture = "https://cdn4.iconfinder.com/data/icons/small-n-flat/24/user-group-512.png";
db.tMember.Add(items);
db.SaveChanges();
return(RedirectToAction("../Fitness/Index"));
}
protected void picUpload_Click(object sender, EventArgs e)
{
Boolean fileOk = false;
String fileExtension = System.IO.Path.GetExtension(picUpload.FileName).ToLower();
//指定檔路徑，pic是專案下的一個資料夾；～表示當前網頁所在的資料夾
String path = Server.MapPath("~/img/upp/");//物理檔路徑
//檔上傳控制項中如果已經包含檔
if (picUpload.HasFile)
{
//得到檔的尾碼
//允許檔的尾碼
String[] allowedExtensions = { ".gif", ".png", ".jpeg", ".jpg", ".bmp" };
//看包含的檔是否是被允許的檔的尾碼
for (int i = 0; i < allowedExtensions.Length; i++)
{
if (fileExtension == allowedExtensions[i])
{
fileOk = true;
}
}
}
if (fileOk)
{
try
{ //檔另存在伺服器的指定目錄下
string photoName = Guid.NewGuid().ToString() + fileExtension;
picUpload.PostedFile.SaveAs(path + photoName);
Response.Write("<script>alert('檔上傳成功！');</script>");
tMember x = db.tMember.First(t => t.fIdMember == id);
x.fPhoto = photoName;
db.SubmitChanges();
imgPic2.ImageUrl = imgURL + x.fPhoto;
imgPic.ImageUrl = imgURL + x.fPhoto;
}
catch
{
Response.Write("<script>alert('檔上傳失敗！');</script>");
}
}
else
{
Response.Write("<script>alert('只能上傳gif,png,jpeg,jpg,bmp圖像檔！');</script>");
}
}
protected void Page_Load(object sender, EventArgs e)
{
tMember mb = Session[CDKey.LOGINUSER] as tMember;
if (mb != null)
{
if (mb.fIdentity == 1)
{
Label1.Text = "新人才能報價";
Label1.Visible = true;
Button1.Enabled = false;
}
}
processPageAsk(Label2);
}
public ActionResult Save()
{
tMember y = (tMember)Session["member"];
var x = db.tMember.Where(a => a.f會員編號 == y.f會員編號).FirstOrDefault();
x.f會員名稱 = Request.Form["txtName"];
x.f會員暱稱 = Request.Form["txtNickName"];
x.f會員生日 = Request.Form["txtBirth"];
x.f會員興趣 = Request.Form["txtHobby"];
x.f會員自我介紹 = Request.Form["txtIntro"];
db.SaveChanges();
ViewBag.msg = "資料修改成功";
return(RedirectToAction("ProfileIndex"));
}
//註冊新會員
public void Register(CRegisterModel newMember)
{
//sql新增 isAdmin預設為0
tMember t = new tMember();
t.f會員電子郵件 = newMember.txtEmail;
t.f會員帳號 = newMember.txtEmail;
t.f會員名稱 = newMember.txtNickname;
t.f會員密碼 = newMember.txtPassword;
t.f驗證碼 = newMember.fActivationCode;
t.isAdmin = false;
db.tMember.Add(t);
db.SaveChanges();
}
public ActionResult Edit([Bind(Include = "Id,password")] tMember tMember)
{
if (ModelState.IsValid)
{
#region 密碼加密
tMember.memguid = db.tMember.Where(m => m.Id == tMember.Id).Select(m => m.memguid).FirstOrDefault();
tMember = EditHashPasword(tMember);
#endregion
db.Entry(tMember).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(tMember));
}
//信箱驗證碼驗證
public string emailValidation(string email, string authCode)
{
CRegisterModel c = getAccount(email);
//宣告驗證後訊息字串
string validationStr = string.Empty;
if (c != null)
{
dbJoutaEntities db = new dbJoutaEntities();
tMember t = db.tMember.FirstOrDefault(k => k.f會員電子郵件 == email && k.f驗證碼 == authCode);
t.f驗證碼 = "";
validationStr = "信箱驗證成功，現在可以登入囉~";
}
return(validationStr);
}
public void ProcessLetterMsg(tMember member, HttpContext context, int page)
{
List <string> strSender = new List <string>();
string strMsg = "";
var table = from t in db.tLetter
where t.fIdReceiver == member.fIdMember && t.fLetterOrChat == 1
orderby t.fSendTime descending
select t;
int countPage = 0;
foreach (var s in table)
{
countPage++;
}
countPage = (countPage % 10 == 0 ? countPage / 10 : (countPage / 10) + 1);
int i = 0;
foreach (tLetter l in table.Skip((page - 1) * 10).Take(10))
{
var sender = from g in db.tMember
where g.fIdMember == l.fIdSender
select g;
foreach (tMember s in sender)
{
strSender.Add(s.fName);
}
strMsg += "<div class='row'><div class=\"span8 colinoutbolder\">" +
"<div class=\"msgtitle\">" +
"<h4>來自" + strSender[i] + "的站內信" + "<a href='#' data-letterid='" + l.fIdILetter + "' class='pull-left btn btn-danger colinletterdel'>刪除</a>" +
"<div class=\"pull-right\">" + l.fSendTime + "</div>" + ((l.fIsRead == true) ? "" : "<span class='badge pull-right'>新</span>") +
"</h4>" +
"</div>" +
"<div class=\"msgcontent\">" + l.fContent +
"</div>" +
"</div></div>";
i++;
}
strMsg += "<div class='row' style='text-align:center;'><div class='pagination pagination-centered paginationletter'><ul>";
for (int g = 1; g <= countPage; g++)
{
strMsg += "<li" + (g == page ? " class='active'" : "") + "><a href='#'>" + g + "</a></li>";
}
strMsg += "</ul></div></div>";
context.Response.Write(strMsg);
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
lblMessage.Visible = false;
tMember mb = Session[CDKey.LOGINUSER] as tMember;
if (mb == null)
{
lblTitle.Visible = true;
lblTitle.Text = "<div class='span3' style='border-radius:25px;background-color:red;margin:0 42%;text-align:center;color:white;'>登入即可發起討論</div>";
FormView1.Visible = false;
}
processPageforum(Label2);
}
}
protected void Button1_Click(object sender, EventArgs e)
{
tMember mb = Session[CDKey.LOGINUSER] as tMember;
tAskPrice a = new tAskPrice();
a.fContent = "需求地點:" + ((Master.FindControl("ContentPlaceHolder1").FindControl("space") as HtmlSelect).Value == "0" ?"不拘": (Master.FindControl("ContentPlaceHolder1").FindControl("space") as HtmlSelect).Value) + "<br/>" + Request.Form["descri"].Replace("\r\n", "<br/>");
a.fIdMember = mb.fIdMember;
a.fTitle = "找" + Request.Form["date"] + (Master.FindControl("ContentPlaceHolder1").FindControl("servies") as HtmlSelect).Value;
a.fWantDay = Convert.ToDateTime(Request.Form["date"]);
a.fSendTime = DateTime.Now;
db.tAskPrice.InsertOnSubmit(a);
db.SubmitChanges();
Response.Redirect("AskPrice.aspx");
}
public static result check_register(string user, string name, string email, string pw, int sex, string phone, string birth, string add, string country, string countryname, string district, string districtname)
{
CNManagerDataContext db = new CNManagerDataContext();
clsProcess cl = new clsProcess();
var r = new result();
try
{
var mb = new tMember();
mb.Username = user.Trim();
mb.MemberCode = "MB" + DateTime.Now.ToString("ddMMyyyyHHmmss");
mb.MemberName = name.Trim();
mb.Email = email.Trim().ToLower();
mb.Password = cl.MaHoa(pw.Trim());
mb.Sex = sex == 1 ? true : false;
mb.Phone = phone.Trim();
if (birth.Trim() != "")
{
mb.Birthday = DateTime.Parse(cl.returnDatetime(birth.Trim()));
}
mb.Address = add.Trim();
if (country != "")
{
mb.CountryId = int.Parse(country.Trim());
mb.CountryName = countryname;
}
if (district != "")
{
mb.DistrictId = int.Parse(district.Trim());
mb.DistrictName = districtname;
}
mb.BranchTypeId = branchTypeId;
mb.Status = 1;
mb.JoinCreateAt = DateTime.Now;
mb.CreateAt = DateTime.Now;
db.tMembers.InsertOnSubmit(mb);
db.SubmitChanges();
r._mess = "Đăng kí tài khoản thành công";
r._content = "ok";
}
catch (Exception ax)
{
r._content = "err";
r._mess = ax.Message;
}
return(r);
}
public ActionResult Register(tMember pMember)
{
if (ModelState.IsValid == false)
{
return(View());
}
var member = db.tMember
.Where(m => m.fUserId == pMember.fUserId)
.FirstOrDefault();
if (member == null)
{
//string strConnString = ConfigurationManager.ConnectionStrings["connect"].ConnectionString;
//string com_str = $"INSERT INTO [dbo].[tMember] ([fUserId], [fPwd], [fName], [fEmail]) VALUES (@fUserId, @fPwd, @fName, @fEmail);";
//using (SqlConnection con = new SqlConnection(strConnString))
//{
// SqlCommand scom = new SqlCommand(com_str, con);
// scom.Parameters.AddWithValue("@fUserId", pMember.fUserId);
// scom.Parameters.AddWithValue("@fPwd", pMember.fPwd);
// scom.Parameters.AddWithValue("@fName", pMember.fName);
// scom.Parameters.AddWithValue("@fEmail", pMember.fEmail);
// try
// {
// con.Open();
// scom.ExecuteNonQuery();
// }
// catch (Exception ex)
// {
// Console.WriteLine(ex.Message);
// }
// finally
// {
// con.Close();
// }
//}
db.tMember.Add(pMember);
db.SaveChanges();
return(RedirectToAction("Login"));
}
ViewBag.Message = "此帳號已有人使用";
return(View(0));
}
public ActionResult UploadImg(tMember t)
{
dbJoutaEntities db = new dbJoutaEntities();
var x = db.tMember.Where(a => a.f會員編號 == t.f會員編號).FirstOrDefault();
HttpPostedFileBase avaPhoto = Request.Files["f會員大頭貼"];
if (avaPhoto != null)
{
string photName = Guid.NewGuid().ToString() + Path.GetExtension(avaPhoto.FileName);
var path = Path.Combine(Server.MapPath("~/Content/images/"), photName);
avaPhoto.SaveAs(path);
x.f會員大頭貼 = photName;
}
db.SaveChanges();
return(RedirectToAction("ProfileIndex"));
}
public ActionResult Register(tMember pMember)
{
if (ModelState.IsValid == false)
{
return(View());
}
var member = db.tMember.Where(m => m.fUserId == pMember.fUserId).FirstOrDefault();
if (member == null)
{
db.tMember.Add(pMember);
db.SaveChanges();
return(RedirectToAction("Login"));
}
ViewBag.Message = "此帳號已有人使用，註冊失敗";
return(View());
}
//取得公開資料
public CRegisterModel getAccount_openSource(string email)
{
CRegisterModel c = new CRegisterModel();
tMember t = db.tMember.FirstOrDefault(k => k.f會員電子郵件 == email);
try
{
c.txtEmail = t.f會員電子郵件;
c.txtNickname = t.f會員名稱;
}
catch (Exception)
{
//查無資料
c = null;
}
return(c);
}
protected void FormView1_ItemInserting(object sender, FormViewInsertEventArgs e)
{
if (Request.Form["msg"].Length > 0)
{
tMember mb = Session[CDKey.LOGINUSER] as tMember;
e.Values["fIdTitle"] = Convert.ToInt32(Request["fIdTitle"]);
e.Values["fIdMember"] = mb.fIdMember;
e.Values["fSendTime"] = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
e.Values["fContent"] = Request.Form["msg"];
}
else
{
lblMsg.Visible = true;
lblMsg.Text = "<div class='span2' style='border-radius:25px;background-color:red;margin:0 42%;text-align:center;color:white;'>留言必須填寫</div>";
e.Cancel = true;
}
}
public ActionResult Register(CMember input)//此處更新
{
if (ModelState.IsValid == false)
{
return(View());
}
var member = db.tMember.Where(p => p.fAccount == input.fAccount).FirstOrDefault();
if (member == null)
{
int index = input.myImage.FileName.IndexOf(".");
string extention = input.myImage.FileName.Substring(index, input.myImage.FileName.Length - index);
string photoName = Guid.NewGuid().ToString() + extention;
input.fImage = "../Content/" + photoName;
input.myImage.SaveAs(Server.MapPath("../Content/") + photoName);
//此處新增---------------------------
tMember t = new tMember();
t.fMemberId = input.fMemberId;
t.fMemberName = input.fMemberName;
t.fAccount = input.fAccount;
t.fPassword = input.fPassword;
t.fEmail = input.fEmail;
t.fRoomId = input.fRoomId;
t.fPhone = input.fPhone;
t.fAge = input.fAge;
t.fSex = input.fSex;
t.fBirthDate = input.fBirthDate;
t.fSalary = input.fSalary;
t.fCareer = input.fCareer;
t.fImage = input.fImage;
t.fLeave = input.fLeave;
t.fRole = input.fRole;
t.fActivityMessage = input.fActivityMessage;
t.fActivityEmail = input.fActivityEmail;
//----------------------------------
db.tMember.Add(t);
db.SaveChanges();
return(RedirectToAction("LogIn"));
}
ViewBag.Message = "此帳號已有人使用，請輸入新的帳號";
return(View());
}
public bool insertMember(string name, string birthday, string sex, string phone, string add, string email, string note, int branchtype, out string mess)
{
mess = "";
bool ok = false;
try
{
var checkPhone = from x in db.tMembers where x.BranchTypeId == branchtype && x.Phone == phone.Trim() select x;
if (checkPhone.Count() > 0)
{
ok = false;
mess = "Đã tồn tại số điện thoại " + phone.Trim();
}
else
{
var u = new tMember();
u.MemberCode = phone.Replace(" ", "");
u.MemberName = name;
u.Phone = phone;
u.Password = cls.Encrypt(phone.Trim().Replace(" ", ""));
u.Email = email.Trim();
u.Address = add;
u.Note = note;
u.Sex = sex == "1";
if (birthday != "")
{
u.Birthday = DateTime.Parse(cls.returnDatetime(birthday));
}
u.BranchTypeId = branchtype;
u.CreateAt = DateTime.Now;
u.JoinCreateAt = DateTime.Now;
u.Status = 1;
u.CreateBy = WindowsFormsApplication3.Form1.user_id;
db.tMembers.InsertOnSubmit(u);
db.SubmitChanges();
ok = true;
}
}
catch (Exception ax)
{
ok = false;
mess = ax.Message;
}
return(ok);
}
public ActionResult ShopCart(tMember member)
{
if (Session["Member"] == null)
{
return(RedirectToAction("Login"));
}
string userName = (Session["Member"] as tMember).userName;
var orderDetails = db.tOrderDetails.Where(m => m.userName == userName && m.isApprove == "否").ToList();
var buyAmount = db.tOrderDetails.Where(m => m.isApprove == "否" && m.userName == userName).ToList();
foreach (var item in buyAmount)
{
total += (int)item.pQty;
}
Session["Total"] = total;
return(View("ShopCart", "_LayoutContent", orderDetails));
}
//更改密碼
public string ChangePassword(string email, string password, string newPassword)
{
CRegisterModel p = getAccount(email);
//確認舊密碼的正確性
if (passwordCheck(p, password))
{
p.txtPassword = newPassword;
tMember t = db.tMember.FirstOrDefault(k => k.f會員密碼 == p.txtPassword);
db.tMember.Add(t);
db.SaveChanges();
return("密碼修改成功");
}
else
{
return("原密碼輸入錯誤");
}
}
public ActionResult d刪除(int?id)
{
if (id == null)
{
RedirectToAction("List");
}
tMember x = new tMember();
dbJoutaEntities db = new dbJoutaEntities();
var y = db.tActivity.Where(m => m.f會員編號 == id).ToList();
db.tActivity.RemoveRange(y);
x = db.tMember.FirstOrDefault(m => m.f會員編號 == id);
db.tMember.Remove(x);
db.SaveChanges();
return(RedirectToAction("List"));
}
protected void Page_Load(object sender, EventArgs e)
{
tMember mb = Session[CDKey.LOGINUSER] as tMember;
if (Page.IsPostBack == false)
{
var in3Services = from c in db.tCalendar
join s in db.tServices on c.fIdServices equals s.fIdServices
where c.fIdMember == id && c.fDate < DateTime.Now.Date
select new
{
finName = s.fName,
finDate = c.fDate.Value.Month.ToString() + "月" + c.fDate.Value.Day.ToString() + "日",
fidSer = s.fIdServices
};
DllOverTime.DataSource = in3Services;
DllOverTime.DataBind();
var disc = (from d in db.tDiscussion
where d.fIdMember == id
orderby d.fSendTime descending
select new
{
ftitle = d.fTitle,
ftime = d.fSendTime
}).Take(3);
DLDis.DataSource = disc;
DLDis.DataBind();
var discR = (from r in db.tDiscussionReply
join d in db.tDiscussion on r.tMember equals d.tMember
where r.fIdMember == id
orderby r.fSendTime descending
select new
{
ftitle = d.fTitle,
ftime = r.fSendTime
}).Take(3);
DLDisR.DataSource = discR;
DLDisR.DataBind();
}
}
protected void btnUpDate_Click(object sender, ImageClickEventArgs e)
{
tStores x = db.tStores.FirstOrDefault(t => t.fIdStores == id);
tMember x2 = db.tMember.First(t => t.fIdMember == id);
if (x2 != null && x != null)
{
x2.fAddress = txtAddress.Text;
x2.fEmail = txtEmail.Text;
x2.fPhone = txtPhone.Text;
x2.fName = txtStore.Text;
x.fDescription = txtDescription.Text;
x.fMobilePhone = txtMobilePhone.Text;
db.SubmitChanges();
Response.Write("<script>alert('更新成功');</script>");
}
}
public string GetDateLimit(int act_id)
{
if (Session["member"] != null)
{
tMember loginMember = (tMember)Session["member"];
var realMember = db.tMember.Where(t => t.f會員編號 == loginMember.f會員編號).FirstOrDefault();
if (!string.IsNullOrEmpty(realMember.f會員已占用時間))
{
string[] timeList = realMember.f會員已占用時間.Split(',');
//act_id!=0，表示是編輯模式，要先移除該筆活動的占用時間才符合時間限制條件
if (act_id != 0)
{
var targetAct = db.tActivity.Where(t => t.f活動編號 == act_id).FirstOrDefault();
timeList = timeList.Where(t => t != targetAct.f活動開始時間 + "~" + targetAct.f活動結束時間).ToArray();
}
//若無，則為一般開團，直接回傳已佔用的時間陣列
//string totalTime = "[";
string totalTime = "";
foreach (string item in timeList)
{
if (string.IsNullOrEmpty(item))
{
continue;
}
string[] timeRange = item.Split('~');
double limit = Convert.ToInt32((Convert.ToDateTime(timeRange[1]) - Convert.ToDateTime(timeRange[0]))
.ToString("dd"));
for (double i = 0.0; i <= limit; i++)
{
totalTime += Convert.ToDateTime(timeRange[0]).AddDays(i).ToString("yyyy-MM-dd") + ",";
}
}
if (totalTime.Length > 2)
{
totalTime = totalTime.Substring(0, totalTime.Length - 1);
}
//totalTime += "]";
return(totalTime);
}
}
return(null);
}
public long SaveMember(tMember tMember)
{
mmEntities.tMembers.AddOrUpdate(tMember);
mmEntities.SaveChanges();
return tMember.MemberId;
}
