public ActionResult Items(string marker)
{
ViewBag.marker = marker;
List <ArtmoModels> Artmo = new List <ArtmoModels>();
DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath(path));
DataView dv;
dv = ds.Tables[0].DefaultView;
dv.Sort = "Name";
foreach (DataRowView dr in dv)
{
ArtmoModels model = new ArtmoModels();
if (Convert.ToString(dr[1]).Equals(marker))
{
model.Id = Convert.ToInt32(dr[0]);
model.Marker = Convert.ToInt32(dr[1]);
model.Name = Convert.ToString(dr[3]);
model.GenericTerm = Convert.ToString(dr[4]);
model.Donor = Convert.ToString(dr[5]);
model.DateAcquired = Convert.ToDateTime(dr[8]);
model.DateAcquired.ToShortDateString();
Artmo.Add(model);
}
}
return(PartialView("Items", Artmo));
}
public ActionResult _Index(string searchString, string SortBy)
{
List <ArtmoModels> Artmo = new List <ArtmoModels>();
DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath(path));
DataView dv;
dv = ds.Tables[0].DefaultView;
dv.Sort = SortBy;
int ctr = 0;
foreach (DataRowView dr in dv)
{
ArtmoModels model = new ArtmoModels();
if (Convert.ToString(dr[3]).ToLower().Contains(searchString) || Convert.ToString(dr[4]).ToString().ToLower().Contains(searchString) ||
Convert.ToString(dr[5]).ToLower().Contains(searchString) || Convert.ToString(dr[6]).ToLower().Contains(searchString) ||
Convert.ToString(dr[7]).ToLower().Contains(searchString) || Convert.ToString(dr[8]).ToLower().Contains(searchString))
{
model.Id = Convert.ToInt32(dr[0]);
model.Marker = Convert.ToInt32(dr[1]);
var b64 = dr[2];
model._img64 = b64.ToString();
model.Name = Convert.ToString(dr[3]);
model.GenericTerm = Convert.ToString(dr[4]);
model.Donor = Convert.ToString(dr[5]);
model.EngDesc = Convert.ToString(dr[6]);
model.IlocoDesc = Convert.ToString(dr[7]);
model.DateAcquired = Convert.ToDateTime(dr[8]);
model.DateAcquired.ToShortDateString();
model.DateAdded = Convert.ToString(dr[9]);
model.LastModified = Convert.ToString(dr[10]);
Artmo.Add(model);
ctr++;
}
}
return(PartialView(Artmo));
}
public ActionResult AddEdit(ArtmoModels md, HttpPostedFileBase imgf)
{
if (imgf != null)
{
md.Image = new byte[imgf.ContentLength];
imgf.InputStream.Read(md.Image, 0, imgf.ContentLength);
md._img64 = Convert.ToBase64String(md.Image);
}
if (md.Id > 0)
{
XDocument xmlDoc = XDocument.Load(Server.MapPath(path));
var items = (from item in xmlDoc.Descendants("Artifact")
where item.Element("id").Value == md.Id.ToString()
select item).ToList();
foreach (var item in items)
{
item.Element("id").Value = md.Id.ToString();
item.Element("marker").Value = md.Marker.ToString();
item.Element("Image").Value = md._img64 ?? "";
item.Element("Name").Value = md.Name;
item.Element("GTerm").Value = md.GenericTerm ?? "";
item.Element("Donor").Value = md.Donor ?? "";
item.Element("EngDesc").Value = md.EngDesc ?? "";
item.Element("IlocoDesc").Value = md.IlocoDesc ?? "";
item.Element("DateAcquired").Value = md.DateAcquired.ToString("yyyy/MM/dd") ?? "";
item.Element("LastModified").Value = TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, "Taipei Standard Time").ToString("yyyy/MM/dd") ?? "";
}
xmlDoc.Save(Server.MapPath(path));
GetDetails(md.Id);
}
else
{
Console.WriteLine("1");
XmlDocument oXmlDocument = new XmlDocument();
oXmlDocument.Load(Server.MapPath(path));
XmlNodeList nodeList = oXmlDocument.GetElementsByTagName("Artifact");
var x = oXmlDocument.GetElementsByTagName("id");
int Max = 0;
foreach (XmlElement item in x)
{
int EId = Convert.ToInt32(item.InnerText.ToString());
if (EId > Max)
{
Max = EId;
}
}
Max = Max + 1;
XDocument xmlDoc = XDocument.Load(Server.MapPath(path));
xmlDoc.Element("Artifacts").Add(new XElement("Artifact",
new XElement("id", Max),
new XElement("marker", md.Marker),
new XElement("Image", md._img64),
new XElement("Name", md.Name),
new XElement("GTerm", md.GenericTerm),
new XElement("Donor", md.Donor),
new XElement("EngDesc", md.EngDesc),
new XElement("IlocoDesc", md.IlocoDesc),
new XElement("DateAcquired", md.DateAcquired.ToString("yyyy/MM/dd")),
new XElement("DateAdded", TimeZoneInfo.ConvertTimeBySystemTimeZoneId(DateTime.UtcNow, "Taipei Standard Time").ToString("yyyy/MM/dd")),
new XElement("LastModified", "")
));
xmlDoc.Save(Server.MapPath(path));
GetDetails(Max);
}
ViewBag.Image = string.Format("data:image/gif;base64,{0}", model._img64);
return(PartialView("_Details", model));
}
public ActionResult Index(string searchString, string SortBy)
{
List <ArtmoModels> Artmo = new List <ArtmoModels>();
DataSet ds = new DataSet();
ds.ReadXml(Server.MapPath(path));
DataView dv;
dv = ds.Tables[0].DefaultView;
if (SortBy == "DateAdded" || SortBy == "LastModified")
{
dv.Sort = SortBy + " DESC";
}
else
{
dv.Sort = SortBy;
}
int ctr = 0;
if (!String.IsNullOrEmpty(searchString))
{
searchString.ToString().ToLower();
foreach (DataRowView dr in dv)
{
ArtmoModels model = new ArtmoModels();
if (Convert.ToString(dr[3]).ToLower().Contains(searchString) || Convert.ToString(dr[4]).ToString().ToLower().Contains(searchString) ||
Convert.ToString(dr[5]).ToLower().Contains(searchString) || Convert.ToString(dr[6]).ToLower().Contains(searchString) ||
Convert.ToString(dr[7]).ToLower().Contains(searchString) || Convert.ToString(dr[8]).ToLower().Contains(searchString))
{
model.Id = Convert.ToInt32(dr[0]);
model.Marker = Convert.ToInt32(dr[1]);
var b64 = dr[2];
model._img64 = b64.ToString();
model.Name = Convert.ToString(dr[3]);
model.GenericTerm = Convert.ToString(dr[4]);
model.Donor = Convert.ToString(dr[5]);
model.EngDesc = Convert.ToString(dr[6]);
model.IlocoDesc = Convert.ToString(dr[7]);
model.DateAcquired = Convert.ToDateTime(dr[8]);
model.DateAcquired.ToString("yyyy/MM/dd");
model.DateAdded = Convert.ToString(dr[9]);
model.LastModified = Convert.ToString(dr[10]);
Artmo.Add(model);
ctr++;
}
}
return(View("Index", Artmo));
}
else
{
ctr = 1;
foreach (DataRowView dr in dv)
{
ArtmoModels model = new ArtmoModels();
model.Id = Convert.ToInt32(dr[0]);
model.Marker = Convert.ToInt32(dr[1]);
var b64 = dr[2];
model._img64 = b64.ToString();
model.Name = Convert.ToString(dr[3]);
model.GenericTerm = Convert.ToString(dr[4]);
model.Donor = Convert.ToString(dr[5]);
model.EngDesc = Convert.ToString(dr[6]);
model.IlocoDesc = Convert.ToString(dr[7]);
model.DateAcquired = Convert.ToDateTime(dr[8]);
model.DateAcquired.ToString("yyyy/MM/dd");
model.DateAdded = Convert.ToString(dr[9]);
model.LastModified = Convert.ToString(dr[10]);
Artmo.Add(model);
}
}
return(View(Artmo));
}
