public void addMaintenceRequest(MaintenceRequestModel requestInfo)
{
SqlCommand cmd = new SqlCommand("Insert into MaintenceRequests values (@RequestDate, @RequestDetails, @user, @unit, isnull((select ResidentID from Residents where unitid = @unit and MoveOutDate is null), 0) ,@propID);");
cmd.Parameters.Add("@RequestDate", SqlDbType.DateTime).Value = requestInfo.RequestDate;
cmd.Parameters.Add("@RequestDetails", SqlDbType.VarChar, 6000).Value = requestInfo.RequestDetails;
cmd.Parameters.Add("@user", SqlDbType.Int).Value = requestInfo.UserID;
cmd.Parameters.Add("@unit", SqlDbType.Int).Value = requestInfo.UnitID;
cmd.Parameters.Add("@propID", SqlDbType.Int).Value = requestInfo.PropertyID;
ExecuteNonQuery(cmd);
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
MaintenceBL main = new MaintenceBL();
MaintenceRequestModel mainData = new MaintenceRequestModel();
mainData.RequestDate = DateTime.Now;
mainData.RequestDetails = txtIssue.Value;
mainData.UserID = Sess.Person.UserID;
if (int.TryParse(txtUnitID.Value, out int unitID))
{
mainData.UnitID = unitID;
}
mainData.PropertyID = Sess.ActivePropertyID;
main.AddMaintenceRequest(mainData);
Response.Redirect("MaintenceRequest.aspx");
}
public void AddMaintenceRequest(MaintenceRequestModel requestInfoIn)
{
MaintenceDAL requestSav = new MaintenceDAL();
requestSav.addMaintenceRequest(requestInfoIn);
}