private void DeleteImpactPlant(string gpcode, string year, int runno)
{
using (var dbLocal = new PackingChangeEntities())
{
var sel_imp_plant = from a in dbLocal.td_impact_plant
where a.gpcode == gpcode && a.year == year && a.runno == runno
select a.plant_code;
foreach (var item in sel_imp_plant)
{
var del_imp_plant = dbLocal.td_impact_plant.Find(gpcode, year, runno, item);
dbLocal.td_impact_plant.Remove(del_imp_plant);
}
dbLocal.SaveChanges();
}
}
public JsonResult UpdateConcern(string gpcode, string year, int runno, byte congid, string congroup)
{
try
{
if (!string.IsNullOrEmpty(congroup))
{
//Delete
((System.Data.Entity.Infrastructure.IObjectContextAdapter)dbPC)
.ObjectContext.ExecuteStoreCommand("DELETE FROM td_temp_concern WHERE gpcode='" + gpcode + "' and year='" + year
+ "' and runno='" + runno + "' and concern_group_id='" + congid + "'");
dbPC.SaveChanges();
int[] groups = congroup.Split(',').Select(s => Convert.ToInt32(s)).ToArray();
using (var dbLocal = new PackingChangeEntities())
{
//Add
foreach (var item in groups)
{
var check = dbLocal.td_temp_concern.Find(gpcode, year, runno, congid, item);
if (check == null)
{
var temp = new td_temp_concern();
temp.gpcode = gpcode;
temp.year = year;
temp.runno = runno;
temp.concern_group_id = congid;
temp.group_id = item;
dbLocal.td_temp_concern.Add(temp);
}
}
dbLocal.SaveChanges();
}
}
return(Json("Update Successful."));
}
catch (Exception)
{
return(Json("Error"));
}
}
