// DELETE api/<controller>/5
public void Delete(int id)
{
using (var ctx = new TicketEntities())
{
var entity = ctx.tTicket.SingleOrDefault(p => p.TicketId == id);
if (entity != null)
{
ctx.tTicket.Remove(entity);
ctx.SaveChanges();
}
}
}
/// <summary>
/// 提交数据库变更
/// </summary>
/// <param name="dbContext">数据库上下文</param>
/// <returns></returns>
protected virtual int SaveDbChanges(TicketEntities dbContext)
{
try
{
return(dbContext.SaveChanges());
}
catch (DbEntityValidationException ex)
{
LogDatabaseError(ex);
throw;
}
catch (Exception ex)
{
throw;
}
}
// PUT api/<controller>/5
public void Put(int id, [FromBody] tTicket value)
{
using (var ctx = new TicketEntities())
{
var entity = ctx.tTicket.SingleOrDefault(p => p.TicketId == id);
if (entity == null)
{
return;
}
ctx.tTicket.Attach(value);
ctx.Entry(value).State = System.Data.Entity.EntityState.Modified;
ctx.SaveChanges();
}
}
/* Module Name: Signup_Click;
* Student: Mayank Yadav
* Modification Date: 23-April-2018
* Description: Insert the record in CLient Table
* Input/Outputs: Fullname, Username , password, confirm password and other details
* Globals: No global changes.
*/
protected void Signup_Click(object sender, EventArgs e)
{
TicketEntities te = new TicketEntities();
string fullname = Fullname.Text;
string gender = Gender.Text;
string email = username.Text;
string password = pass_word.Text;
string confirm_password = confirmpassword.Text;
string streetaddress1 = StreetAddress1.Text;
string streetaddress2 = StreetAddress2.Text;
string city = City.Text;
string state = State.Text;
string country = Country.Text;
string zip = Zip.Text;
if (fullname != null && email != null && password != null && confirm_password != null && password.Equals(confirm_password))
{
Client st = new Client()
{
FullName = fullname,
Gender = gender,
Email = email,
Password = password,
StreetAddress1 = streetaddress1,
StreetAddress2 = streetaddress2,
City = city,
State = state,
Country = country,
Zip = zip
};
te.Clients.Add(st);
try
{
te.SaveChanges();
Response.Redirect("ClientLogin.aspx");
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
else
{
Response.Redirect(Request.RawUrl);
}
}
public ActionResult Create(Ticket tkt)
{
if (ModelState.IsValid)
{
MailSender.SendMail("*****@*****.**", tkt.konu, tkt.problem);
using (TicketEntities TicketDb = new TicketEntities())
{
tkt.name = Session["Username"].ToString();;
tkt.surname = Session["Surname"].ToString();
tkt.SenderId = (int)Session["UserId"];
tkt.tarih = DateTime.Now;
tkt.okundu = 0;
TicketDb.Ticket.Add(tkt);
TicketDb.SaveChanges();
}
ModelState.Clear();
return(RedirectToAction("CustomerLogin"));
}
else
{
return(View("CustomerLogin"));
}
}
/* Module Name: LinkButtonCreate_Click;
* Student: Mayank Yadav
* Modification Date: 23-April-2018
* Description: Creates a ticket and store the value in database (Ticket_Master and Ticket_Activity)
* Input/Outputs: Takes all the required values from form and if successful redirect you to Client Dashboard
* Globals: No global changes.
*/
protected void LinkButtonCreate_Click(object sender, EventArgs e)
{
string username = Session["ClientUser"].ToString();
TicketEntities te = new TicketEntities();
Console.WriteLine("Username: "******"Web";
string Cate_gory = category.Text;
string Sub_ject = subject.Text;
int Prior = 2;;
string Descript_ion = Request.Form["description"].ToString();
if (Full_name != null && Ticket_source != null && Cate_gory != null && Sub_ject != null &&
Prior != 0 && Descript_ion != null && notBlocked == true)
{
byte[] Byte_prior = BitConverter.GetBytes(Prior);
byte Single_byte = Byte_prior[0];
Ticket_Master tm = new Ticket_Master()
{
Email = E_mail,
FullName = Full_name,
CreatedBy = clientid,
CreationDate = DateTime.Now,
TicketSource = Ticket_source,
Category = Cate_gory,
Subject = Sub_ject,
TicketStatus = "New",
Priority = Single_byte,
IsDeleted = false
};
te.Ticket_Master.Add(tm);
Ticket_Activity ta = new Ticket_Activity()
{
ActivityType = "Create",
Summary = Sub_ject,
Description = Descript_ion,
ActivityDate = DateTime.Now,
ActedBy = clientid,
ActorName = "End User",
Unread = false
};
tm.Ticket_Activity.Add(ta);
try
{
te.SaveChanges();
Response.Redirect("ClientDashboard.aspx");
}
catch (Exception ex)
{
Console.WriteLine(ex.ToString());
}
}
}
else
{
Response.Redirect("ClientLogin.aspx");
}
}