protected void Button1_Click(object sender, EventArgs e)
{
DataClassesDataContext da = new DataClassesDataContext();
var result1 = from n in da.user
where n.user_name == TextBox3.Text
select n.major;
var result2 = from m in da.project
where m.project_num == DropDownList1.Text
select m.major;
foreach (var n in result1)
{
foreach (var m in result2)
{
if (n != m)
{
ClientScriptManager client = this.ClientScript;
client.RegisterStartupScript(this.GetType(), "55", "<script>alert('专业不符！');history.back()</script>");
return;
}
}
}
proposal p = new proposal();
p.proposal1 = TextBox1.Text;
p.project_num = DropDownList1.Text;
p.teacher_name = DropDownList2.Text;
p.user_name = TextBox3.Text;
p.proposal_num = TextBox2.Text;
da.proposal.InsertOnSubmit(p);
da.SubmitChanges();
GridView1.DataBind();
}
public IHttpActionResult Putproposal(int id, proposal proposal)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != proposal.id)
{
return(BadRequest());
}
db.Entry(proposal).State = EntityState.Modified;
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!proposalExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
public IActionResult Delete([FromBody] proposal ec)
{
string myurl = url + "api/v1/configuration/lpm/proposal?id=" + ec.id.ToString();
string result = DeleteUrl(myurl);
JObject jo = (JObject)JsonConvert.DeserializeObject(result);
switch (Convert.ToInt32(jo["code"]))
{
case 200:
Json("Success");
break;
case 400:
break;
case 410:
break;
case 411:
break;
default:
break;
}
return(Json("Success"));
}
public IHttpActionResult Getproposal(int id)
{
proposal proposal = db.proposal.Find(id);
if (proposal == null)
{
return(NotFound());
}
return(Ok(proposal));
}
public IHttpActionResult Deleteproposal(int id)
{
proposal proposal = db.proposal.Find(id);
if (proposal == null)
{
return(NotFound());
}
db.proposal.Remove(proposal);
db.SaveChanges();
return(Ok(proposal));
}
public void AddPorposal(porposalDto porposaldto)
{
FreeLancer freeLancerobj = db.FreeLance.FirstOrDefault(f => f.ID == porposaldto.freeLancerObjId);
job jobObjjj = db.job.FirstOrDefault(j => j.ID == porposaldto.JobObjId);
proposal newPorposal = new proposal()
{
proposal_time = DateTime.Now,
payment_amount = porposaldto.payment_amount,
freelancer_comment = porposaldto.freelancer_comment,
FreeLancerObj = freeLancerobj,
JobObj = jobObjjj
};
db.proposal.Add(newPorposal);
db.SaveChanges();
}
public proposal Save(proposal proposal)
{
Proposal prop = new Proposal();
prop = _itemRepository.GetId((int)proposal.ProposalId);
if (prop == null)
{
Proposal newProposal = new Proposal();
newProposal.CreatedByUserId = proposal.CreatedByUserId;
newProposal.CreatedDateTime = DateTime.UtcNow;
newProposal.CurrencyId = proposal.CurrencyId;
newProposal.CustomerId = proposal.CustomerId;
newProposal.LastModifiedByUserId = proposal.LastModifiedByUserId;
newProposal.LastModifiedDateTime = DateTime.UtcNow;
newProposal.ModelId = proposal.ModelId;
newProposal.ProposalAmount = proposal.ProposalAmount;
newProposal.ProposalDate = proposal.ProposalDate;
newProposal.ProposalRef = proposal.ProposalRef;
newProposal.SignoffAmount = proposal.SignoffAmount;
newProposal.SignoffDate = DateTime.Parse(proposal.SignoffDate);
newProposal.Status = 1;
newProposal.Title = proposal.Title;
_itemRepository.Add(newProposal);
}
else
{
//prop.CreatedByUserId = proposal.CreatedByUserId;
//prop.CreatedDateTime = DateTime.UtcNow;
prop.CurrencyId = proposal.CurrencyId;
prop.CustomerId = proposal.CustomerId;
prop.LastModifiedByUserId = proposal.LastModifiedByUserId;
prop.LastModifiedDateTime = DateTime.UtcNow;
prop.ModelId = proposal.ModelId;
prop.ProposalAmount = proposal.ProposalAmount;
prop.ProposalDate = proposal.ProposalDate;
prop.ProposalRef = proposal.ProposalRef;
prop.SignoffAmount = proposal.SignoffAmount;
prop.SignoffDate = DateTime.Parse(proposal.SignoffDate);
prop.Status = proposal.Status;
prop.Title = proposal.Title;
_itemRepository.Update(prop);
}
return(proposal);
}
public IActionResult Add([FromBody] proposal ec)
{
string myurl = url + "api/v1/configuration/lpm/proposal";
var postData = JsonConvert.SerializeObject(ec);
string result = PostUrl(myurl, postData);
JObject jo = (JObject)JsonConvert.DeserializeObject(result);
switch (Convert.ToInt32(jo["code"]))
{
case 200:
return(Json("Success"));
case 400:
return(Json("fail"));
}
return(Json("fail"));
}
public IActionResult Save(proposal proposal)
{
var proposalModel = _proposalService.Save(proposal);
return(Ok(proposalModel));
}
partial void Deleteproposal(proposal instance);
partial void Updateproposal(proposal instance);
partial void Insertproposal(proposal instance);
