private void Form1_Load(object sender, EventArgs e)
{
using (StreamReader re = new StreamReader("opros.txt"))
{
while (!re.EndOfStream)
{
var yoxla = re.ReadLine();
if (yoxla.Length > 0)
{
if (yoxla.Contains("Sual"))
{
survey opros = new survey();
ga.Add(opros);
opros.question = yoxla;
for (var u = 0; u < 3;)
{
var yoxla2 = re.ReadLine();
//cavablarin arasinda bow yer olarsa diye yoxlayiram
if (yoxla2.Length > 0)
{
opros.answers.Add(yoxla2);
u++;
}
}
}
}
}
foreach (var a in ga)
{
Label l = new Label();
a.g = new GroupBox();
a.g.Top = v;
v += 127;
this.Controls.Add(a.g);
l.Top = i;
i += 130;
l.Text = a.question;
l.Width = 400;
this.Controls.Add(l);
for (var w = 0; w < a.answers.Count; w++)
{
int count = w * 20;
RadioButton btn = new RadioButton();
btn.Text = a.answers[w];
btn.Top = btn.Height + count;
a.g.Controls.Add(btn);
}
}
re.Close();
}
}
public async Task <IHttpActionResult> CreateNewSurvey([FromBody] survey form)
{
try
{
var checkTitle = db.surveys.Where(a => a.title.ToString().ToLower() == form.title.ToString().ToLower()).FirstOrDefault();
if (checkTitle == null)
{
form.create_at = DateTime.Now;
db.surveys.Add(form);
int check = await db.SaveChangesAsync();
if (check > 0)
{
var msg = new ResponseMsg
{
message = "Create successful."
};
return(Ok(msg));
}
else
{
return(BadRequest("Create survey fails."));
}
}
else
{
return(BadRequest("Title survey have been same."));
}
}
catch
{
return(BadRequest("Error event."));
}
}
public async Task <IHttpActionResult> PublishSurveys(int id)
{
try
{
survey findSurvey = (from a in db.surveys where a.id == id select a).FirstOrDefault();
if (findSurvey != null)
{
findSurvey.publish = !findSurvey.publish;
var check = await db.SaveChangesAsync();
if (check > 0)
{
return(Ok(await FetchDetailsSurvey.GetDetailsSurvey(id)));
}
else
{
return(BadRequest("Publish/unpublish fails."));
}
}
else
{
return(BadRequest("Surveys not found."));
}
}
catch
{
return(BadRequest("Error."));
}
}
public HttpResponseMessage Put(int id, [FromBody] survey survey)
{
try
{
using (SMSDBEntities entities = new SMSDBEntities())
{
var entity = entities.surveys.FirstOrDefault(s => s.sid == id);
if (entity == null)
{
return(Request.CreateErrorResponse(HttpStatusCode.NotFound, "Survey with id = " + id.ToString() + " not found to update"));
}
else
{
entity.title = survey.title;
entities.SaveChanges();
return(Request.CreateResponse(HttpStatusCode.OK));
}
}
}
catch (Exception exp)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, exp));
}
}
public ActionResult DeleteConfirmed(int id)
{
survey survey = db.surveys.Find(id);
db.surveys.Remove(survey);
db.SaveChanges();
return(RedirectToAction("Index"));
}
public ActionResult Edit([Bind(Include = "id,userid,lectureid,Q1,Q2,Q3,Q4,Q5,Q6,Q7,Q8,Q9")] survey survey)
{
if (ModelState.IsValid)
{
db.Entry(survey).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
ViewBag.userid = new SelectList(db.AspNetUsers, "Id", "Email", survey.userid);
ViewBag.lectureid = new SelectList(db.lectures, "id", "code", survey.lectureid);
return(View(survey));
}
public IActionResult survey(survey yourSurvey)
{
if (ModelState.IsValid)
{
// do somethng! maybe insert into db? then we will redirect
return(RedirectToAction("Privacy", yourSurvey));
}
else
{
// Oh no! We need to return a ViewResponse to preserve the ModelState, and the errors it now contains!
return(View("Index"));
}
}
// GET: surveys/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
survey survey = db.surveys.Find(id);
if (survey == null)
{
return(HttpNotFound());
}
return(View(survey));
}
// GET: surveys/Edit/5
public ActionResult Edit(int?id)
{
if (id == null)
{
return(new HttpStatusCodeResult(HttpStatusCode.BadRequest));
}
survey survey = db.surveys.Find(id);
if (survey == null)
{
return(HttpNotFound());
}
ViewBag.userid = new SelectList(db.AspNetUsers, "Id", "Email", survey.userid);
ViewBag.lectureid = new SelectList(db.lectures, "id", "code", survey.lectureid);
return(View(survey));
}
public HttpResponseMessage getSurveyList()
{
DataTable dt = new BLL.handleSurvey().GetSurveyList();
Object data;
if (dt.Rows.Count >= 0)
{
List <survey> list = new List <survey>();
for (int i = 0; i < dt.Rows.Count; i++)
{
survey survey = new survey();
survey.id = dt.Rows[i]["id"].ToString();
survey.companyId = dt.Rows[i]["companyId"].ToString();
survey.satisfaction = dt.Rows[i]["satisfaction"].ToString();
survey.dish = dt.Rows[i]["dish"].ToString();
survey.clean = dt.Rows[i]["clean"].ToString();
survey.create_time = dt.Rows[i]["create_time"].ToString();
list.Add(survey);
}
data = new
{
success = true,
backData = list
};
}
else
{
data = new
{
success = false,
backMsg = "数据异常"
};
}
JavaScriptSerializer serializer = new JavaScriptSerializer();
string json = serializer.Serialize(data);
return(new HttpResponseMessage
{
Content = new StringContent(json, System.Text.Encoding.UTF8, "application/json")
});
}
public void SaveSurvey(string surveyName, int id, string surveyMetadata, string endOfLife)
{
try
{
survey addsurvey = new survey
{
name = surveyName,
userid = id,
metadata = surveyMetadata,
creationDate = DateTime.Now.ToShortDateString(),
endDate = endOfLife
};
SurveyPortalDBDataContext sql = new SurveyPortalDBDataContext();
sql.surveys.InsertOnSubmit(addsurvey);
sql.SubmitChanges();
}
catch (Exception e) {}
}
public void StoreSurveyInformation(SurveyDTO tempSurvey)
{
using (var context = new MSSContext())
{
survey newSurvey = new survey();
newSurvey.date = tempSurvey.date;
newSurvey.agegroupid = tempSurvey.agegroupid;
newSurvey.genderid = tempSurvey.genderid;
newSurvey.firstname = tempSurvey.firstname;
newSurvey.bednumber = tempSurvey.bednaumber;
newSurvey.phonenumber = tempSurvey.phonenumber;
newSurvey.preferredcontact = tempSurvey.preferredcontact;
newSurvey.contactedyn = false;
newSurvey.respondenttypeid = tempSurvey.respondenttypeid;
newSurvey.unitid = tempSurvey.unitid;
context.surveys.Add(newSurvey);
context.SaveChanges();
}
}
public HttpResponseMessage Post([FromBody] survey survey)
{
try
{
using (SMSDBEntities entities = new SMSDBEntities())
{
entities.surveys.Add(survey);
entities.SaveChanges();
var message = Request.CreateResponse(HttpStatusCode.Created, survey);
message.Headers.Location = new Uri(Request.RequestUri + survey.sid.ToString());
return(message);
}
}
catch (Exception exp)
{
return(Request.CreateErrorResponse(HttpStatusCode.BadRequest, exp));
}
}
public async Task <IHttpActionResult> UpdateSurvey([FromBody] survey form, int id)
{
try
{
var findSurvey = db.surveys.Where(a => a.id == id).FirstOrDefault();
if (findSurvey != null)
{
var checkTitle = db.surveys
.Where(a => a.title.ToString().ToLower() == form.title.ToString().ToLower() && a.id != id).FirstOrDefault();
if (checkTitle == null)
{
findSurvey.title = form.title;
findSurvey.description = form.description;
findSurvey.date_start = form.date_start;
int check = await db.SaveChangesAsync();
if (check > 0)
{
return(Ok(await FetchDetailsSurvey.GetDetailsSurvey(id)));
}
else
{
return(BadRequest("Edit survey fails."));
}
}
else
{
return(BadRequest("Survey title duplicate."));
}
}
else
{
return(BadRequest("Survey not found."));
}
}
catch
{
return(BadRequest("Error request."));
}
}
public int AddSurvey(SurveyDTO tempSurvey)
{
using (var context = new MSSContext())
{
survey newSurveyWithId;
survey newSurvey = new survey();
newSurvey.date = tempSurvey.date;
newSurvey.agegroupid = tempSurvey.agegroupid;
newSurvey.genderid = tempSurvey.genderid;
newSurvey.firstname = tempSurvey.firstname;
newSurvey.bednumber = tempSurvey.bednaumber;
newSurvey.phonenumber = tempSurvey.phonenumber;
newSurvey.preferredcontact = tempSurvey.preferredcontact;
newSurvey.contactedyn = tempSurvey.contactedyn;
newSurvey.respondenttypeid = tempSurvey.respondenttypeid;
newSurvey.unitid = tempSurvey.unitid;
newSurveyWithId = context.surveys.Add(newSurvey);
context.SaveChanges();
return(newSurveyWithId.surveyid);
}
}
public void SaveSurvey(string surveyName, int id, string surveyMetadata, string endOfLife)
{
try
{
survey addsurvey = new survey
{
name = surveyName,
userid = id,
metadata = surveyMetadata,
creationDate = DateTime.Now.ToShortDateString(),
endDate = endOfLife
};
SurveyPortalDBDataContext sql = new SurveyPortalDBDataContext();
sql.surveys.InsertOnSubmit(addsurvey);
sql.SubmitChanges();
}
catch (Exception e) {}
}
private void attach_surveys(survey entity)
{
this.SendPropertyChanging();
entity.user = this;
}
private void detach_surveys(survey entity)
{
this.SendPropertyChanging();
entity.user = null;
}
partial void Insertsurvey(survey instance);
// [HttpPost("survey")]
public IActionResult Privacy(survey yourSurvey)
{
return(View("Privacy", yourSurvey));
}
partial void Updatesurvey(survey instance);
partial void Insertsurvey(survey instance);
private void detach_surveys(survey entity)
{
this.SendPropertyChanging();
entity.user = null;
}
private void attach_surveys(survey entity)
{
this.SendPropertyChanging();
entity.user = this;
}
partial void Updatesurvey(survey instance);
public JsonResult CRUDAchievement(survey svy, char ch)
{
return(Json(ppicdb.CRUDAchievement(svy, ch), JsonRequestBehavior.AllowGet));
}
partial void Deletesurvey(survey instance);
public JsonResult CRUDRejectCustomer(survey svy, char ch)
{
return(Json(ppicdb.CRUDRejectCustomer(svy, ch), JsonRequestBehavior.AllowGet));
}
partial void Deletesurvey(survey instance);
