public IHttpActionResult ChuyenVB_SangThongBao(VanBanViewModel model)
{
try
{
using (IDbConnection db = new SqlConnection(_cnn))
{
DynamicParameters prs = new DynamicParameters();
prs.Add("@SVBID", model.SoVanBanID);
string query = "select TENSO from doc.tbSovanban where ID = @SVBID";
var tenSo = db.Query <SoVanBanViewModel>(query, prs).SingleOrDefault();
DynamicParameters parameters = new DynamicParameters();
parameters.Add("@OrganId", model.OrganId);
parameters.Add("@FileCatalog", model.FileCatalog);
parameters.Add("@FileNotation", model.FileNotation);
parameters.Add("@DocOrdinal", model.DocOrdinal);
parameters.Add("@TypeName", model.TypeName);
parameters.Add("@CodeNumber", model.CodeNumber);
parameters.Add("@CodeNotation", model.CodeNotation);
parameters.Add("@IssuedDate", model.IssuedDate);
parameters.Add("@OrganName", model.OrganName);
parameters.Add("@Subject", model.Subject);
parameters.Add("@Language", model.Language);
parameters.Add("@PageAmount", model.PageAmount);
parameters.Add("@Description", model.Description);
parameters.Add("@Position", model.Position);
parameters.Add("@Fullname", model.Fullname);
parameters.Add("@Priority", model.Priority);
parameters.Add("@IssuedAmount", model.IssuedAmount);
parameters.Add("@DueDate", model.DueDate);
parameters.Add("@SoVanBanID", tenSo.TENSO);
parameters.Add("@MOREINFO1", model.MOREINFO1);
parameters.Add("@MOREINFO2", model.MOREINFO2);
parameters.Add("@MOREINFO3", model.MOREINFO3);
parameters.Add("@MOREINFO4", model.MOREINFO4);
parameters.Add("@MOREINFO5", model.MOREINFO5);
var returnV = db.Query <CommonReturnValueModel>("procChuyenVanBanSangThongBao", parameters, null, true, null, System.Data.CommandType.StoredProcedure).SingleOrDefault();
if (model.FileDinhKem.Count > 0)
{
foreach (var item in model.FileDinhKem)
{
DynamicParameters param = new DynamicParameters();
param.Add("@MaTinTuc", returnV.ID);
param.Add("@Ten", item.TENFILE);
param.Add("@Url", null);
param.Add("@Ngay", DateTime.Now);
db.Execute("procThemFileDinhKem_TinTuc", param, null, null, System.Data.CommandType.StoredProcedure);
}
}
DynamicParameters pr = new DynamicParameters();
pr.Add("@ID", model.ID);
pr.Add("@ReturnV", returnV.ID);
string qr = "update doc.tbVanbanden set MOREINFO1 = @ReturnV where ID = @ID";
db.Execute(qr, pr);
return(Ok(returnV.ID));
}
}
catch (DbEntityValidationException ex)
{
// Retrieve the error messages as a list of strings.
var errorMessages = ex.EntityValidationErrors
.SelectMany(x => x.ValidationErrors)
.Select(x => x.ErrorMessage);
// Join the list to a single string.
var fullErrorMessage = string.Join("; ", errorMessages);
// Combine the original exception message with the new one.
var exceptionMessage = string.Concat(ex.Message, " The validation errors are: ", fullErrorMessage);
// Throw a new DbEntityValidationException with the improved exception message.
//throw new DbEntityValidationException(exceptionMessage, ex.EntityValidationErrors);
return(BadRequest(exceptionMessage + " " + ex.EntityValidationErrors));
}
}
public IHttpActionResult ThemVanBanDen(VanBanViewModel par)
{
using (IDbConnection db = new SqlConnection(_cnn))
{
var parameters = new DynamicParameters();
parameters.Add("@OrganId", par.OrganId);
parameters.Add("@FileCatalog", par.FileCatalog);
parameters.Add("@FileNotation", par.FileNotation);
parameters.Add("@DocOrdinal", par.DocOrdinal);
parameters.Add("@TypeName", par.TypeName);
parameters.Add("@CodeNumber", par.CodeNumber);
parameters.Add("@CodeNotation", par.CodeNotation);
parameters.Add("@IssuedDate", par.IssuedDate.Value.AddDays(1));
parameters.Add("@OrganName", par.OrganName);
parameters.Add("@Subject", par.Subject);
parameters.Add("@Language", par.Language);
parameters.Add("@PageAmount", 1);
parameters.Add("@Description", par.Description);
parameters.Add("@Position", par.Position);
parameters.Add("@Fullname", par.Fullname);
parameters.Add("@Priority", par.Priority);
parameters.Add("@IssuedAmount", par.IssuedAmount);
parameters.Add("@DueDate", par.DueDate.Value.AddDays(1));
parameters.Add("@SoVanBanID", par.SoVanBanID);
parameters.Add("@MOREINFO1", par.MOREINFO1);
parameters.Add("@MOREINFO2", par.MOREINFO2);
parameters.Add("@MOREINFO3", par.MOREINFO3);
parameters.Add("@MOREINFO4", par.MOREINFO4);
parameters.Add("@MOREINFO5", par.MOREINFO5);
if (db.State == System.Data.ConnectionState.Closed)
{
db.Open();
}
var returnV = db.Query <VanBanViewModel>("procThemVanBanDen", parameters, null, true, null, System.Data.CommandType.StoredProcedure).SingleOrDefault();
if (par.FileDinhKem.Count > 0)
{
foreach (var item in par.FileDinhKem)
{
var param = new DynamicParameters();
param.Add("@LOAI", item.LOAI);
param.Add("@VANBANID", returnV.ID);
param.Add("@TENFILE", item.TENFILE);
param.Add("@MOTA", item.MOTA);
param.Add("@NGAYTAO", DateTime.Now);
param.Add("@TRANGTHAI", true);
param.Add("@LOAIFILE", item.LOAIFILE);
param.Add("@SIZEFILE", item.SIZEFILE);
param.Add("@VITRIID", item.VITRIID);
if (db.State == System.Data.ConnectionState.Closed)
{
db.Open();
}
db.Execute("procThemFileDinhKem", param, null, null, System.Data.CommandType.StoredProcedure);
}
}
return(Ok("Thêm Văn Bản Thành Công"));
}
}
