public object CreateFbk(Feedback feedbk)
{
try
{
tblFeedback fb = new tblFeedback();
fb.Question1 = feedbk.Question1;
fb.Question2 = feedbk.Question2;
fb.Question3 = feedbk.Question3;
fb.Question4 = feedbk.Question4;
fb.Question5 = feedbk.Question5;
db.tblFeedbacks.Add(fb);
db.SaveChanges();
return(new Response
{
Status = "Success",
Message = "SuccessFully Saved."
});
}
catch (Exception)
{
throw;
}
return(new Response
{
Status = "Error",
Message = "Invalid Data."
});
}
//Enter Feedback
public bool createFeedbackAnswer(FeedbackAnswer feedModel)
{
bool result = false;
float fValue = 0;
using (myProjectEntities context = new myProjectEntities())
{
Mapper.CreateMap <FeedbackAnswer, tblFeedbackResult>();
tblFeedbackResult newFeed = Mapper.Map <FeedbackAnswer, tblFeedbackResult>(feedModel);
context.tblFeedbackResults.Add(newFeed);
context.SaveChanges();
var valueFeed = context.tblFeedbackResults.Where(q => q.FK_Feedback_id == feedModel.FK_Feedback_id).Select(q => q.feedback_answer).AsEnumerable();
float d = float.Parse(valueFeed.Aggregate((a, b) => a + b).ToString());
int count = valueFeed.Count();
fValue = d / count;
tblFeedback f = context.tblFeedbacks.Where(q => q.PK_Feedback_id == feedModel.FK_Feedback_id).FirstOrDefault();
f.feedback_value = fValue;
context.Entry(f).State = EntityState.Modified;
context.SaveChanges();
}
return(result);
}
//Get all feedback lectures of by moduleid
public IEnumerable <lectureModel> GetAllFeedbackByModule(int moduleId, int studentId)
{
using (myProjectEntities context = new myProjectEntities())
{
List <tblLecture> allLectures = context.tblLectures.Where(q => q.FK_Module_id == moduleId && q.lecture_status == 1 && q.lecture_date <= System.DateTime.Now).ToList();
List <tblFeedback> feedModel = new List <tblFeedback>();
List <tblLecture> lectModel = new List <tblLecture>();
foreach (tblLecture item in allLectures)
{
tblFeedback d = context.tblFeedbacks.Where(w => w.FK_Lecture_id == item.PK_Lecture_id && System.DateTime.Now <= w.end_date).FirstOrDefault();
////////Look here
if (d != null)
{
var checkStudent = context.tblFeedbackResults.Where(r => r.FK_Student_id == studentId && r.FK_Feedback_id == d.PK_Feedback_id).FirstOrDefault();
if (checkStudent == null)
{
//feedModel.Add(d);
lectModel.Add(item);
}
}
}
Mapper.CreateMap <tblLecture, lectureModel>();
IEnumerable <lectureModel> result = Mapper.Map <IEnumerable <tblLecture>, IEnumerable <lectureModel> >(lectModel);
return(result);
}
}
protected void btnDetails_Click(object sender, EventArgs e)
{
mvFeedback.ActiveViewIndex = 1;
int hash = sender.GetHashCode();
foreach (RepeaterItem item in rFeedback.Items)
{
LinkButton button = item.FindControl("btnDetails") as LinkButton;
if (button.GetHashCode() == hash)
{
TableCell tc = item.FindControl("tcFeedbackID") as TableCell;
int feedbackID = Convert.ToInt32(tc.Text);
using (DatabaseDataContext db = new DatabaseDataContext()) {
tblFeedback feedback = db.tblFeedbacks.Where(x => x.FeedbackID == feedbackID).FirstOrDefault();
tblUser user = db.tblUsers.Where(x => x.UserID == feedback.UserID).FirstOrDefault();
lblFeedbackID.Text = feedback.FeedbackID.ToString();
lblUserID.Text = user.UserID.ToString();
lblFeedbackDate.Text = feedback.FeedbackDate.ToString();
txtFeedbackDescription.Text = feedback.FeedbackDescription.ToString();
feedback.IsSeen = true;
db.SubmitChanges();
}
}
}
}
protected void rptFeedBack_ItemCommand(object source, RepeaterCommandEventArgs e)
{
try
{
if (e.CommandName == "Read")
{
var DC = new DataClassesDataContext();
tblFeedback result = (from u in DC.tblFeedbacks
where u.FeedbackID == Convert.ToInt32(e.CommandArgument)
select u).Single();
if (result.IsRead == true)
{
result.IsRead = false;
}
else
{
result.IsRead = true;
}
DC.SubmitChanges();
}
BindFeedBack();
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["AdminID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "Admin", 0, session, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
protected void rptfb_ItemCommand(object source, RepeaterCommandEventArgs e)
{
try {
var DC = new DataClassesDataContext();
int ID = Convert.ToInt32(e.CommandArgument);
if (e.CommandName == "Notify")
{
tblFeedback result = (from u in DC.tblFeedbacks
where u.FeedBackID == ID
select u).Single();
if (result.IsNotify == true)
{
result.IsNotify = false;
}
else
{
result.IsNotify = true;
}
DC.SubmitChanges();
}
else if (e.CommandName == "View")
{
var str = from obj in DC.tblFeedbacks
join obj1 in DC.tblClients
on obj.ClientID equals obj1.ClientID
where obj.ClientID == obj1.ClientID && obj.Email == obj1.Email && obj.FeedBackID == Convert.ToInt32(e.CommandArgument)
select new
{
Data = obj1.FirstName + " " + obj1.LastName,
obj1.ContactNo,
obj1.ClientID,
obj.FeedBackID,
obj.Email,
obj.Description,
obj.CreatedOn,
obj.IsNotify
};
rptViewDetail.DataSource = str;
rptViewDetail.DataBind();
ScriptManager.RegisterStartupScript(Page, Page.GetType(), "myModal", "$('#myModal').modal({backdrop:'static', keyboard: false});", true);
// upModal.Update();
}
binddata();
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["AdminID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "Admin", 0, session, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
public feedbackModel GetFeedbackByLectureId(int lectureId)
{
using (myProjectEntities context = new myProjectEntities())
{
tblFeedback feed = context.tblFeedbacks.Where(q => q.FK_Lecture_id == lectureId).FirstOrDefault();
Mapper.CreateMap <tblFeedback, feedbackModel>();
feedbackModel result = Mapper.Map <tblFeedback, feedbackModel>(feed);
return(result);
}
}
public ActionResult Detail(int id)
{
tblFeedback feedback = dc.tblFeedbacks.SingleOrDefault(ob => ob.FeedbackId == id);
//ViewBag.Company = (from ob in dc.tblTransportCompanies where ob.CompanyId == feedback.CompanyId select ob).Take(1).SingleOrDefault().CompanyName;
//ViewBag.User = (from ob in dc.tblUsers where ob.UserId == feedback.UserId select ob).Take(1).SingleOrDefault().FirstName;
//string Name = ViewBag.Company;
//string Uname = ViewBag.User;
return(View(feedback));
}
public ActionResult Feedback(FormCollection form)
{
tblFeedback feedback = new tblFeedback();
feedback.Subject = form["txtSubject"];
feedback.Desc = form["txtDesc"];
feedback.CreatedOn = DateTime.Now;
feedback.IsActive = false;
dc.tblFeedbacks.Add(feedback);
dc.SaveChanges();
return(RedirectToAction("Blank", "Home"));
}
public JsonResult Active(int id)
{
tblFeedback feedback = dc.tblFeedbacks.SingleOrDefault(ob => ob.FeedbackId == id);
if (feedback.IsActive == true)
{
feedback.IsActive = false;
}
else
{
feedback.IsActive = true;
}
dc.SaveChanges();
return(Json(feedback.IsActive, JsonRequestBehavior.AllowGet));
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
using (DatabaseDataContext con = new DatabaseDataContext()) {
#region checks
hideAllPlaceholders();
if (SessionManager.UserID == 0)
{
showError("You must be logged in to use this feature!");
return;
}
string EncodedResponse = Request.Form["g-Recaptcha-Response"];
bool IsCaptchaValid = (ReCaptcha.Validate(EncodedResponse) == "true" ? true : false);
if (!IsCaptchaValid)
{
showError("Prove that you are not a robot!");
return;
}
if (string.IsNullOrEmpty(txtFeeddescription.Text))
{
showError("Description is empty!");
return;
}
#endregion
try {
tblFeedback feedback = new tblFeedback {
FeedbackDescription = txtFeeddescription.Text,
FeedbackDate = DateTime.Now,
IsSeen = false,
UserID = SessionManager.UserID
};
con.tblFeedbacks.InsertOnSubmit(feedback);
con.SubmitChanges();
showSuccess("Feeback submitted!");
Utilities.clearAllTextBoxes(viewMain);
NotificationManager.feedbackSent();
} catch (Exception ex) {
showError("Error: " + ex);
}
}
}
public int SaveFeedBack(FeedBackModel model)
{
tblFeedback feedBackObj = new tblFeedback();
if (model != null)
{
feedBackObj.Headline = model.FeedBackHeadline;
feedBackObj.Feedback = model.FeedBack;
feedBackObj.ConsumerProfilePicture = ConvertBase64StringToByteArray(model.ProfilePicture);
feedBackObj.Consumer_ID = db.tblConsumers.Where(x => x.Login_ID == Session.Login_ID).FirstOrDefault().ID;
feedBackObj.ConsumerName = model.UserName;
db.tblFeedbacks.Add(feedBackObj);
db.SaveChanges();
}
return(feedBackObj.ID > 0 ? feedBackObj.ID : 0);
}
public bool createFeedAnswer(int studentId, int lectureId, float answer)
{
bool result = false;
float fValue = 0;
using (myProjectEntities context = new myProjectEntities())
{
int q3 = 0;
var feedId = context.tblFeedbacks.Where(q => q.FK_Lecture_id == lectureId).FirstOrDefault();
FeedbackAnswer feedModel = new FeedbackAnswer();
feedModel.feedback_answer = answer;
feedModel.feedback_date = System.DateTime.Now;
feedModel.FK_Feedback_id = Convert.ToInt32(feedId.PK_Feedback_id);
feedModel.FK_Student_id = studentId;
Mapper.CreateMap <FeedbackAnswer, tblFeedbackResult>();
tblFeedbackResult newFeed = Mapper.Map <FeedbackAnswer, tblFeedbackResult>(feedModel);
context.tblFeedbackResults.Add(newFeed);
q3 = context.SaveChanges();
//Now update feedback value in tblFeedback
//This is because after every submission there is change in the overall feedback value
if (q3 != 0)
{
var valueFeed = context.tblFeedbackResults.Where(q => q.FK_Feedback_id == feedModel.FK_Feedback_id).Select(q => q.feedback_answer).AsEnumerable();
float d = float.Parse(valueFeed.Aggregate((a, b) => a + b).ToString());
int count = valueFeed.Count();
fValue = d / count;
tblFeedback f = context.tblFeedbacks.Where(q => q.PK_Feedback_id == feedModel.FK_Feedback_id).FirstOrDefault();
f.feedback_value = fValue;
context.Entry(f).State = EntityState.Modified;
q3 = context.SaveChanges();
if (q3 != 0)
{
result = true;
}
}
}
return(result);
}
//Create new Feedback
public int createFeedback(feedbackModel feedData)
{
int result = 0;
using (myProjectEntities context = new myProjectEntities())
{
Mapper.CreateMap <feedbackModel, tblFeedback>();
tblFeedback newFeed = Mapper.Map <feedbackModel, tblFeedback>(feedData);
context.tblFeedbacks.Add(newFeed);
int q = context.SaveChanges();
if (q > 0)
{
result = newFeed.PK_Feedback_id;
}
return(result);
}
}
//Get Lecture Data
public IEnumerable <lectureModel> GetLecturesByProfessor(int ProfId, int isFeed)
{
using (myProjectEntities context = new myProjectEntities())
{
List <tblLecture> lectures = new List <tblLecture>();
IEnumerable <tblLecture> pro = context.tblLectures.Where(q => q.FK_Professor_id == ProfId && q.lecture_status == 1).AsEnumerable();
if (isFeed == 1) // If feedback want
{
foreach (tblLecture item in pro)
{
int lectureId = item.PK_Lecture_id;
tblFeedback feed = context.tblFeedbacks.Where(q => q.FK_Lecture_id == lectureId).FirstOrDefault(); // If there is feedback of the lecture
if (feed != null)
{
lectures.Add(item);
}
}
}
else if (isFeed == 0)// if not
{
foreach (tblLecture item in pro)
{
int lectureId = item.PK_Lecture_id;
tblFeedback feed = context.tblFeedbacks.Where(q => q.FK_Lecture_id == lectureId).FirstOrDefault();
if (feed == null)
{
lectures.Add(item);
}
}
}
else if (isFeed == 2) //All lectures
{
lectures = pro.ToList();
}
//IEnumerable<tblLecture> pro = context.tblLectures.Where(q => q.FK_Professor_id == ProfId && q.lecture_status == 1).AsEnumerable();
Mapper.CreateMap <tblLecture, lectureModel>();
IEnumerable <lectureModel> result = Mapper.Map <IEnumerable <tblLecture>, IEnumerable <lectureModel> >(lectures);
return(result);
}
}
//Get FeedBackList by Professor Id
public IEnumerable <feedbackModel> GetFeedbackByProfessor(int ProfId)
{
using (myProjectEntities context = new myProjectEntities())
{
List <tblFeedback> pro = new List <tblFeedback>();
IEnumerable <tblLecture> lectures = context.tblLectures.Where(qq => qq.FK_Professor_id == ProfId).AsEnumerable();
foreach (tblLecture item in lectures)
{
int lectureId = item.PK_Lecture_id;
tblFeedback feed = context.tblFeedbacks.Where(q => q.FK_Lecture_id == lectureId).FirstOrDefault();
if (feed != null)
{
pro.Add(feed);
}
}
Mapper.CreateMap <tblFeedback, feedbackModel>();
IEnumerable <feedbackModel> result = Mapper.Map <IEnumerable <tblFeedback>, IEnumerable <feedbackModel> >(pro);
return(result);
}
}
public IHttpActionResult PosttblFeedback(int orderID, FeedbackDTO dto)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
tblFeedback feedback = new tblFeedback
{
toyID = dto.toyID,
content = dto.content,
cusID = dto.cusID,
status = 0
};
db.tblFeedbacks.Add(feedback);
tblOrderDetail ordDetail = db.tblOrderDetails.FirstOrDefault(detail => detail.id == orderID && detail.toyID == dto.toyID);
ordDetail.isFeedback = true;
db.SaveChanges();
return(CreatedAtRoute("DefaultApi", new { id = dto.id }, dto));
}
public IHttpActionResult PuttblFeedback(int id, FeedbackDTO dto)
{
if (!ModelState.IsValid)
{
return(BadRequest(ModelState));
}
if (id != dto.id)
{
return(BadRequest());
}
tblFeedback feedback = db.tblFeedbacks.Find(dto.id);
if (feedback != null)
{
feedback.status = dto.status;
db.Entry(feedback).State = EntityState.Modified;
}
try
{
db.SaveChanges();
}
catch (DbUpdateConcurrencyException)
{
if (!tblFeedbackExists(id))
{
return(NotFound());
}
else
{
throw;
}
}
return(StatusCode(HttpStatusCode.NoContent));
}
protected void btnfeedback_Click(object sender, EventArgs e)
{
try {
var dc = new DataClassesDataContext();
var data = (from obj in dc.tblClients
where obj.Email == txtemail.Text
select obj).SingleOrDefault();
var data1 = (from obj in dc.tblClients
where obj.Email == txtemail.Text
select obj).Count();
if (data1 > 0)
{
tblFeedback ob = new tblFeedback();
ob.Email = txtemail.Text;
ob.ClientID = Convert.ToInt32(data.ClientID);
ob.Description = txtdis.Text;
ob.IsNotify = true;
ob.CreatedOn = DateTime.Now;
dc.tblFeedbacks.InsertOnSubmit(ob);
dc.SubmitChanges();
}
else
{
errorCode.Visible = true;
}
clear();
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["ClientID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "User", session, 0, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
private void BindData()
{
try
{
rptProRunning.DataSource = ViewProjectObject.ViewProject();
rptProRunning.DataBind();
foreach (RepeaterItem Item in rptProRunning.Items)
{
//---------for Category show-------------
string CategoryName = "---";
HiddenField Category = (HiddenField)Item.FindControl("hidCategory");
if (Category.Value != "")
{
CategoryName = ViewProjectObject.ViewCategory(Convert.ToInt32(Category.Value));
}
Literal ltrCategory = (Literal)Item.FindControl("ltrCategory");
ltrCategory.Text = CategoryName;
//--------for Category show----------------
//---------for Language show---------------
string LanguageName = "---";
HiddenField Language = (HiddenField)Item.FindControl("hidLanguage");
if (Language.Value != "")
{
LanguageName = ViewProjectObject.ViewLanguage(Convert.ToInt32(Language.Value));
}
Literal ltrLanguage = (Literal)Item.FindControl("ltrLanguage");
ltrLanguage.Text = LanguageName;
//---------for Language show----------------
//---------for Client show------------------
string ClientName = "---";
HiddenField Client = (HiddenField)Item.FindControl("hidClient");
if (Client.Value != "")
{
ClientName = ViewProjectObject.ViewClient(Convert.ToInt32(Client.Value));
}
Literal ltrClient = (Literal)Item.FindControl("ltrClient");
ltrClient.Text = ClientName;
//---------for Client show------------------
//---------for Maneger show------------------
string ManagerName = "---";
HiddenField Manager = (HiddenField)Item.FindControl("hidManager");
if (Manager.Value != "")
{
ManagerName = ViewProjectObject.ViewManager(Convert.ToInt32(Manager.Value));
}
Literal ltrManager = (Literal)Item.FindControl("ltrManager");
ltrManager.Text = ManagerName;
//---------for Manger show------------------
//---------for Duration show------------------
string Duration = "---";
string PanddingDays = "---";
HiddenField hdnCreatedOn = (HiddenField)Item.FindControl("hdnCreatedOn");
HiddenField hdnAssignDay = (HiddenField)Item.FindControl("hdnAssignDay");
HiddenField hdnDeadLine = (HiddenField)Item.FindControl("hdnDeadLine");
if (hdnAssignDay.Value != "")
{
TimeSpan Days = Convert.ToDateTime(hdnDeadLine.Value) - Convert.ToDateTime(hdnAssignDay.Value);
Duration = Convert.ToInt32(Days.TotalDays).ToString();
TimeSpan PanddingDay = Convert.ToDateTime(hdnDeadLine.Value) - DateTime.Now;
PanddingDays = Convert.ToInt32(PanddingDay.TotalDays).ToString();
}
else if (hdnAssignDay.Value == "")
{
TimeSpan Days = Convert.ToDateTime(hdnDeadLine.Value) - Convert.ToDateTime(hdnCreatedOn.Value);
Duration = Convert.ToInt32(Days.TotalDays).ToString();
}
Literal ltrDuration = (Literal)Item.FindControl("ltrDuration");
Literal ltrPanddingDays = (Literal)Item.FindControl("lblPanddingDays");
ltrDuration.Text = Duration + " Days";
ltrPanddingDays.Text = PanddingDays + " Days";
//---------for Duration show------------------
}
reptprgpanding.DataSource = ViewProjectObject.ViewProjectPandding();
reptprgpanding.DataBind();
foreach (RepeaterItem Item in reptprgpanding.Items)
{
string CategoryName = "---";
HiddenField Category = (HiddenField)Item.FindControl("hidCategory");
if (Category.Value != "")
{
CategoryName = ViewProjectObject.ViewCategory(Convert.ToInt32(Category.Value));
}
Literal ltrCategory = (Literal)Item.FindControl("ltrCategory");
ltrCategory.Text = CategoryName;
string ClientName = "---";
HiddenField Client = (HiddenField)Item.FindControl("hidClient");
if (Client.Value != "")
{
ClientName = ViewProjectObject.ViewClient(Convert.ToInt32(Client.Value));
}
Literal ltrClient = (Literal)Item.FindControl("ltrClient");
ltrClient.Text = ClientName;
string Duration = "---";
string PanddingDays = "---";
HiddenField hdnCreatedOn = (HiddenField)Item.FindControl("hdnCreatedOn");
HiddenField hdnAssignDay = (HiddenField)Item.FindControl("hdnAssignDay");
HiddenField hdnDeadLine = (HiddenField)Item.FindControl("hdnDeadLine");
if (hdnAssignDay.Value != "")
{
TimeSpan Days = Convert.ToDateTime(hdnDeadLine.Value) - Convert.ToDateTime(hdnAssignDay.Value);
Duration = Convert.ToInt32(Days.TotalDays).ToString();
TimeSpan PanddingDay = Convert.ToDateTime(hdnDeadLine.Value) - DateTime.Now;
PanddingDays = Convert.ToInt32(PanddingDay.TotalDays).ToString();
}
else if (hdnAssignDay.Value == "")
{
TimeSpan Days = Convert.ToDateTime(hdnDeadLine.Value) - Convert.ToDateTime(hdnCreatedOn.Value);
Duration = Convert.ToInt32(Days.TotalDays).ToString();
}
Literal ltrDuration = (Literal)Item.FindControl("ltrDuration");
Literal ltrPanddingDays = (Literal)Item.FindControl("lblPanddingDays");
ltrDuration.Text = Duration + " Days";
ltrPanddingDays.Text = PanddingDays + " Days";
}
reptprjcomplete.DataSource = ViewProjectObject.ViewProjectComplete();
reptprjcomplete.DataBind();
foreach (RepeaterItem Item in reptprjcomplete.Items)
{
var DC = new DataClassesDataContext();
string ManagerName = "---";
HiddenField Manager = (HiddenField)Item.FindControl("hidManager");
Literal ltrPoint = (Literal)Item.FindControl("ltrPoint");
HiddenField hdnProjectID = (HiddenField)Item.FindControl("hdnProjectID");
int cnt = DC.tblFeedbacks.Count(ob => ob.ProjectID == Convert.ToInt32(hdnProjectID.Value));
if (cnt > 0)
{
tblFeedback Point = DC.tblFeedbacks.Single(ob => ob.ProjectID == Convert.ToInt32(hdnProjectID.Value));
ltrPoint.Text = Convert.ToString(Point.FeedBackPoint);
}
else
{
ltrPoint.Text = "---";
}
if (Manager.Value != "")
{
ManagerName = ViewProjectObject.ViewManager(Convert.ToInt32(Manager.Value));
}
Literal ltrManager = (Literal)Item.FindControl("ltrManager");
ltrManager.Text = ManagerName;
string CategoryName = "---";
HiddenField Category = (HiddenField)Item.FindControl("hidCategory");
if (Category.Value != "")
{
CategoryName = ViewProjectObject.ViewCategory(Convert.ToInt32(Category.Value));
}
Literal ltrCategory = (Literal)Item.FindControl("ltrCategory");
ltrCategory.Text = CategoryName;
string ClientName = "---";
HiddenField Client = (HiddenField)Item.FindControl("hidClient");
if (Client.Value != "")
{
ClientName = ViewProjectObject.ViewClient(Convert.ToInt32(Client.Value));
}
Literal ltrClient = (Literal)Item.FindControl("ltrClient");
ltrClient.Text = ClientName;
string Duration = "---";
string PanddingDays = "---";
HiddenField hdnCreatedOn = (HiddenField)Item.FindControl("hdnCreatedOn");
HiddenField hdnAssignDay = (HiddenField)Item.FindControl("hdnAssignDay");
HiddenField hdnDeadLine = (HiddenField)Item.FindControl("hdnDeadLine");
if (hdnAssignDay.Value != "")
{
TimeSpan Days = Convert.ToDateTime(hdnDeadLine.Value) - Convert.ToDateTime(hdnAssignDay.Value);
Duration = Convert.ToInt32(Days.TotalDays).ToString();
TimeSpan PanddingDay = Convert.ToDateTime(hdnDeadLine.Value) - DateTime.Now;
PanddingDays = Convert.ToInt32(PanddingDay.TotalDays).ToString();
}
else if (hdnAssignDay.Value == "")
{
TimeSpan Days = Convert.ToDateTime(hdnDeadLine.Value) - Convert.ToDateTime(hdnCreatedOn.Value);
Duration = Days.TotalDays.ToString();
}
Literal ltrDuration = (Literal)Item.FindControl("ltrDuration");
Literal ltrPanddingDays = (Literal)Item.FindControl("lblPanddingDays");
ltrDuration.Text = Convert.ToInt32(Duration) + " Days";
}
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["AdminID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "Admin", 0, session, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
protected void btnSubmit_Click(object sender, EventArgs e)
{
if (CheckForInternetConnection() == true)
{
try
{
var DC = new DataClassesDataContext();
int ProjectID;
if (ddProduct.SelectedValue != null)
{
ProjectID = Convert.ToInt32(ddProduct.SelectedValue);
}
else
{
ProjectID = 0;
}
//if (txtRate.Value == "5")
//{
// Point = 5;
//}
//else if (txtRate.Value == "4")
//{
// Point = 4;
//}
//else if (txtRate.Value == "3")
//{
// Point = 3;
//}
//else if (txtRate.Value == "2")
//{
// Point = 2;
//}
//else if (txtRate.Value == "1")
//{
// Point = 1;
//}
//else
//{
// Point = 5;
//}
int Point = Convert.ToInt32(txtRate.Value);
int count = DC.tblFeedbacks.Count(ob => ob.ClientID == Convert.ToInt32(Session["ClientID"]) && ob.ProjectID == Convert.ToInt32(ddProduct.SelectedValue));
if (count > 0)
{
tblFeedback FeedbackPoint = (from ob in DC.tblFeedbacks
where ob.ClientID == Convert.ToInt32(Session["ClientID"]) && ob.ProjectID == Convert.ToInt32(ddProduct.SelectedValue)
select ob).Single();
FeedbackPoint.FeedBackPoint = Point;
DC.SubmitChanges();
ClientScript.RegisterClientScriptBlock(GetType(), "Javascript", "<script>alert('FeedBack Successfully Submitted');window.location ='Default.aspx'</script>");
}
else
{
bool obj = objFeedBack.GiveFeedback(txtEmail.Text, ProjectID, Point, txtEnquiry.Text);
if (obj == true)
{
//IList<string> vc;
tblFeedback FeedbackID = (from ob in DC.tblFeedbacks
orderby ob.FeedbackID descending
select ob).First();
tblFeedback Client = (from ob in DC.tblFeedbacks
where ob.EmailID == FeedbackID.EmailID
select ob).Single();
DateTime now = DateTime.Now;
MailMessage Msg = new MailMessage("*****@*****.**", FeedbackID.EmailID);
Msg.Subject = "feedback";
//Msg.Body = "<html><head></head><body><table><tr><td>Your E-Mail :</td><td>" + InquiryID.EmailID + "</td><br></tr><tr><p><td>" + "Your inquiry Successfull recieved and inquiry under process" + "</td></p></tr></table></body></html>";
Msg.Body = "<!DOCTYPE html><html><head><title>Track My Work</title> <meta charset=\"utf - 8\"><meta name=\"viewport\" content=\"width = device - width, initial - scale = 1\"><meta http-equiv=\"X - UA - Compatible\" content=\"IE = edge\" /><style type=\"text / css\"> /* CLIENT-SPECIFIC STYLES */ body, table, td, a{-webkit-text-size-adjust: 100%; -ms-text-size-adjust: 100%;} /* Prevent WebKit and Windows mobile changing default text sizes */ table, td{mso-table-lspace: 0pt; mso-table-rspace: 0pt;} /* Remove spacing between tables in Outlook 2007 and up */ img{-ms-interpolation-mode: bicubic;} /* Allow smoother rendering of resized image in Internet Explorer */ /* RESET STYLES */ img{border: 0; height: auto; line-height: 100%; outline: none; text-decoration: none;} table{border-collapse: collapse !important;} body{height: 100% !important; margin: 0 !important; padding: 0 !important; width: 100% !important;} /* iOS BLUE LINKS */ a[x-apple-data-detectors] { color: inherit !important; text-decoration: none !important; font-size: inherit !important; font-family: inherit !important; font-weight: inherit !important; line-height: inherit !important; } /* MOBILE STYLES */ @media screen and (max-width: 525px) { /* ALLOWS FOR FLUID TABLES */ .wrapper { width: 100% !important; max-width: 100% !important; } /* ADJUSTS LAYOUT OF LOGO IMAGE */ .logo img { margin: 0 auto !important; } /* USE THESE CLASSES TO HIDE CONTENT ON MOBILE */ .mobile-hide { display: none !important; } .img-max { max-width: 100% !important; width: 100% !important; height: auto !important; } /* FULL-WIDTH TABLES */ .responsive-table { width: 100% !important; } /* UTILITY CLASSES FOR ADJUSTING PADDING ON MOBILE */ .padding { padding: 10px 5% 15px 5% !important; } .padding-meta { padding: 30px 5% 0px 5% !important; text-align: center; } .no-padding { padding: 0 !important; } .section-padding { padding: 50px 15px 50px 15px !important; } /* ADJUST BUTTONS ON MOBILE */ .mobile-button-container { margin: 0 auto; width: 100% !important; } .mobile-button { padding: 15px !important; border: 0 !important; font-size: 16px !important; display: block !important; } } /* ANDROID CENTER FIX */ div[style*=\"margin: 16px 0; \"] { margin: 0 !important; }</style></head><body style=\"margin: 0 !important; padding: 0 !important; \"><!-- HIDDEN PREHEADER TEXT --><div style=\"display: none; font - size: 1px; color: #fefefe; line-height: 1px; font-family: Helvetica, Arial, sans-serif; max-height: 0px; max-width: 0px; opacity: 0; overflow: hidden;\"> Entice the open with some amazing preheader text. Use a little mystery and get those subscribers to read through...</div><!-- HEADER --><table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\"> <tr> <td align=\"center\" style=\" background:#008bff;\"> <!--[if (gte mso 9)|(IE)]> <table align=\"center\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"500\"> <tr> <td align=\"center\" valign=\"top\" width=\"500\"> <![endif]--> <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" style=\"max-width: 500px;\" class=\"wrapper\"> <tr style=\" background:#008bff;\"> <td align=\"center\" valign=\"top\" style=\"padding: 15px 0;\" class=\"logo\"> <h1 style=\"color:white; background:#008bff; font-family:calibri; font-size:40px;\">Track My Work</h1> </td> </tr> </table> <!--[if (gte mso 9)|(IE)]> </td> </tr> </table> <![endif]--> </td> </tr> <tr> <td bgcolor=\"#ffffff\" align=\"center\" style=\"padding: 70px 15px 70px 15px;\" class=\"section-padding\"> <!--[if (gte mso 9)|(IE)]> <table align=\"center\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"500\"> <tr> <td align=\"center\" valign=\"top\" width=\"500\"> <![endif]--> <table border=\"0\" cellpadding=\"0\" cellspacing=\"0\" width=\"100%\" style=\"max-width: 500px;\" class=\"responsive-table\"> <tr> <td> <!-- HERO IMAGE --> <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"> <tr> <td> <!-- COPY --> <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\"> <tr> <td align=\"center\" style=\"font-size: 25px; font-family: Helvetica, Arial, sans-serif; color: #333333; padding-top: 30px;\" class=\"padding\">Your Email id is</td> </tr> <tr> <td align=\"center\" style=\"padding: 20px 0 0 0; font-size: 16px; line-height: 25px; font-family: Helvetica, Arial, sans-serif; color: #666666;\" class=\"padding\">" + FeedbackID.EmailID + "</td> </tr> <tr> <td align=\"center\" style=\"font-size: 25px; font-family: Helvetica, Arial, sans-serif; color: #333333; padding-top: 30px;\" class=\"padding\">Your Feedback Successfully Submitted.. Thank You For Your Valuable Feedback..</td> </tr> <tr> <td align=\"center\" style=\"padding: 20px 0 0 0; font-size: 16px; line-height: 25px; font-family: Helvetica, Arial, sans-serif; color: #666666;\" class=\"padding\"></td> </tr> </table> </td> </tr> </table> </td> </tr> </table> <!--[if (gte mso 9)|(IE)]> </td> </tr> </table> <![endif]--> </td> </tr> <tr> <td align=\"center\" style=\"padding: 20px 0px; background:#424242; color:white;\"> <!--[if (gte mso 9)|(IE)]> <table align=\"center\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" width=\"500\"> <tr> <td align=\"center\" valign=\"top\" width=\"500\"> <![endif]--> <!-- UNSUBSCRIBE COPY --> <table width=\"100%\" border=\"0\" cellspacing=\"0\" cellpadding=\"0\" align=\"center\" style=\"max-width: 500px;\" class=\"responsive-table\"> <tr> <td align=\"center\" style=\"font-size: 12px; line-height: 18px; font-family: Helvetica, Arial, sans-serif; color:white;\"> <b>Track My Work</b> by:- Renown Infosys <span style=\"font-family: Arial, sans-serif; font-size: 12px; color:white;\"> </span> </td> </tr> </table> <!--[if (gte mso 9)|(IE)]> </td> </tr> </table> <![endif]--> </td> </tr></table></body></html>";
Msg.IsBodyHtml = true;
SmtpClient smtp = new SmtpClient();
smtp.Host = "smtp.gmail.com";
smtp.Port = 587;
smtp.UseDefaultCredentials = false;
smtp.EnableSsl = true;
smtp.DeliveryMethod = SmtpDeliveryMethod.Network;
NetworkCredential MyCredentials = new NetworkCredential("*****@*****.**", "TMW2016open");
smtp.Credentials = MyCredentials;
smtp.Send(Msg);
ClientScript.RegisterClientScriptBlock(GetType(), "Javascript", "<script>alert('FeedBack Successfully Submitted');window.location ='Default.aspx'</script>");
}
else
{
ClientScript.RegisterClientScriptBlock(GetType(), "Javascript", "<script>alert('Oops! Something goes wrong...');window.location ='FeedBack.aspx'</script>");
}
}
//ManagerAppraisal
tblEmployee Manager = (from ob in DC.tblEmployees
join ob2 in DC.tblProjects
on ob.EmpID equals ob2.ManagerID
where ob2.ProjectID == Convert.ToInt32(ddProduct.SelectedValue)
select ob).Single();
int cnt = (from ob in DC.tblEmpAppraisals
where ob.EmpID == Manager.EmpID
select ob).Count();
if (cnt > 0)
{
tblEmpAppraisal Appraisal = (from ob in DC.tblEmpAppraisals
where ob.EmpID == Manager.EmpID
select ob).Single();
Appraisal.ClientFeedback += Convert.ToInt32(Point);
}
else
{
tblEmpAppraisal Appraisal = new tblEmpAppraisal();
Appraisal.EmpID = Manager.EmpID;
Appraisal.Skills = Convert.ToDecimal(0.0);
Appraisal.Quality = Convert.ToDecimal(0.0);
Appraisal.Avialibility = Convert.ToDecimal(0.0);
Appraisal.Deadlines = Convert.ToDecimal(0.0);
Appraisal.Communication = Convert.ToDecimal(0.0);
Appraisal.Cooperation = Convert.ToDecimal(0.0);
Appraisal.ClientFeedback = Convert.ToDecimal(Point);
Appraisal.CreatedOn = DateTime.Now;
DC.tblEmpAppraisals.InsertOnSubmit(Appraisal);
DC.SubmitChanges();
}
//TeamLeader
IQueryable <tblEmployee> TeamMember = (from ob in DC.tblEmployees
join ob2 in DC.tblTeamModules
on ob.EmpID equals ob2.EmpID
join ob3 in DC.tblModules
on ob2.ModuleID equals ob3.ModuleID
where ob3.ProjectID == Convert.ToInt32(ddProduct.SelectedValue)
select ob);
foreach (tblEmployee data in TeamMember)
{
int cntEmp = (from ob in DC.tblEmpAppraisals
where ob.EmpID == data.EmpID
select ob).Count();
if (cntEmp > 0)
{
tblEmpAppraisal Appraisal = (from ob in DC.tblEmpAppraisals
where ob.EmpID == data.EmpID
select ob).Single();
Appraisal.ClientFeedback += Convert.ToInt32(Point);
}
else
{
tblEmpAppraisal Appraisal = new tblEmpAppraisal();
Appraisal.EmpID = data.EmpID;
Appraisal.Skills = Convert.ToDecimal(0.0);
Appraisal.Quality = Convert.ToDecimal(0.0);
Appraisal.Avialibility = Convert.ToDecimal(0.0);
Appraisal.Deadlines = Convert.ToDecimal(0.0);
Appraisal.Communication = Convert.ToDecimal(0.0);
Appraisal.Cooperation = Convert.ToDecimal(0.0);
Appraisal.ClientFeedback = Convert.ToDecimal(Point);
Appraisal.CreatedOn = DateTime.Now;
DC.tblEmpAppraisals.InsertOnSubmit(Appraisal);
DC.SubmitChanges();
}
}
//Employee
IQueryable <tblEmployee> Employee = (from ob in DC.tblEmployees
join ob2 in DC.tblTeamMembers
on ob.EmpID equals ob2.EmpID
join ob3 in DC.tblTasks
on ob2.TaskID equals ob3.TaskID
join ob4 in DC.tblModules
on ob3.ModuleID equals ob4.ModuleID
where ob4.ProjectID == Convert.ToInt32(ddProduct.SelectedValue)
select ob);
foreach (tblEmployee data in Employee)
{
int cntEmp = (from ob in DC.tblEmpAppraisals
where ob.EmpID == data.EmpID
select ob).Count();
if (cntEmp > 0)
{
tblEmpAppraisal Appraisal = (from ob in DC.tblEmpAppraisals
where ob.EmpID == data.EmpID
select ob).Single();
Appraisal.ClientFeedback += Convert.ToInt32(Point);
}
else
{
tblEmpAppraisal Appraisal = new tblEmpAppraisal();
Appraisal.EmpID = data.EmpID;
Appraisal.Skills = Convert.ToDecimal(0.0);
Appraisal.Quality = Convert.ToDecimal(0.0);
Appraisal.Avialibility = Convert.ToDecimal(0.0);
Appraisal.Deadlines = Convert.ToDecimal(0.0);
Appraisal.Communication = Convert.ToDecimal(0.0);
Appraisal.Cooperation = Convert.ToDecimal(0.0);
Appraisal.ClientFeedback = Convert.ToDecimal(Point);
Appraisal.CreatedOn = DateTime.Now;
DC.tblEmpAppraisals.InsertOnSubmit(Appraisal);
DC.SubmitChanges();
}
}
}
catch (Exception ex)
{
int session = Convert.ToInt32(Session["ClientID"].ToString());
string PageName = System.IO.Path.GetFileName(Request.Url.AbsolutePath);
string MACAddress = GetMacAddress();
AddErrorLog(ref ex, PageName, "Client", session, 0, MACAddress);
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Something went wrong! Try again');", true);
}
}
else
{
ClientScript.RegisterStartupScript(GetType(), "abc", "alert('Please Check your Internet Connection');", true);
}
}
public string SaveFeedback()
{
var Name = Convert.ToString(Request.Form["avia_1_1"]);
var ToEmail = Convert.ToString(Request.Form["avia_2_1"]);
var Message = Convert.ToString(Request.Form["avia_6_1"]);
var txtmobileno = Convert.ToString(Request.Form["txtmobileno"]);
var rating = Convert.ToString(Request.Form["rating"]);
string msg = string.Empty;
if (string.IsNullOrEmpty(rating))
{
msg = "Please select Rating.";
return(msg);
}
if (string.IsNullOrEmpty(Name))
{
msg = "Please provide name.";
return(msg);
}
if (string.IsNullOrEmpty(ToEmail))
{
msg = "Please porvide email.";
return(msg);
}
if (string.IsNullOrEmpty(txtmobileno))
{
msg = "Please provide mobile no.";
return(msg);
}
//Message = string.Format("<b>Name:</b> {0}<br /><br />", Name);
//Message += string.Format("<b>Email:</b> {0}<br /><br />", ToEmail);
//Message += string.Format("<b>Mobile:</b> {0}<br /><br />", txtmobileno);
//Message += string.Format("<b>Message:</b> {0}<br /><br />", Message);
//Message += string.Format("<b>Rating:</b> {0}<br /><br />", rating);
//MailMessage message = new MailMessage();
//SmtpClient smtpClient = new SmtpClient();
//try
//{
// MailAddress fromAddress = new MailAddress("*****@*****.**");
// message.From = fromAddress;
// message.To.Add("*****@*****.**");
// message.Subject = "Flex Fixes Feedback from Website";
// message.IsBodyHtml = true;
// message.Body = Message;
// smtpClient.Host = "relay-hosting.secureserver.net"; //-- Donot change.
// smtpClient.Port = 25; //--- Donot change
// smtpClient.EnableSsl = false;//--- Donot change
// smtpClient.UseDefaultCredentials = true;
// smtpClient.Credentials = new System.Net.NetworkCredential("*****@*****.**", "usman83213");
// smtpClient.Send(message);
// msg = "1";
// //lblConfirmationMessage.Text = "Your email successfully sent.";
//}
//catch (Exception ex)
//{
// msg = ex.Message;
//}
try
{
using (EFDbContext context = new EFDbContext())
{
tblFeedback f = new tblFeedback();
f.Message = Message;
f.Name = Name;
f.Email = ToEmail;
f.MobileNo = txtmobileno;
f.Rating = rating;
f.CreationDate = DateTime.Now;
//context.Entry(f).State = System.Data.EntityState.Added;
context.Feedbacks.Add(f);
context.SaveChanges();
msg = "1";
}
}
catch (Exception ex)
{
msg = ex.Message;
}
return(msg);
}
public ActionResult Details(int id)
{
tblFeedback ad = dc.tblFeedbacks.SingleOrDefault(ob => ob.FeedbackId == id);
return(View(ad));
}