public TermEntity Download(int documentId) { try { this.connector.Database = DbNames.Database.BmbDigital; this.connector.Procedure = "spr_digit_ler_campa_incen_termo"; this.connector.AddParameter("num_campa_incen_termo", documentId); using (var reader = this.connector.ExecuteReader()) { while (reader.Read()) { var c = new TermEntity { Id = Convert.ToInt32(reader["num_campa_incen_termo"]), Name = reader["nom_campa_incen_termo"].ToString(), //CreationDate = reader["dat_publi"].ToDateTime(), Extention = reader["tip_exten"].ToString(), Contents = (byte[])reader["val_docum"], //UserId = reader["cod_user"].ToString() TotalBytes = Convert.ToInt64(reader["num_bytes"]) }; return(c); } } return(null); } finally { this.connector.Dispose(); } }
public List <TermEntity> ReadByCampaign(int campaignId) { try { var terms = new List <TermEntity>(); this.connector.Database = DbNames.Database.BmbDigital; this.connector.Procedure = "spr_digit_ler_refat_campa_incen_termo_por_campa"; this.connector.AddParameter("num_campa_incen", campaignId); using (var reader = this.connector.ExecuteReader()) { while (reader.Read()) { var t = new TermEntity { Id = Convert.ToInt32(reader["num_campa_incen_termo"]), Name = reader["nom_campa_incen_termo"].ToString(), //CreationDate = reader["dat_publi"].ToDateTime(), Extention = reader["tip_exten"].ToString(), Contents = (byte[])reader["val_docum"], //UserId = reader["cod_user"].ToString() TotalBytes = Convert.ToInt64(reader["num_bytes"]) }; terms.Add(t); } } return(terms); } finally { this.connector.Dispose(); } }
public TermEntity Register(int incentiveCampaignId, TermEntity term, string codUser) { try { this.connector.Procedure = "spr_digit_ins_campa_incen_termo"; this.connector.AddParameter("num_campa_incen", incentiveCampaignId); this.connector.AddParameter("nom_campa_incen_termo", term.Name); this.connector.AddParameter("dat_publi", DateTime.Now); this.connector.AddParameter("tip_exten", term.Extention); this.connector.AddParameter("val_docum", term.Contents); this.connector.AddParameter("num_bytes", term.TotalBytes); this.connector.AddParameter("cod_usu", codUser); using (var reader = this.connector.ExecuteReader()) { while (reader.Read()) { term.Id = Convert.ToInt32(reader["num_campa_incen_termo"]); return(term); } } return(null); } catch (Exception ex) { throw; } finally { this.connector.Dispose(); } }
public bool Register(int incentiveCampaignId, TermEntity term, string codUser) { try { var sql = "spr_digit_ins_campa_incen_termo"; using (var cmd = new SqlCommand(sql, connection)) { cmd.Parameters.AddWithValue("@num_campa_incen", incentiveCampaignId); cmd.Parameters.AddWithValue("@nom_campa_incen_termo]", term.Name); cmd.Parameters.AddWithValue("@dat_publi]", term.PublishDate); cmd.Parameters.AddWithValue("@tip_exten]", term.Extention); cmd.Parameters.AddWithValue("@val_docum]", term.Contents); cmd.Parameters.AddWithValue("@num_bytes]", term.TotalBytes); cmd.Parameters.AddWithValue("@cod_user]", codUser); var datareader = cmd.ExecuteReader(); } return(true); } catch (Exception ex) { throw ex; } }
public void DeleteTermEntity(TermEntity termEntityToDelete) { using (var db = new PlutoContext()) { db.Entry(termEntityToDelete).State = EntityState.Deleted; db.SaveChanges(); } }
public void UpdateTermEntity(TermEntity termEntityToUpdate) { using (var db = new PlutoContext()) { db.Entry(termEntityToUpdate).State = EntityState.Modified; db.SaveChanges(); } }
private Term ConvertToModel(TermEntity termEntity) { var term = new Term(termEntity.Name, termEntity.IsActive, termEntity.IsActive ? new Period((DateTime)termEntity.StartDate, (DateTime)termEntity.EndDate) : null); term.Load(termEntity.Id, termEntity.IsClosed); return(term); }
public int AddTermEntity(TermEntity termEntity) { using (var db = new PlutoContext()) { db.Terms.Add(termEntity); db.SaveChanges(); } return(termEntity.Id); }
public bool Upload(int campaignId, TermEntity term) { var relatedCampaign = incentiveCampaignApl.GetById(campaignId); if (relatedCampaign == null) { throw new Exception("Campaign.Does.Not.Exists"); } return(termDb.Upload(campaignId, term)); }
public HttpResponseMessage InsertTerm(RequestModel request) { var result = WebHelper.GetResult(request); if (result.Code == DoubleX.Infrastructure.Utility.EnumHelper.GetValue(EnumResultCode.操作成功)) { var projectId = JsonHelper.GetValue(request.Obj, "ProjectId"); var projectGuid = Guid.Parse(projectId); var termSrc = JsonHelper.GetValue(request.Obj, "TermSrc"); var termSrcLang = JsonHelper.GetValue(request.Obj, "TermSrcLang"); var termTgt = JsonHelper.GetValue(request.Obj, "TermTgt"); var termTgtLang = JsonHelper.GetValue(request.Obj, "TermTgtLang"); var flag = JsonHelper.GetValue(request.Obj, "UserId"); var list = termService.Query(item => item.ProjectId == projectGuid && item.TermSrc == termSrc && item.TermSrcLang == termSrcLang && item.TermTgtLang == termTgtLang); if (list != null && list.Count > 0) { result.Message = "已具有相同术语!"; } else { TermEntity term = new TermEntity() { Id = Guid.NewGuid(), ProjectId = projectGuid, CreateId = Guid.Parse(WebHelper.GetContext().Member.MemberId), CreateDt = DateTime.Now, CreateIP = BrowserHelper.GetClientIP(), LastId = Guid.Parse(WebHelper.GetContext().Member.MemberId), LastDt = DateTime.Now, LastIP = BrowserHelper.GetClientIP(), IsDelete = false, TermSrc = termSrc, TermSrcLang = termSrcLang, TermTgt = termTgt, TermTgtLang = termTgtLang, PlatformCode = 0, UserId = flag, Type = 0, Status = 0 }; termService.Insert(term); result.Message = "新增术语成功!"; } } return(WebApiHelper.ToHttpResponseMessage(result)); }
public TermEntity Register(int incentiveCampaignId, TermEntity term, string codUser) { return(termDb.Register(incentiveCampaignId, term, codUser)); }
public bool Upload(int campaignId, TermEntity term) { throw new NotImplementedException(); }