/// <summary>
/// Ta Account delete
/// 작성자 : 이승현
/// 작성일 : 2012-04-09
/// </summary>
/// <param name="gmktId">Gmarket ID</param>
/// <param name="site">export site</param>
/// <param name="siteLoginId">export site login id</param>
public void TaAccountDelete(string gmktId, string site, string siteLoginId)
{
TaInfo taInfo = new GEPMongoDacHelper("gep", "ta").FindOne<TaInfo>(Query.EQ("gmkt_id", gmktId));
TaAccounts delTaAccount = null;
if (taInfo == null) return; //TA계정이 존재하지 않음
if (taInfo.accounts == null)
{
return;
}
foreach (TaAccounts taAccount in taInfo.accounts)
{
if (taAccount.site == site && taAccount.site_login_id == siteLoginId)
{
//taInfo.accounts.Remove(taAccount);
delTaAccount = taAccount;
}
}
if (delTaAccount != null)
{
taInfo.accounts.Remove(delTaAccount);
}
new GEPMongoDacHelper("gep", "ta").Save<TaInfo>(taInfo);
}
/// <summary>
/// GEP상품 리스트 페이징
/// </summary>
/// <param name="page">페이지</param>
/// <param name="query">조건</param>
/// <returns>GepItemsData Class List</returns>
public MongoPagingResult<GepItemsData> List(int page, QueryComplete query)
{
SortByBuilder sort = SortBy.Descending("_id");
List<GepItemsData> List = new List<GepItemsData>();
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "gep_items");
return MongoHelper.FindByPaging<GepItemsData>(query, 10, (10 * (page - 1)), sort);
}
public void BookPaging(int page)
{
int take = 1;
int skip = page * take;
IMongoQuery query = Query.And(
//Query.GTE("_id",BsonObjectId.Create("4f6960fc49674e62601cb869")),
//Query.EQ("ag", 25)
Query.EQ("nm", "꽃미남4")
);
SortByBuilder sort = SortBy.Ascending("_id");
GEPMongoDacHelper dac = new GEPMongoDacHelper("test", "book");
MongoPagingResult<Book> result = dac.FindByPaging<Book>(query, take, skip, sort);
Trace.WriteLine(result.Count.ToString());
foreach (Book book in result.Result.ToList())
{
Trace.DumpBusinessEntity(book);
}
}
/// <summary>
/// Site, Ta별 환경설정 리스트
/// </summary>
/// <param name="siteId">사이트아이디</param>
/// <param name="taId">TA아이디</param>
/// <returns>List</returns>
public List<BsonDocument> SiteSettingList(string siteId, string taId)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "ta_site_setting_templete");
return MongoHelper.Find(Query.And(Query.EQ("ta_id", taId), Query.EQ("exportSite", siteId)));
}
/// <summary>
/// 환경설정 삭제
/// </summary>
/// <param name="id">환경설정 아이디</param>
/// <returns></returns>
public void Remove(ObjectId id)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "ta_site_setting_templete");
MongoHelper.Remove(Query.EQ("_id", id));
}
/// <summary>
/// GEP 상품 한건 보기
/// </summary>
/// <param name="id">아이디</param>
/// <returns></returns>
public GepItemsData View(long id)
{
List<GepItemsData> List = new List<GepItemsData>();
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "gep_items");
return MongoHelper.FindOne<GepItemsData>(Query.EQ("_id",id));
}
/// <summary>
/// GEP 상품 업데이트
/// </summary>
/// <param name="query">IMongoQuery</param>
/// <param name="update">IMongoUpdate</param>
public void Update(IMongoQuery query , IMongoUpdate update)
{
List<GepItemsData> List = new List<GepItemsData>();
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "gep_items");
MongoHelper.Save(query, update);
}
/// <summary>
/// Export 사이트 리스트
/// </summary>
/// <param name="site">소스사이트 class</param>
public IQueryable<ExportSite> ExportSiteList()
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "export_site");
return MongoHelper.FindAll<ExportSite>();
}
/// <summary>
/// 소스사이트 삭제
/// </summary>
/// <param name="id">아이디</param>
/// <returns></returns>
public void SourceSiteRemove(ObjectId id)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "source_site");
MongoHelper.Remove(Query.EQ("_id", id));
}
/// <summary>
/// 소스사이트 리스트
/// </summary>
/// <param name="site">소스사이트 class</param>
public IQueryable<SourceSite> SourceSiteList()
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "source_site");
return MongoHelper.FindAll<SourceSite>();
}
/// <summary>
/// 소스사이트 생성
/// </summary>
/// <param name="site">소스사이트 class</param>
public void SourceSiteCreate(SourceSite site)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "source_site");
MongoHelper.Insert<SourceSite>(site);
}
/// <summary>
/// Export 사이트 뷰
/// </summary>
/// <param name="query">조건</param>
/// <returns></returns>
public ExportSite ExportSiteView(QueryComplete query)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "export_site");
return MongoHelper.FindOne<ExportSite>(query);
}
/// <summary>
/// Export 사이트 뷰
/// </summary>
/// <param name="id">아이디</param>
/// <returns></returns>
public ExportSite ExportSiteView(int id)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "export_site");
return MongoHelper.FindOne<ExportSite>(Query.EQ("_id", id));
}
/// <summary>
/// Export 사이트 저장
/// </summary>
/// <param name="site">Export 사이트 class</param>
public void ExportSiteSave(ExportSite site)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "export_site");
MongoHelper.Save<ExportSite>(site);
}
public void ExportSiteRemove(QueryComplete query)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "export_site");
MongoHelper.Remove(query);
}
/// <summary>
/// 어드민 보기
/// </summary>
/// <param name="is">아이디</param>
/// <returns>AccessIP Class</returns>
public AccessIP AccessIPView(string id)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "admin");
return MongoHelper.FindOne<AccessIP>(Query.EQ("_id", ObjectId.Parse(id)));
}
/// <summary>
/// Export 사이트 생성
/// </summary>
/// <param name="site">Export 사이트 class</param>
public void ExportSiteCreate(ExportSite site)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "export_site");
MongoHelper.Insert<ExportSite>(site);
}
/// <summary>
/// 소스사이트 저장
/// </summary>
/// <param name="site">소스사이트 class</param>
public void SourceSiteSave(SourceSite site)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "source_site");
MongoHelper.Save<SourceSite>(site);
}
/// <summary>
/// Export 사이트 리스트
/// </summary>
/// <param name="query">조건</param>
/// <returns></returns>
public IQueryable<ExportSite> ExportSiteList(QueryComplete query)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "export_site");
return MongoHelper.Find<ExportSite>(query);
}
/// <summary>
/// 소스사이트 뷰
/// </summary>
/// <param name="id">아이디</param>
/// <returns></returns>
public SourceSite SourceSiteView(ObjectId id)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "source_site");
return MongoHelper.FindOne<SourceSite>(Query.EQ("_id", id));
}
/// <summary>
/// GEP 상품 저장
/// </summary>
/// <param name="data">GepItemsData Class</param>
public void Save(GepItemsData data)
{
List<GepItemsData> List = new List<GepItemsData>();
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "gep_items");
MongoHelper.Save<GepItemsData>(data);
}
/// <summary>
/// 사용가능한 어드민 아이피 한개만 선택 보기
/// </summary>
/// <param name="ip">아이디</param>
/// <returns>AccessIP Class</returns>
public AccessIP UseIpView(string ip)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "admin");
return MongoHelper.FindOne<AccessIP>(Query.And(Query.EQ("ip", ip), Query.EQ("is_use", true)));
}
/// <summary>
/// GEP 상품 한건 보기
/// </summary>
/// <param name="query">조건</param>
/// <returns>GepItemsData Class</returns>
public GepItemsData View(QueryComplete query)
{
List<GepItemsData> List = new List<GepItemsData>();
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "gep_items");
return MongoHelper.FindOne<GepItemsData>(query);
}
/// <summary>
/// 어드민 아이피 등록
/// </summary>
/// <param name="Data">AccessIP Class</param>
public void AccessIPCreate(AccessIP Data)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "admin");
MongoHelper.Insert<AccessIP>(Data);
}
/// <summary>
/// 환경설정 리스트
/// </summary>
/// <param name="taId">TA아이디</param>
public List<BsonDocument> List(string taId)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "ta_site_setting_templete");
return MongoHelper.Find(Query.EQ("ta_id", taId));
}
/// <summary>
/// 어드민 아이피 리스트
/// </summary>
/// <returns>AccessIP List</returns>
public IQueryable<AccessIP> AccessIPRead()
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "admin");
return MongoHelper.FindAll<AccessIP>();
}
/// <summary>
/// 환경설정 수정
/// </summary>
/// <param name="param">환경설정 dictionary</param>
public void Save(Dictionary<string, object> param)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "ta_site_setting_templete");
MongoHelper.Save(BsonDocument.Create(param));
}
/// <summary>
/// 어드민 아이피 삭제
/// </summary>
/// <param name="_id">아이디</param>
public void AccessIPRemove(ObjectId id)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "admin");
MongoHelper.Remove(Query.EQ("_id",id));
}
/// <summary>
/// 환경설정 상세 보기
/// </summary>
/// <param name="id">환경설정 아이디</param>
/// <returns>BsonDocument</returns>
public BsonDocument View(ObjectId id)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "ta_site_setting_templete");
return MongoHelper.FindOne(Query.EQ("_id", id));
}
/// <summary>
/// 어드민 아이피 저장
/// </summary>
/// <param name="Data">AccessIP Class</param>
public void AccessIPSave(AccessIP Data)
{
GEPMongoDacHelper MongoHelper = new GEPMongoDacHelper("gep", "admin");
MongoHelper.Save<AccessIP>(Data);
}
