public JsonResult ProjeTest()
{
var routeValue = RouteData.Values["id"];
TBLPROJE proje = new TBLPROJE();
conn.Open();
SqlCommand command = new SqlCommand("SELECT PROJE_TURU, PROJE_ADI, PROJE_TANIMI FROM TBLPROJE WHERE PROJE_KOD ='" + routeValue + "'", conn);
DataTable dataTable = new DataTable();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(command);
sqlDataAdapter.Fill(dataTable);
sqlDataAdapter.Dispose();
//count = Convert.ToInt16(command.ExecuteScalar());
for (int i = 0; i < dataTable.Rows.Count; i++)
{
proje.PROJE_ADI = dataTable.Rows[i]["PROJE_ADI"].ToString();
proje.PROJE_TANIMI = dataTable.Rows[i]["PROJE_TANIMI"].ToString();
proje.PROJE_TURU = dataTable.Rows[i]["PROJE_TURU"].ToString();
}
return(Json(proje, JsonRequestBehavior.AllowGet));
}
public ActionResult ProjeDüzenle(TBLPROJE model)
{
model.REC_UPDATE = DateTime.Now;
model.REC_UPUSERNAME = (string)Session["UserName"];
model.REC_UPUSERNO = (int)Session["UserId"];
model.REC_VERSION = CreateCommon.REC_VERSION;
model.REC_CHANGED = "1";
entities.Entry(model).State = EntityState.Modified;
entities.SaveChanges();
return(RedirectToAction("projeGörüntüle"));
}
public ActionResult ProjeDetay(string id)
{
var model = from f in entities.TBLGOREV
select f;
model = model.Where(f => f.PROJE_KOD.Contains(id));
TBLPROJE tBLPROJE = new TBLPROJE();
tBLPROJE = entities.TBLPROJE.Find(id);
ViewBag.Proje_ad = tBLPROJE.PROJE_ADI;
ViewBag.PERSONEL_KOD = id;
return(View(model.ToList()));
////return View(Tuple.Create(tBLGOREV.ToList(),tBLPROJEPERSONEL.ToList()));
}
public ActionResult projeEkle(TBLPROJE model)
{
model.REC_DATE = DateTime.Now;
model.REC_UPDATE = DateTime.Now;
model.REC_UPUSERNAME = (string)Session["UserName"];
model.REC_UPUSERNO = (int)Session["UserId"];
model.REC_USERNAME = (string)Session["UserName"];
model.REC_USERNO = (int)Session["UserId"];
model.REC_CHANGED = "0";
model.DURUM = 2; //yapılmakta olan proje seçeneği
model.REC_VERSION = CreateCommon.REC_VERSION;
entities.TBLPROJE.Add(model);
entities.SaveChanges();
return(RedirectToAction("ProjePersonel"));
}
public ActionResult CharterColumn(string id)
{
SqlConnection conn = new SqlConnection("Data Source=ESRA\\SQLEXPRESS; Initial Catalog=isTakip;integrated security=True;MultipleActiveResultSets=True;");
conn.Open();
SqlCommand command = new SqlCommand("SELECT PERSONEL_KOD,BITIRME_SURESI,TAHMINI_BASLANGIC FROM TBLGOREV WHERE PROJE_KOD='" + id + "'and BITIRME_SURESI is not null", conn);
DataTable dataTable = new DataTable();
SqlDataAdapter sqlDataAdapter = new SqlDataAdapter(command);
sqlDataAdapter.Fill(dataTable);
sqlDataAdapter.Dispose();
var gorevList = new List <Class1>();
for (int i = 0; i < dataTable.Rows.Count; i++)
{
Class1 class1 = new Class1();
class1.personel_kod = dataTable.Rows[i]["PERSONEL_KOD"].ToString();
class1.tarih = (Convert.ToDateTime(dataTable.Rows[i]["TAHMINI_BASLANGIC"])).AddDays(Convert.ToInt32(dataTable.Rows[i]["BITIRME_SURESI"]));
gorevList.Add(class1);
}
TBLPROJE tBLPROJE = new TBLPROJE();
tBLPROJE = entities.TBLPROJE.Find(id);
String proje_ad = tBLPROJE.PROJE_ADI;
ArrayList xValue = new ArrayList();
ArrayList yValue = new ArrayList();
var result = from c in gorevList select c;
result.ToList().ForEach(rs => xValue.Add(rs.personel_kod));
result.ToList().ForEach(rs => yValue.Add(rs.tarih));
new System.Web.Helpers.Chart(width: 600, height: 300, theme: ChartTheme.Green)
.AddTitle(proje_ad)
.AddSeries("Default", chartType: "Column", xValue: xValue, yValues: yValue)
.Write("bmp");
return(null);
}
