/// <summary>
/// Email the request via Send Grid
/// </summary>
/// <param name="inboundData"> Message object with form input </param>
/// <returns> EmailResponse object with success bool </returns>
public async Task <EmailResponse> SendEmailAsync(RequestForm inboundData)
{
string key = Configuration["Key"];
string email = Configuration["FromEmail"];
string name = Configuration["FromName"];
var client = new SendGridClient(key);
SendGridMessage message = new SendGridMessage();
message.SetFrom(new EmailAddress(email, name));
message.AddTo("*****@*****.**");
message.SetTemplateId("d-a040e40c67a44f9fa18aa2762c9aadfc");
message.SetTemplateData(new SendGridTemplate
{
name = inboundData.Name,
email = inboundData.Email,
body = inboundData.Body,
availability = inboundData.Availability,
uris = inboundData.Uris
});
var response = await client.SendEmailAsync(message);
return(new EmailResponse()
{
WasSent = response.IsSuccessStatusCode
});
}
public void UpdateRequestForm(int id, RequestForm requestForm)
{
var request = requestForm.ToDictionary();
using (var sqlConnection = new SqlConnection(DatabaseHelper.BIRequestConnectionString))
using (var sqlCommand = new SqlCommand())
{
var sqlQuery = string.Format("UPDATE {0} SET ", DatabaseHelper.BiRequestTable);
foreach (var property in request.Where(p => p.Value != null).Where(p => p.Key != "Id"))
{
object value;
if (property.Value is DateTime)
{
value = DataTransformer.ConvertDateToIso8601(property.Value as DateTime?);
}
else
{
value = property.Value;
}
var parameter = "@" + property.Key;
sqlQuery += property.Key + "=" + parameter + ",";
sqlCommand.Parameters.AddWithValue(parameter, value);
}
sqlQuery = sqlQuery.Remove(sqlQuery.Length - 1) + " WHERE Id=@Id;";
sqlCommand.Parameters.AddWithValue("@Id", id);
sqlCommand.CommandText = sqlQuery;
sqlCommand.Connection = sqlConnection;
sqlConnection.Open();
sqlCommand.ExecuteNonQuery();
sqlConnection.Close();
}
}
public bool sendMovesRequest(RequestForm req, string sendTo)
{
bool isSent = false;
if (req == null)
{
throw new ArgumentNullException("req");
}
if (sendTo == null)
{
throw new ArgumentNullException("sendTo");
}
if (sendTo == "HR")
{
_template.addRecipient(HRAddress);
isSent = sendMovesRequest(req);
}
else if (sendTo == "SD")
{
_template.addRecipient(SDAddress);
isSent = sendMovesRequest(req);
}
return(isSent);
}
public void ModifyRoomConfig(Jid room, RegistrationCallback callback)
{
RequestForm form = RequestRoomConfigForm(room);
SubmitForm submit = callback.Invoke(form);
SubmitRoomConfigForm(room, submit);
}
public ActionResult RequestCreate([Bind(Include = "RequestTitle,StudentPhone,Class,Description")] RequestForm requestForm, Form form)
{
if (ModelState.IsValid)
{
//Form form = new Form();
form.Type = "General Request";
form.Date = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById("SE Asia Standard Time"));
form.CurrentDesk = "Academic-Staff";
form.Flow = "Academic-Staff,";
form.FormDetails = "General Request: " + requestForm.RequestTitle;
form.SemesterName = Helper.Help.GetCurrentSemester();
ArrayList UserDetails = DAL.Users.GetUser();
form.StudentRollNo = Users.GetStudentRollNo(UserDetails[0].ToString(), UserDetails[1].ToString());
form.StudentEmail = UserDetails[2].ToString();
form.StudentName = UserDetails[0].ToString();
form.Status = "New";
db.Forms.Add(form);
db.SaveChanges();
requestForm.FormID = form.ID;
db.RequestForms.Add(requestForm);
db.SaveChanges();
return(RedirectToAction("Index", "Student"));
}
ViewBag.FormID = new SelectList(db.Forms, "ID", "Type", requestForm.FormID);
return(View(requestForm));
}
public VAFormService()
{
var workflow = DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.Workflow);
var docWorkflow = DbContextSelector.getInstance().getDbFactory(DbContextSelector.DbName.WorkflowDoc);
BC = new RequestForm(workflow, docWorkflow);
}
public int InsertRequestForm(RequestForm requestForm)
{
int createdItemId;
var sqlQuery = string.Format("INSERT INTO {0} (RequestorName, RequestorId, DateRequested, DateRequired, ExecutiveSponsor, ExecutiveSponsorId, RequestName, RequestTypeId, RequestNature, InformationRequired, ParametersRequired, GroupingRequirements, PeopleToShare, Comments, DateReviewed, EstimatedHours, BusinessCaseId, AdminComments, CreatedOn) " +
"VALUES (@RequestorName, @RequestorId, @DateRequested, @DateRequired, @ExecutiveSponsor, @ExecutiveSponsorId, @RequestName, @RequestTypeId, @RequestNature, @InformationRequired, @ParametersRequired, @GroupingRequirements, @PeopleToShare, @Comments, @DateReviewed, @EstimatedHours, @BusinessCaseId, @AdminComments, @CreatedOn); SELECT SCOPE_IDENTITY();", DatabaseHelper.BiRequestTable);
using (var sqlConnection = new SqlConnection(DatabaseHelper.BIRequestConnectionString))
using (var sqlCommand = new SqlCommand(sqlQuery, sqlConnection))
{
sqlCommand.Parameters.AddWithValue("@RequestorId", (object)requestForm.RequestorId ?? DBNull.Value);
sqlCommand.Parameters.AddWithValue("@RequestorName", (object)requestForm.RequestorName ?? DBNull.Value);
sqlCommand.Parameters.AddWithValue("@DateRequested", DataTransformer.ConvertDateToIso8601(requestForm.DateRequested) ?? DBNull.Value);
sqlCommand.Parameters.AddWithValue("@DateRequired", DataTransformer.ConvertDateToIso8601(requestForm.DateRequired) ?? DBNull.Value);
sqlCommand.Parameters.AddWithValue("@ExecutiveSponsorId", (object)requestForm.ExecutiveSponsorId ?? DBNull.Value);
sqlCommand.Parameters.AddWithValue("@ExecutiveSponsor", (object)requestForm.ExecutiveSponsor ?? DBNull.Value);
sqlCommand.Parameters.AddWithValue("@RequestName", (object)requestForm.RequestName ?? DBNull.Value);
sqlCommand.Parameters.AddWithValue("@RequestTypeId", (object)requestForm.RequestTypeId ?? DBNull.Value);
sqlCommand.Parameters.AddWithValue("@RequestNature", (object)requestForm.RequestNature ?? DBNull.Value);
sqlCommand.Parameters.AddWithValue("@InformationRequired", (object)requestForm.InformationRequired ?? DBNull.Value);
sqlCommand.Parameters.AddWithValue("@ParametersRequired", (object)requestForm.ParametersRequired ?? DBNull.Value);
sqlCommand.Parameters.AddWithValue("@GroupingRequirements", (object)requestForm.GroupingRequirements ?? DBNull.Value);
sqlCommand.Parameters.AddWithValue("@PeopleToShare", (object)requestForm.PeopleToShare ?? DBNull.Value);
sqlCommand.Parameters.AddWithValue("@Comments", (object)requestForm.Comments ?? DBNull.Value);
sqlCommand.Parameters.AddWithValue("@DateReviewed", DataTransformer.ConvertDateToIso8601(requestForm.DateReviewed) ?? DBNull.Value);
sqlCommand.Parameters.AddWithValue("@EstimatedHours", (object)requestForm.EstimatedHours ?? DBNull.Value);
sqlCommand.Parameters.AddWithValue("@BusinessCaseId", (object)requestForm.BusinessCaseId ?? DBNull.Value);
sqlCommand.Parameters.AddWithValue("@AdminComments", (object)requestForm.AdminComments ?? DBNull.Value);
sqlCommand.Parameters.AddWithValue("@CreatedOn", DateTime.Now);
sqlConnection.Open();
createdItemId = Convert.ToInt32(sqlCommand.ExecuteScalar());
sqlConnection.Close();
}
return(createdItemId);
}
public ActionResult RequestEdit([Bind(Include = "FormID,RequestTitle,StudentPhone,StudentEmail,Class,Batch,Description")] RequestForm requestForm, Form form)
{
if (ModelState.IsValid)
{
form = db.Forms.Find(requestForm.FormID);
form.Type = "General Request";
form.Date = TimeZoneInfo.ConvertTime(DateTime.Now, TimeZoneInfo.FindSystemTimeZoneById("SE Asia Standard Time"));
form.CurrentDesk = "Academic-Staff";
form.Flow = "Academic-Staff,";
form.FormDetails = "General Request: " + requestForm.RequestTitle;
form.SemesterName = Helper.Help.GetCurrentSemester();
db.Entry(requestForm).State = EntityState.Modified;
db.Entry(form).State = EntityState.Modified;
db.SaveChanges();
if (DAL.UserInfo.Role.Equals("Student"))
{
return(RedirectToAction("Index", "Student"));
}
else if (DAL.UserInfo.Role.Contains("Staff"))
{
return(RedirectToAction("Index", "Staff"));
}
else
{
return(RedirectToAction("Index", "Home"));
}
}
ViewBag.FormID = new SelectList(db.Forms, "ID", "Type", requestForm.FormID);
return(View(requestForm));
}
public void showAdminDashBoard(RequestForm requestForm, AdminDashBoard adminDashboard)
{
requestForm.Close();
adminDashboard.loadPendingRequests();
adminDashboard.loadApprovedRequests();
adminDashboard.Show();
}
public RequestForm GetRequest(Guid requestID)
{
if (this.reader == null)
{
return(null);
}
RequestForm temp = null;
while (this.reader.Read())
{
temp = new RequestForm()
{
CreatedByID = GetCreateByID(),
Current = MakeCurrentInfo(),
Future = MakeFutureInfo(),
EmailInfo = MakeEmailInfo(),
EmployeeId = GetEmployeeID(),
ReviewInfo = MakeReviewInfo(),
UniqueId = requestID,
};
break;
}
return(temp);
}
public RequestForm makeRequestForm(JObject json)
{
string currManagerName = (string)json["current"]["bazookaInfo"]["managerId"];
string futureManagerName = (string)json["future"]["bazookaInfo"]["managerId"];
int managerID = GetIDFromName(currManagerName);
int f_managerID = GetIDFromName(futureManagerName);
json["current"]["bazookaInfo"]["managerId"] = managerID;
json["current"]["ultiproInfo"]["supervisor"] = managerID;
json["future"]["bazookaInfo"]["managerId"] = f_managerID;
json["future"]["ultiproInfo"]["supervisor"] = f_managerID;
UserController uc = new UserController();
string[] name = uc.GetUserName().Split('.');
string creatorName = name[0] + " " + name[1];
int creatorID = GetIDFromName(creatorName);
RequestForm obj = null;
using (var sr = new StringReader(json.ToString()))
using (var jr = new JsonTextReader(sr))
{
var js = new JsonSerializer();
obj = (RequestForm)js.Deserialize <RequestForm>(jr);
}
obj.EmployeeId = GetIDFromName((string)json["name"]);
obj.CreatedByID = creatorID;
obj.Current.BazookaInfo.SecurityItemRights = "";
obj.ReviewInfo.FilesToBeRemovedFrom = "(" + obj.Current.BazookaInfo.Group + ")" + currManagerName.Replace(" ", ".") + " " + obj.ReviewInfo.FilesToBeRemovedFrom;
obj.ReviewInfo.FilesToBeAddedTo = "(" + obj.Future.BazookaInfo.Group + ")" + futureManagerName.Replace(" ", ".") + " " + obj.ReviewInfo.FilesToBeAddedTo;
return(obj);
}
public void showRequestFormById(AdminDashBoard adminDashBoard, int requestId)
{
adminDashBoard.Hide();
RequestForm requestForm = new RequestForm(adminDashBoard, requestId);
requestForm.Show();
}
private void SendMail(RequestForm requestList)
{
string contentHtml = string.Empty;
using (StreamReader reader = new StreamReader(Server.MapPath("~/Files/Templates/RequestMailTemplate.html")))
{
contentHtml = reader.ReadToEnd();
}
contentHtml = contentHtml.Replace("{CompanyName}", requestList.CompanyName).Replace("{CompanyRepresentative}", requestList.CompanyRepresentative).Replace("{PhoneNumber}", requestList.PhoneNumber).Replace("{TaxNumber}", requestList.TaxNumber)
.Replace("{ProductOfInterest}", requestList.ProductOfInterest).Replace("{MailAddress}", requestList.MailAddress).Replace("{Quantity}", requestList.Quantity.ToString())
.Replace("{City}", requestList.City)
.Replace("{Explanation}", requestList.Explanation);
MailMessage mail = new MailMessage();
mail.IsBodyHtml = true;
mail.To.Add("*****@*****.**"); //mail gönderilen adres
mail.From = new MailAddress("*****@*****.**"); //maili gönderen adres
mail.Subject = "İletişim Formu";
mail.Body = contentHtml;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com"; //mail serverının host bilgisi
smtp.Port = 587; //mail serverının portu
smtp.UseDefaultCredentials = false;
smtp.EnableSsl = true;
smtp.Credentials = new System.Net.NetworkCredential("*****@*****.**", "1905Sevdasi");
smtp.Send(mail);
}
static SubmitForm RegistrationCallback(RequestForm form)
{
if (!string.IsNullOrEmpty(form.Instructions))
{
Debug.WriteLine(form.Instructions);
}
SubmitForm submitForm = new SubmitForm();
Debug.WriteLine(Username);
TextField textuser = new TextField(form.Fields[0].Name, Username);
submitForm.Fields.Add(textuser);
TextField textpass = new TextField(form.Fields[1].Name, Password);
submitForm.Fields.Add(textpass);
Username = "";
Password = "";
return(submitForm);
}
public async Task <IActionResult> Edit(int id, [Bind("CompanyName,CompanyRepresentative,PhoneNumber,TaxNumber,MailAddress,ProductOfInterest,Quantity,City,Explanation,Id,IsActive,CreatedUserId,CreatedDate,UpdatedUserId,UpdatedDate")] RequestForm requestForm)
{
if (id != requestForm.Id)
{
return(NotFound());
}
if (ModelState.IsValid)
{
try
{
_context.Update(requestForm);
await _context.SaveChangesAsync();
}
catch (DbUpdateConcurrencyException)
{
if (!RequestFormExists(requestForm.Id))
{
return(NotFound());
}
else
{
throw;
}
}
return(RedirectToAction(nameof(Index)));
}
return(View(requestForm));
}
public void Setup()
{
_to = new Collection <string> {
};
_emailer = new EmailSender("New Coyote Moves Request", _to, "*****@*****.**", "Here you go!", "../../../CoyoteMoves/CoyoteMovesTemplate.pdf");
_req = new RequestForm(989);
_template = new EmailTemplate("one", _to, "*****@*****.**", "dere you go", "../../../CoyoteMoves/CoyoteMovesTemplate.pdf");
_falseTemplate = new EmailTemplate("one", _to, "*****@*****.**", "", "../../CoyoteMoves/CoyoteMovesTemplate.pdf");
_req.Current = new CoyoteMovesFormEmployeeInfo();
_req.Future = new CoyoteMovesFormEmployeeInfo();
_req.Current.BazookaInfo = new BazookaInfo();
_req.Future.BazookaInfo = new BazookaInfo();
_req.Current.UltiproInfo = new UltiproInfo();
_req.Future.UltiproInfo = new UltiproInfo();
_req.Current.DeskInfo = new DeskInfo();
_req.Future.DeskInfo = new DeskInfo();
_req.Current.PhoneInfo = new PhoneInfo();
_req.Future.PhoneInfo = new PhoneInfo();
_req.EmailInfo = new EmailDistributionInfo();
_req.ReviewInfo = new EmployeeReviewFileInfo();
_req.Current.BazookaInfo.JobTitle = "test";
_req.Future.BazookaInfo.JobTitle = "test";
_req.Current.BazookaInfo.Department = "test";
_req.Future.BazookaInfo.Department = "test";
_req.Current.BazookaInfo.Group = "test";
_req.Future.BazookaInfo.Group = "test";
_req.Current.BazookaInfo.ManagerID = 49;
_req.Future.BazookaInfo.ManagerID = 50;
_req.Current.BazookaInfo.JobTemplate = "test";
_req.Future.BazookaInfo.JobTemplate = "testy";
_req.Current.BazookaInfo.SecurityItemRights = "test";
_req.Future.BazookaInfo.SecurityItemRights = "test";
_req.Current.UltiproInfo.JobTitle = "test";
_req.Future.UltiproInfo.JobTitle = "test";
_req.Current.UltiproInfo.Department = "test";
_req.Future.UltiproInfo.Department = "test";
_req.Current.UltiproInfo.Supervisor = "120 ";
_req.Future.UltiproInfo.Supervisor = "350";
_req.Current.UltiproInfo.Other = "test";
_req.Future.UltiproInfo.Other = "test?";
_req.Current.DeskInfo.DeskNumber = "test";
_req.Future.DeskInfo.DeskNumber = "test";
_req.Current.DeskInfo.Office = "test";
_req.Future.DeskInfo.Office = "test";
_req.Current.PhoneInfo.PhoneNumber = "8472718339";
_req.Future.PhoneInfo.PhoneNumber = "99995953214";
_req.EmailInfo.GroupsToBeAddedTo = "one, two, three";
_req.EmailInfo.GroupsToBeRemovedFrom = "one, two, three";
_req.ReviewInfo.FilesToBeAddedTo = "one, two, three";
_req.ReviewInfo.FilesToBeRemovedFrom = "one, two, three";
}
protected override string doExecute(string url, RequestForm requestForm, Dictionary <string, string> header)
{
Dictionary <string, object> form = requestForm.Form;
this.encryptData(form);
this.encryptHeader(header);
return(base.doExecute(url, requestForm, header));
}
public Dataport(int id, string name)
: base(id, name)
{
Properties = new DataportProperties(this);
Code = new Code.Variable.Code(this);
RequestForm = new RequestForm(this);
DataItems = new DataportDataItems(this);
}
/// <summary>
/// 创建请求表单
/// </summary>
/// <returns></returns>
public RequestForm CreateRequestForm()
{
Dictionary <string, object> dict = ClassUtil.ConvertObjectToDictionary(this);
RequestForm requestForm = new RequestForm(dict);
requestForm.Files = this.files;
return(requestForm);
}
public ActionResult DeleteConfirmed(int id)
{
RequestForm requestForm = db.request.Find(id);
db.request.Remove(requestForm);
db.SaveChanges();
return(RedirectToAction("Index"));
}
private void reqBtn_Click(object sender, EventArgs e)
{
string projectName = projectGrid.CurrentRow.Cells[1].Value.ToString();
RequestForm frm = new RequestForm(projectName);
frm.Show();
}
public async Task <RequestForm> CreateAsync(RequestForm input)
{
input.CreatedDate = DateTime.UtcNow;
_dbcontext.RequestForms.Add(input);
await _dbcontext.SaveChangesAsync();
return(input);
}
public string SendMailAndSaveRequestForm(RequestForm requestList)
{
DataContext db = new DataContext();
db.RequestForm.Add(requestList);
SendMail(requestList);
db.SaveChanges();
return(JsonConvert.SerializeObject(""));
}
public void Register(RegistrationCallback callback)
{
callback.ThrowIfNull <RegistrationCallback>("callback");
Iq errorIq = base.im.IqRequest(IqType.Get, null, null, Xml.Element("query", "jabber:iq:register"), null, -1, "");
if (errorIq.Type == IqType.Error)
{
throw new NotSupportedException("The XMPP server does not support the 'In-Band Registration' extension.");
}
XmlElement query = errorIq.Data["query"];
if ((query == null) || (query.NamespaceURI != "jabber:iq:register"))
{
throw new XmppException("Erroneous server response: " + errorIq);
}
if (query["registered"] != null)
{
throw new XmppException("The XMPP entity is already registered.");
}
XmlElement element2 = query["data"];
if ((element2 != null) && (element2.NamespaceURI == "urn:xmpp:bob"))
{
BobData bob = BobData.Parse(element2);
this.bob.Add(bob);
}
RequestForm form = null;
bool flag = query["x"] != null;
if (flag)
{
form = DataFormFactory.Create(query["x"]) as RequestForm;
}
else
{
form = this.CreateDataForm(query);
}
SubmitForm form2 = callback(form);
XmlElement e = Xml.Element("query", "jabber:iq:register");
if (flag)
{
e.Child(form2.ToXmlElement());
}
else
{
foreach (DataField field in form2.Fields)
{
e.Child(Xml.Element(field.Name, null).Text(field.Values.FirstOrDefault <string>()));
}
}
errorIq = base.im.IqRequest(IqType.Set, null, null, e, null, -1, "");
if (errorIq.Type == IqType.Error)
{
throw Util.ExceptionFromError(errorIq, "The registration could not be completed.");
}
}
public void RequestRetrievedSuccessfully()
{
RequestForm testRequest = new RequestForm();
testRequest = _requester.RetrieveRequest(_req.UniqueId);
bool test = CheckEquality(_req, testRequest);
Assert.IsTrue(test);
}
public ActionResult Edit([Bind(Include = "ID,FirstName,LastName,PhoneNumber,ApartmentName,UnitNumber,Description,Permission")] RequestForm requestForm)
{
if (ModelState.IsValid)
{
db.Entry(requestForm).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction("Index"));
}
return(View(requestForm));
}
private void reqBtn_Click(object sender, EventArgs e)
{
DataGridViewRow row = clientGrid.CurrentRow;
int id = Int32.Parse(row.Cells[0].Value.ToString());
string name = row.Cells[1].Value.ToString();
RequestForm frm = new RequestForm(name, id);
frm.Show();
}
public async Task <IActionResult> Create([Bind("CompanyName,CompanyRepresentative,PhoneNumber,TaxNumber,MailAddress,ProductOfInterest,Quantity,City,Explanation,Id,IsActive,CreatedUserId,CreatedDate,UpdatedUserId,UpdatedDate")] RequestForm requestForm)
{
if (ModelState.IsValid)
{
_context.Add(requestForm);
await _context.SaveChangesAsync();
return(RedirectToAction(nameof(Index)));
}
return(View(requestForm));
}
public ActionResult Create([Bind(Include = "ID,FirstName,LastName,PhoneNumber,ApartmentName,UnitNumber,Description,Permission")] RequestForm requestForm)
{
if (ModelState.IsValid)
{
db.request.Add(requestForm);
db.SaveChanges();
return(RedirectToAction("ThanksPage"));
}
return(View(requestForm));
}
public JsonResult SubmitCabRequest(RequestForm f)
{
string smsBody = f.FirstName + " " + f.LastName + " has request a cab at" + f.JourneyTime + " for date " + f.JourneyDate;
smsBody += ". Pickup loacation: " + f.PickUpLocation;
smsBody += ". Destination: " + f.Destination;
smsBody += ". Contact: " + f.Contact;
var restult = SendSMS("CI00194622", "*****@*****.**", "VtwuV4b5", deepakJioNumber, smsBody);
return(Json('1'));
//return Json('0');
}
