public ActionResult GetApplication(string application)
{
if (Session["key"] != null)
{
dynamic param = new ExpandoObject();
param.application_id = application;
param.access_key = Session["key"].ToString();
param.mode = "preview";
var client = new HttpClient();
client.BaseAddress = new Uri("http://server-erp2.sma.gov.jm:1786/api/data/");
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
var content = new StringContent(JsonConvert.SerializeObject(param), Encoding.UTF8, "application/json");
HttpResponseMessage response = client.PostAsync("GetApplication", content).Result;
if (response.IsSuccessStatusCode)
{
string result = response.Content.ReadAsStringAsync().Result;
Models.Form form = JsonConvert.DeserializeObject <Models.Form>(result);
return(Json(new { form }, JsonRequestBehavior.AllowGet));
}
else
{
return(Json(new { responseText = "unavailable" }, JsonRequestBehavior.AllowGet));
}
}
else
{
return(Json(new { responseText = "session_invalid" }, JsonRequestBehavior.AllowGet));
}
}
public static Models.Form Create(string name, double totalCost)
{
if (string.IsNullOrEmpty(name))
{
name = SessionManager.Get(SessionManager.Keys.FullName).ToString() + " , " + DateTime.Now.ToString();
}
ExpenseEntities db = new ExpenseEntities();
Models.Form form = new Models.Form();
form.Id = Guid.NewGuid();
form.Date = DateTime.Now;
form.Description = SessionManager.Get(SessionManager.Keys.FullName).ToString() + " Adlı kullanıcının" + DateTime.Now.ToString() + "Tarihli Formu";
form.Name = name;
form.OwnerId = Guid.Parse((SessionManager.Get(SessionManager.Keys.UserId).ToString()));
State state = (State)db.States.Where(s => s.Name == "Pending").FirstOrDefault();
form.StateId = state.Id;
form.Total = (int)totalCost;
db.Forms.Add(form);
db.SaveChanges();
return(form);
}
public async Task <IActionResult> PostEvent([FromBody] Models.Form @form)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
_context.Forms.Add(@form);
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateException)
{
if (FormExists(@form.FormId))
{
return(new StatusCodeResult(StatusCodes.Status409Conflict));
}
else
{
throw;
}
}
return(CreatedAtAction("GetForm", new { id = @form.FormId }, @form));
}
public async Task <IActionResult> Edit(int id, [Bind("Id,Type,Name,Label,Description,DateCreate,DateUpdate")] Models.Form form)
{
if (id != form.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
form.Type = 1;
_context.Update(form);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!FormExists(form.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(form));
}
public async Task <IActionResult> PutForm([FromRoute] int id, [FromBody] Models.Form @form)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != @form.FormId)
{
return(BadRequest());
}
_context.Entry(@form).State = EntityState.Modified;
try
{
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!FormExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(NoContent());
}
public ActionResult FormDetails(int ID)
{
db = new Models.ProjeEntities1();
Models.Form form = db.Forms.Where(x => x.userId == ID).FirstOrDefault();
return(View(form));
}
public async Task <IActionResult> Create([Bind("Name,Description")] Models.Form form)
{
if (ModelState.IsValid)
{
form.DateCreate = DateTime.Now;
_context.Add(form);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Fields), new { id = form.Id }));
}
return(View(form));
}
public string AddForm([FromBody] Models.Form form)
{
if (ModelState.IsValid)
{
if (form.Name == form.Password)
{
ModelState.AddModelError("", "name and password do not coincide");
}
}
return("success");
}
public IActionResult Result(string Name, string Locations, string Languages, string Comments)
{
Models.Form info = new Models.Form(Name, Locations, Languages, Comments);
TryValidateModel(info);
if (ModelState.IsValid)
{
return(View("results", info));
}
else
{
return(View("index"));
}
}
public ActionResult Save(FormCollection form)
{
List <string> names, dates, descriptions, costs;
//Get values
names = new List <string>(form.GetValues("name[]"));
dates = new List <string>(form.GetValues("date[]"));
descriptions = new List <string>(form.GetValues("description[]"));
costs = new List <string>(form.GetValues("cost[]"));
string formName = string.Empty;
//Create new form
if (!string.IsNullOrEmpty(form["formName"]))
{
formName = form["formName"];
}
// TODO: validation
double totalCost = costs.Sum(c => double.Parse(c));
Models.Form newForm = new Models.Form();
newForm = FormHelper.Create(formName, totalCost);
using (ExpenseEntities db = new ExpenseEntities())
{
Models.Expense expense;
for (int i = 0; i < names.Count; i++)
{
expense = new Models.Expense();
expense.Id = Guid.NewGuid();
expense.Name = names[i];
expense.Date = DateTime.Parse(dates[i]);
expense.Description = descriptions[i];
expense.Cost = int.Parse(costs[i]);
expense.FormId = newForm.Id;
expense.StateId = newForm.StateId;
db.Expenses.Add(expense);
}
db.SaveChanges();
}
return(RedirectToAction("New", "Expense"));
}
public IActionResult Create(Models.Form form)
{
if (form.Name == form.Password)
{
ModelState.AddModelError("", "name and password do not coincide");
}
if (ModelState.IsValid)
{
return(Content($"{form.Name} - {form.Email}"));
}
return(View(form));
}
public ActionResult CreateForm(String[] jsonData)
{
string[] list = jsonData[4].Split(',');
int[] positionIds = new int[list.Length];
for (int i = 0; i < list.Length; i++)
{
positionIds[i] = Convert.ToInt32(list[i]);
}
Form form = new Models.Form
{
Name = jsonData[0],
Status = Models.Form.FormStatus.Template,
FormData = jsonData[2]
};
_db.form.Add(form);
_db.SaveChanges();
Workflow workFlow = new Models.Workflow
{
FormId = form.Id
};
List <Positions> positions = new List <Positions>();
for (int i = 0; i < positionIds.Length; i++)
{
positions.Add(_db.position.Find(positionIds[i]));
}
workFlow.Positions = positions;
_db.flow.Add(workFlow);
_db.SaveChanges();
form.WorkflowId = workFlow.FlowId;
_db.SaveChanges();
return(View());
}
protected override void Save()
{
Models.Form f = new Models.Form();
f.Lp = Int32.Parse(txtLp.Text);
f.Info = txtInfo.Text;
f.FormStatusId = Int32.Parse(comboStatus.SelectedValue.ToString());
f.SeniorId = Int32.Parse(comboSenior.SelectedValue.ToString());
f.WorkerId = Int32.Parse(comboWorker.SelectedValue.ToString());
f.RegistrationDate = new DateTime(dtRegistDate.Value.Year, dtRegistDate.Value.Month, dtRegistDate.Value.Day);
f.RepairDate = new DateTime(dtRepairDate.Value.Year, dtRepairDate.Value.Month, dtRepairDate.Value.Day);
GoldenHandContext.Instance.Forms.Add(f);
GoldenHandContext.Instance.SaveChanges();
MessageBox.Show("Dodano formularz.");
ReloadForms?.Invoke(btnSave, new FormEventArgs(f));
Close();
}
public ActionResult Approve(Guid id)
{
Models.Form form = new Models.Form();
ExpenseEntities db = new ExpenseEntities();
form = db.Forms.Where(f => f.Id == id).FirstOrDefault();
State state = db.States.Where(s => s.Name == "Approved").FirstOrDefault();
form.StateId = state.Id;
List <Models.Expense> expenses = new List <Models.Expense>();
expenses = db.Expenses.Where(e => e.FormId == id).ToList();
foreach (Models.Expense e in expenses)
{
e.StateId = state.Id;
}
db.SaveChanges();
return(RedirectToAction("List", "Form"));
}
public ActionResult MoreTables(int id)
{
var model = new Models.Form()
{
Name = "Name",
Age = 22,
Tel = 0277468,
Email = "*****@*****.**",
Sex = true,
Date = DateTime.Now,
Password = "******"
};
var items = new List <Models.Form>();
items.Add(model);
var result = JsonConvert.SerializeObject(items);
return(Content(result, "application/json"));
}
public ActionResult Yanitla(int ID)
{
db = new Models.ProjeEntities1();
Models.Form form = db.Forms.Where(x => x.userId == ID).FirstOrDefault();
try
{
WebMail.SmtpServer = "smtp.gmail.com";
WebMail.EnableSsl = true;
WebMail.UserName = "******";
WebMail.Password = "******";
WebMail.SmtpPort = 587;
form.userMessage = form.yetkiliMessage;
WebMail.Send(
form.userMail, // alıcının mail adresi
"İş Başvurusu Yanıt", //mailin konusu
form.userMessage, //mailin kendisi
null,
null,
null,
true,
null,
null,
null,
null,
null,
null
);
return(RedirectToAction("Gönderildi"));
}
catch (Exception ex)
{
ViewData.ModelState.AddModelError("_HATA", ex.Message);
return(View("Panel"));
}
}
public static Models.Form Create(string name, double totalCost)
{
if (string.IsNullOrEmpty(name))
{
name = SessionManager.Get(SessionManager.Keys.FullName).ToString() + " , " + DateTime.Now.ToString();
}
ExpenseEntities db = new ExpenseEntities();
Models.Form form = new Models.Form();
form.Id = Guid.NewGuid();
form.Date = DateTime.Now;
form.Description = SessionManager.Get(SessionManager.Keys.FullName).ToString() + " Adlı kullanıcının" + DateTime.Now.ToString() + "Tarihli Formu";
form.Name = name;
form.OwnerId = Guid.Parse((SessionManager.Get(SessionManager.Keys.UserId).ToString()));
State state = (State)db.States.Where(s => s.Name == "Pending").FirstOrDefault();
form.StateId = state.Id;
form.Total = (int)totalCost;
db.Forms.Add(form);
db.SaveChanges();
return form;
}
public static Models.Form UpdateForm(ContentServiceConfiguration settings, Models.Form formToUpdate)
{
using (var client = new HttpClient())
{
client.BaseAddress = new Uri(settings.BaseUrl);
client.DefaultRequestHeaders.Accept.Clear();
client.DefaultRequestHeaders.Accept.Add(new MediaTypeWithQualityHeaderValue("application/json"));
client.DefaultRequestHeaders.Add("api-version", "1.0");
var stringContent = new StringContent(JsonConvert.SerializeObject(formToUpdate),
Encoding.UTF8,
"application/json");
HttpResponseMessage response = client.PutAsync(settings.ResourceRoot + "/forms/" + formToUpdate.FormId.ToString(), stringContent).Result;
if (response.IsSuccessStatusCode)
{
string stringData = response.Content.ReadAsStringAsync().Result;
return(JsonConvert.DeserializeObject <Models.Form>(stringData));
}
}
return(null);
}
public IActionResult G(IFormFile file, string city)
{
var fname = Guid.NewGuid().ToString().Replace("-", "") + System.IO.Path.GetExtension(file.GetFileName());
var path = System.IO.Path.Combine(System.IO.Path.GetTempPath(), fname);
file.SaveAs(path);
string connStr;
if (System.IO.Path.GetExtension(path) == ".xls")
{
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + path + ";" + ";Extended Properties=\"Excel 8.0;HDR=NO;IMEX=1\"";
}
else
{
connStr = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + path + ";" + ";Extended Properties=\"Excel 12.0;HDR=NO;IMEX=1\"";
}
using (var conn = new OleDbConnection(connStr))
{
conn.Open();
var schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
var rows = schemaTable.Rows;
foreach (DataRow r in rows)
{
if (r["TABLE_NAME"].ToString() == "_xlnm#_FilterDatabase")
{
continue;
}
var cmd = new OleDbCommand($"select * from [{r["TABLE_NAME"].ToString()}]", conn);
var adpt = new OleDbDataAdapter(cmd);
var dt = new DataTable();
adpt.Fill(dt);
var text = new List <string>();
text.Add(dt.Rows[1][3].ToString());
text.Add(dt.Rows[1][8].ToString());
text.Add(dt.Rows[2][3].ToString());
text.Add(dt.Rows[2][8].ToString());
text.Add(dt.Rows[3][3].ToString());
text.Add(dt.Rows[3][8].ToString());
text.Add(dt.Rows[4][3].ToString());
text.Add(dt.Rows[4][8].ToString());
text.Add(dt.Rows[5][3].ToString());
text.Add(dt.Rows[5][8].ToString());
text.Add(dt.Rows[6][3].ToString());
text.Add(dt.Rows[6][8].ToString());
text.Add(dt.Rows[7][3].ToString());
text.Add(dt.Rows[7][8].ToString());
text.Add(dt.Rows[8][3].ToString());
text.Add(dt.Rows[8][8].ToString());
text.Add(dt.Rows[9][3].ToString());
text.Add(dt.Rows[9][8].ToString());
text.Add(dt.Rows[10][3].ToString());
text.Add(dt.Rows[10][8].ToString());
var form = new Models.Form
{
City = city,
Content = JsonConvert.SerializeObject(text),
Time = DateTime.Now,
Type = Models.FormType.疑难站址档案
};
DB.Forms.Add(form);
for (var i = 11; i + 3 < dt.Rows.Count; i += 3)
{
var text2 = new List <string>();
text2.Add(dt.Rows[i][3].ToString());
text2.Add(dt.Rows[i][8].ToString());
text2.Add(dt.Rows[i + 1][3].ToString());
text2.Add(dt.Rows[i + 1][8].ToString());
text2.Add(dt.Rows[i + 2][3].ToString());
DB.Forms.Add(new Models.Form
{
City = city,
Time = DateTime.Now,
Type = Models.FormType.疑难站址档案2,
ParentId = form.Id,
Content = JsonConvert.SerializeObject(text2),
});
}
DB.SaveChanges();
}
}
return(RedirectToAction("G", "Form", null));
}
public ActionResult Pay(Guid id)
{
Models.Form form = new Models.Form();
ExpenseEntities db = new ExpenseEntities();
form = db.Forms.Where(f => f.Id == id).FirstOrDefault();
State state = db.States.Where(s => s.Name == "Paid").FirstOrDefault();
form.StateId = state.Id;
List<Models.Expense> expenses = new List<Models.Expense>();
expenses = db.Expenses.Where(e => e.FormId == id).ToList();
foreach (Models.Expense e in expenses)
{
e.StateId = state.Id;
}
db.SaveChanges();
AddExpenseToCrm(form);
return RedirectToAction("List", "Form");
}
public static Models.Form GetFormParser(string content, string id)
{
var obj = JObject.Parse(content);
var result = obj["result"];
string title = result["title"].ToString();
Debug.WriteLine("[Form Parser] - GET - Title: " + title);
List <MultipleChoiceQuestion> multipleChoiceQuestions = new List <MultipleChoiceQuestion>();
List <DiscursiveQuestion> discursiveQuestions = new List <DiscursiveQuestion>();
if (result["multipleChoices"] != null)
{
JArray multipleChoices = (JArray)result["multipleChoices"];
Debug.WriteLine("[Form Parser] - GET - Multiple Choices: " + multipleChoices.ToString());
foreach (JObject question in multipleChoices)
{
string questionTitle = question["question"].ToString();
bool multipleAnswers = question["multiple_anwsers"].ToObject <bool>();
Debug.WriteLine("[Form Parser] - GET - Multiple answers: " + multipleAnswers.ToString());
List <Option> optionsList = new List <Option>();
JArray options = (JArray)question["options"];
foreach (string optionText in options)
{
Option option = new Option {
OptionText = optionText
};
optionsList.Add(option);
Debug.WriteLine("[Form Parser] - GET - Option: " + option.OptionText);
}
Debug.WriteLine("[Form Parser] - GET - Question Title: " + questionTitle);
MultipleChoiceQuestion multipleQuestion = new MultipleChoiceQuestion(questionTitle, multipleAnswers);
foreach (Option option in optionsList)
{
multipleQuestion.Add(option);
}
multipleChoiceQuestions.Add(multipleQuestion);
}
}
if (result["discussive"] != null)
{
JArray discursives = (JArray)result["discussive"];
foreach (JObject question in discursives)
{
Debug.WriteLine("[Form Parser] - GET - Discursive: " + question);
var questionTitle = question["question"].ToString();
discursiveQuestions.Add(new DiscursiveQuestion {
Question = questionTitle
});
}
}
Models.Form newForm = new Models.Form {
Title = title,
MultipleChoiceQuestions = multipleChoiceQuestions,
DiscursiveQuestions = discursiveQuestions,
RemoteId = id
};
return(newForm);
}
public ActionResult Edit(Models.Form form)
{
return(View(form));
}
public ActionResult CreateForm(String[] jsonData)
{
string[] list = jsonData[4].Split(',');
int[] positionIds = new int[list.Length];
for (int i = 0; i < list.Length; i++)
{
positionIds[i] = Convert.ToInt32(list[i]);
}
Form form = new Models.Form
{
Name = jsonData[0],
Status = Models.Form.FormStatus.Template,
FormData = jsonData[2]
};
_db.form.Add(form);
_db.SaveChanges();
Workflow workFlow = new Models.Workflow
{
FormId = form.Id
};
List<Positions> positions = new List<Positions>();
for(int i = 0; i < positionIds.Length; i++)
{
positions.Add(_db.position.Find(positionIds[i]));
}
workFlow.Positions = positions;
_db.flow.Add(workFlow);
_db.SaveChanges();
form.WorkflowId = workFlow.FlowId;
_db.SaveChanges();
return View();
}
public IActionResult G(IFormFile file, string city)
{
var fname = Guid.NewGuid().ToString().Replace("-", "") + System.IO.Path.GetExtension(file.GetFileName());
var path = System.IO.Path.Combine(System.IO.Path.GetTempPath(), fname);
file.SaveAs(path);
string connStr;
if (System.IO.Path.GetExtension(path) == ".xls")
connStr = "Provider=Microsoft.Jet.OLEDB.4.0;" + "Data Source=" + path + ";" + ";Extended Properties=\"Excel 8.0;HDR=NO;IMEX=1\"";
else
connStr = "Provider=Microsoft.ACE.OLEDB.12.0;" + "Data Source=" + path + ";" + ";Extended Properties=\"Excel 12.0;HDR=NO;IMEX=1\"";
using (var conn = new OleDbConnection(connStr))
{
conn.Open();
var schemaTable = conn.GetOleDbSchemaTable(OleDbSchemaGuid.Tables, new object[] { null, null, null, "TABLE" });
var rows = schemaTable.Rows;
foreach (DataRow r in rows)
{
if (r["TABLE_NAME"].ToString() == "_xlnm#_FilterDatabase")
continue;
var cmd = new OleDbCommand($"select * from [{r["TABLE_NAME"].ToString()}]", conn);
var adpt = new OleDbDataAdapter(cmd);
var dt = new DataTable();
adpt.Fill(dt);
var text = new List<string>();
text.Add(dt.Rows[1][3].ToString());
text.Add(dt.Rows[1][8].ToString());
text.Add(dt.Rows[2][3].ToString());
text.Add(dt.Rows[2][8].ToString());
text.Add(dt.Rows[3][3].ToString());
text.Add(dt.Rows[3][8].ToString());
text.Add(dt.Rows[4][3].ToString());
text.Add(dt.Rows[4][8].ToString());
text.Add(dt.Rows[5][3].ToString());
text.Add(dt.Rows[5][8].ToString());
text.Add(dt.Rows[6][3].ToString());
text.Add(dt.Rows[6][8].ToString());
text.Add(dt.Rows[7][3].ToString());
text.Add(dt.Rows[7][8].ToString());
text.Add(dt.Rows[8][3].ToString());
text.Add(dt.Rows[8][8].ToString());
text.Add(dt.Rows[9][3].ToString());
text.Add(dt.Rows[9][8].ToString());
text.Add(dt.Rows[10][3].ToString());
text.Add(dt.Rows[10][8].ToString());
var form = new Models.Form
{
City = city,
Content = JsonConvert.SerializeObject(text),
Time = DateTime.Now,
Type = Models.FormType.疑难站址档案
};
DB.Forms.Add(form);
for (var i = 11; i + 3 < dt.Rows.Count; i += 3)
{
var text2 = new List<string>();
text2.Add(dt.Rows[i][3].ToString());
text2.Add(dt.Rows[i][8].ToString());
text2.Add(dt.Rows[i + 1][3].ToString());
text2.Add(dt.Rows[i + 1][8].ToString());
text2.Add(dt.Rows[i + 2][3].ToString());
DB.Forms.Add(new Models.Form
{
City = city,
Time = DateTime.Now,
Type = Models.FormType.疑难站址档案2,
ParentId = form.Id,
Content = JsonConvert.SerializeObject(text2),
});
}
DB.SaveChanges();
}
}
return RedirectToAction("G", "Form", null);
}
public string Form(Models.Form form)
{
return($"{form.Name}, {form.Age}, {form.Date}, {form.Tel}, {form.Password}, {form.Email}, {form.Sex}");
}
