public ActionResult DeleteConfirmed(int id)
{
guiasimpresas guiasimpresas = db.guiasimpresas.Find(id);
db.guiasimpresas.Remove(guiasimpresas);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id,fecha,numero,orden")] guiasimpresas guiasimpresas)
{
if (ModelState.IsValid)
{
db.Entry(guiasimpresas).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(guiasimpresas));
}
public ActionResult Create([Bind(Include = "id,fecha,numero,orden")] guiasimpresas guiasimpresas)
{
if (ModelState.IsValid)
{
db.guiasimpresas.Add(guiasimpresas);
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(guiasimpresas));
}
// GET: guiasimpresas/Delete/5
public ActionResult Delete(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
guiasimpresas guiasimpresas = db.guiasimpresas.Find(id);
if (guiasimpresas == null)
{
return(HttpNotFound());
}
return(View(guiasimpresas));
}
public ActionResult ObtenerGuiasImpresas()
{
try
{
var Draw = Request.Form.GetValues("draw").FirstOrDefault();
var Start = Request.Form.GetValues("start").FirstOrDefault();
var Length = Request.Form.GetValues("length").FirstOrDefault();
var SortColumn = Request.Form.GetValues("columns[" + Request.Form.GetValues("order[0][column]").FirstOrDefault() + "][data]").FirstOrDefault();
var SortColumnDir = Request.Form.GetValues("order[0][dir]").FirstOrDefault();
var Orden = Request.Form.GetValues("columns[0][search][value]").FirstOrDefault();
var Guia = Request.Form.GetValues("columns[1][search][value]").FirstOrDefault();
int PageSize = Length != null?Convert.ToInt32(Length) : 0;
int Skip = Start != null?Convert.ToInt32(Start) : 0;
int TotalRecords = 0;
List <guiasimpresas> lista = new List <guiasimpresas>();
using (var con = new SqlConnection(ConfigurationManager.ConnectionStrings["DefaultConnection"].ToString()))
{
con.Open();
string sql = "exec [SP_GuiasImpresasSAC_ParametrosOpcionales] @orden, @numero";
var query = new SqlCommand(sql, con);
if (Orden != "")
{
query.Parameters.AddWithValue("@orden", Orden);
}
else
{
query.Parameters.AddWithValue("@orden", DBNull.Value);
}
if (Guia != "")
{
query.Parameters.AddWithValue("@numero", Guia);
}
else
{
query.Parameters.AddWithValue("@numero", DBNull.Value);
}
using (var dr = query.ExecuteReader())
{
while (dr.Read())
{
// facturas
var guias = new guiasimpresas();
guias.id = Convert.ToInt32(dr["id"]);
guias.orden = dr["orden"].ToString();
guias.numero = dr["numero"].ToString();
guias.fecha = Convert.ToDateTime(dr["fecha"].ToString());
lista.Add(guias);
}
}
}
if (!(string.IsNullOrEmpty(SortColumn) && string.IsNullOrEmpty(SortColumnDir)))
{
lista = lista.OrderBy(SortColumn + " " + SortColumnDir).ToList();
}
TotalRecords = lista.ToList().Count();
var NewItems = lista.Skip(Skip).Take(PageSize == -1 ? TotalRecords : PageSize).ToList();
return(Json(new { draw = Draw, recordsFiltered = TotalRecords, recordsTotal = TotalRecords, data = NewItems }, JsonRequestBehavior.AllowGet));
}
catch (Exception)
{
throw;
}
}
public ActionResult Import(HttpPostedFileBase postedFileBase)
{
try
{
string filePath = string.Empty;
if (postedFileBase != null)
{
string path = Server.MapPath("~/Uploads/");
if (!Directory.Exists(path))
{
Directory.CreateDirectory(path);
}
filePath = path + Path.GetFileName(postedFileBase.FileName);
string extension = Path.GetExtension(postedFileBase.FileName);
postedFileBase.SaveAs(filePath);
DataTable dt = new DataTable();
dt.Columns.AddRange(new DataColumn[3] {
//1
new DataColumn("fecha", typeof(DateTime)),
//2
new DataColumn("orden", typeof(string)),
//3
new DataColumn("numero", typeof(string)),
});
string csvData = System.IO.File.ReadAllText(filePath);
foreach (string row in csvData.Split('\n'))
{
if (!string.IsNullOrEmpty(row))
{
dt.Rows.Add();
int i = 0;
//Execute a loop over the columns.
foreach (string cell in row.Split(','))
{
if (cell.Equals(string.Empty))
{
if (dt.Rows[dt.Rows.Count - 1][0].ToString() == "")
{
dt.Rows[dt.Rows.Count - 1][0] = DateTime.Parse("01/01/1900");
}
if (dt.Rows[dt.Rows.Count - 1][1].ToString() == "")
{
dt.Rows[dt.Rows.Count - 1][1] = "NA";
}
if (dt.Rows[dt.Rows.Count - 1][2].ToString() == "")
{
dt.Rows[dt.Rows.Count - 1][2] = "NA";
}
}
else
{
dt.Rows[dt.Rows.Count - 1][i] = cell;
}
i++;
}
}
}
foreach (DataRow orow in dt.Select())
{
string orden = orow["orden"].ToString();
guiasimpresas guiasimpresas = db.guiasimpresas.Where(x => x.orden == orden).FirstOrDefault();
if (guiasimpresas != null)
{
dt.Rows.Remove(orow);
}
}
dt.AcceptChanges();
string conString = ConfigurationManager.ConnectionStrings["DefaultConnection"].ConnectionString;
using (SqlConnection con = new SqlConnection(conString))
{
using (SqlBulkCopy sqlBulkCopy = new SqlBulkCopy(con))
{
//Set the database table name.
sqlBulkCopy.DestinationTableName = "dbo.guiasimpresas";
//[OPTIONAL]: Map the DataTable columns with that of the database table
//1
sqlBulkCopy.ColumnMappings.Add("fecha", "fecha");
//2
sqlBulkCopy.ColumnMappings.Add("numero", "numero");
//3
sqlBulkCopy.ColumnMappings.Add("orden", "orden");
con.Open();
sqlBulkCopy.WriteToServer(dt);
con.Close();
}
}
}
return(RedirectToAction("Index"));
}
catch (Exception _ex)
{
string error = _ex.Message.ToString();
return(RedirectToAction("Error500", "Errores", new { error = error }));
}
}