public int Update(AboutTeam_Info data)
{
using (var db = new DBExecutor().GetDatabase())
{
return(db.Update(data));
}
}
public int Update(long AboutTeamId, AboutTeam_Info data, IEnumerable <string> columns)
{
using (var db = new DBExecutor().GetDatabase())
{
return(db.Update(data, AboutTeamId, columns));
}
}
public JsonResult SaveAboutTeam(AboutTeam_Info data)
{
//check is there are any data under the categoary.
ResultBase result = new ResultBase();
result.setMessage("Done");
if (data.IsActive == 1)
{
//審核專用
var verdata = AboutTeamMan.GetBySN(data.AboutTeamId);
verdata.IsActive = 1;
verdata.VerifiedDate = DateTime.Now;
AboutTeamMan.Update(verdata);
return(Json(result, JsonRequestBehavior.DenyGet));
}
else
{
//一但有任何異動，自動下架
data.IsActive = 0;
}
if (data.SortNum == null)
{
result.setErrorMessage("順序不得為空白");
}
if (string.IsNullOrEmpty(data.StrName))
{
result.setErrorMessage("職稱不得為空白");
}
if (string.IsNullOrEmpty(data.UserName))
{
result.setErrorMessage("姓名不得為空白");
}
if (result.JsonReturnCode > -1)
{
data.LastUpdate = DateTime.Now;
data.LastUpdator = sessionData.trading.LoginId;
if (data.AboutTeamId > 0)
{
var olddata = AboutTeamMan.GetBySN(data.AboutTeamId);
checkUploadfilesTeam(data, olddata);
AboutTeamMan.Update(data);
}
else
{
checkUploadfilesTeam(data, new AboutTeam_Info()
{
});
AboutTeamMan.Insert(data);
}
}
return(Json(result, JsonRequestBehavior.DenyGet));
}
public long Insert(AboutTeam_Info data)
{
using (var db = new DBExecutor().GetDatabase())
{
long NewID = 0;
var result = db.Insert(data);
if (result != null)
{
long.TryParse(result.ToString(), out NewID);
}
return(NewID);
}
}
public long Insert(AboutTeam_Info data)
{
long newID = 0;
try
{
newID = new AboutTeam_Repo().Insert(data);
}
catch (Exception ex)
{
log.Exception(ex);
}
return(newID);
}
private void checkUploadfilesTeam(AboutTeam_Info NewData, AboutTeam_Info OldData)
{
string Prefix = string.Empty;
Prefix = "TeamPhoto1";
if (sessionData.trading.UploadFiles.Keys.Contains(Prefix))
{
if (string.Compare("DELETE", sessionData.trading.UploadFiles[Prefix], true) == 0)
{
NewData.Photo1 = string.Empty;
}
else
{
NewData.Photo1 = CopyFile(sessionData.trading.UploadFiles[Prefix]);
}
}
else
{
NewData.Photo1 = OldData.Photo1;
}
Prefix = "TeamPhoto2";
if (sessionData.trading.UploadFiles.Keys.Contains(Prefix))
{
if (string.Compare("DELETE", sessionData.trading.UploadFiles[Prefix], true) == 0)
{
NewData.Photo2 = string.Empty;
}
else
{
NewData.Photo2 = CopyFile(sessionData.trading.UploadFiles[Prefix]);
}
}
else
{
NewData.Photo2 = OldData.Photo2;
}
}
public bool Update(AboutTeam_Info data)
{
return(new AboutTeam_Repo().Update(data) > 0);
}
public bool Update(long AboutTeamId, AboutTeam_Info data, IEnumerable <string> columns)
{
return(new AboutTeam_Repo().Update(AboutTeamId, data, columns) > 0);
}
