public ActionResult Edit(FeedBacks feedBacks)
{
if (ModelState.IsValid)
{
db.Entry(feedBacks).State = EntityState.Modified;
db.SaveChanges();
return(RedirectToAction(Notice.Index));
}
return(View(feedBacks));
}
public ActionResult Feedback(FeedBacks feedBacks)
{
Customers c = SessionHelper.GetObjectFromJson <Customers>(HttpContext.Session, "cus");
feedBacks.CustomerId = c.CustomerId;
feedBacks.Message = feedBacks.Message;
context.FeedBacks.Add(feedBacks);
context.SaveChanges();
return(RedirectToAction("UserProfile", "Cart", new { @id = c.Email }));
}
public ActionResult DeleteConfirmed(int id)
{
FeedBacks feedBacks = db.FeedBacks.Find(id);
if (feedBacks != null)
{
db.FeedBacks.Remove(feedBacks);
}
db.SaveChanges();
return(RedirectToAction(Notice.Index));
}
public Response <FeedBacks> DeleteFeedBacks([FromBody] FeedBacks feedback)
{
try
{
return(_feedBackBusiness.DeleteFeedBacks(feedback));
}
catch (Exception e)
{
_logger.Error($"DeleteFeedBacks Failed: {e.Message}\n {e.StackTrace}");
return(new Response <FeedBacks>(false, e.Message, null));
}
}
void Apply(SavedDraftLessonEvent @event)
{
Title = @event.Title;
Discipline = @event.Discipline;
School = @event.School;
Classroom = @event.Classroom;
AuthorId = @event.AuthorId;
Content = @event.Content;
Conclusion = @event.Conclusion;
LastModifDate = @event.ModificationDate;
//FeedBacks.Concat(@event.FeedBacks[EntityState.New]);
// Update FeedBacks Collection
if (@event.FeedBacks.ContainsKey(EntityStatus.A))
{
@event.FeedBacks[EntityStatus.A].ToList()
.ForEach(feedback => FeedBacks.Add(feedback));
}
if (@event.FeedBacks.ContainsKey(EntityStatus.M))
{
@event.FeedBacks[EntityStatus.M].ToList()
.ForEach(feedback => {
var item = FeedBacks.Single(f => f.Id.Equals(feedback.Id));
item.Feedback = feedback.Feedback;
});
}
if (@event.FeedBacks.ContainsKey(EntityStatus.C))
{
@event.FeedBacks[EntityStatus.C].ToList()
.ForEach(feedback => {
var item = FeedBacks.Single(f => f.Id.Equals(feedback.Id));
FeedBacks.Remove(item);
});
}
// Update Tags Collection
if (@event.Tags.ContainsKey(EntityStatus.A))
{
@event.Tags[EntityStatus.A].ToList()
.ForEach(tag => Tags.Add(tag));
}
if (@event.Tags.ContainsKey(EntityStatus.C))
{
@event.Tags[EntityStatus.C].ToList()
.ForEach(tag =>
{
var item = Tags.Single(f => f.LessonTagName.Equals(tag.LessonTagName));
Tags.Remove(item);
});
}
RecordState = Constants.RECORD_STATE_ACTIVE;
}
// GET: FeedBacks/Details/5
public ActionResult Details(int?id)
{
if (id == null)
{
return(RedirectToAction("Error", "Default"));
}
FeedBacks feedBacks = db.FeedBacks.Find(id);
if (feedBacks == null)
{
return(HttpNotFound());
}
return(View(feedBacks));
}
public ActionResult Feedback([Bind("Message")] FeedBacks feedBacks)
{
Customers c = SessionHelper.GetObjectFromJson <Customers>(HttpContext.Session, "cus");
if (ModelState.IsValid)
{
feedBacks.CustomerId = c.CustomerId;
feedBacks.Message = feedBacks.Message;
context.FeedBacks.Add(feedBacks);
context.SaveChanges();
}
return(RedirectToAction("UserProfile"));
}
public List <FeedBacks> DeleteFeedBacks(FeedBacks feedBack)
{
try
{
var result = ListByStoredProcedure <FeedBacks>(StoredProc.DeleteFeedBacks,
new StoredProcedureParameter("FeedBackID", feedBack.FeedBackID, DbType.Int32));
return(result);
}
catch (Exception e)
{
_logger.Error($"DeleteFeedBacks Failed: {e.Message}\n {e.StackTrace}");
return(new List <FeedBacks>());
}
}
public ActionResult Create(FeedBacks feedBacks)
{
feedBacks.ModifieddBy = Notice.SystemAddmin;
feedBacks.Creared = DateTime.Now;
feedBacks.Modified = DateTime.Now;
feedBacks.CreatedBy = Notice.SystemAddmin;
if (ModelState.IsValid)
{
db.FeedBacks.Add(feedBacks);
db.SaveChanges();
return(RedirectToAction(Notice.Index));
}
return(View(feedBacks));
}
public Response <FeedBacks> UpdateFeedBacks([FromBody] FeedBacks feedback)
{
try
{
var osPrincipal = (UserIdentity)System.Web.HttpContext.Current.User;
var userData = JsonConvert.DeserializeObject <UserViewModel>(osPrincipal.UserData);
feedback.LastUpdatedBy = userData.CodeUserName;
return(_feedBackBusiness.UpdateFeedBacks(feedback));
}
catch (Exception e)
{
_logger.Error($"UpdateFeedBacks Failed: {e.Message}\n {e.StackTrace}");
return(new Response <FeedBacks>(false, e.Message, null));
}
}
public Response <FeedBacks> DeleteFeedBacks(FeedBacks feedBacks)
{
try
{
var data = _feedBackRepository.DeleteFeedBacks(feedBacks);
if (data != null && data.Any())
{
return(new Response <FeedBacks>(true, "Success", data[0]));
}
return(new Response <FeedBacks>(false, "Fail", null));
}
catch (Exception e)
{
_logger.Error($"DeleteFeedBacks Failed: {e.Message}\n {e.StackTrace}");
return(new Response <FeedBacks>(false, e.Message, null));
}
}
public List <FeedBacks> UpdateFeedBacks(FeedBacks feedBack)
{
try
{
var result = ListByStoredProcedure <FeedBacks>(StoredProc.UpdateFeedBacks,
new StoredProcedureParameter("FeedBackID", feedBack.FeedBackID, DbType.Int32)
, new StoredProcedureParameter("Status", feedBack.Status, DbType.Boolean)
, new StoredProcedureParameter("LastUpdatedBy", feedBack.LastUpdatedBy, DbType.String)
, new StoredProcedureParameter("LastUpdatedDate", feedBack.LastUpdatedDate, DbType.DateTime));
return(result);
}
catch (Exception e)
{
_logger.Error($"UpdateFeedBacks Failed: {e.Message}\n {e.StackTrace}");
return(new List <FeedBacks>());
}
}
public async Task <bool> AddFeedBack(AddFeedBack addFeedBack)
{
var test = await testRepository.GetTest(Int32.Parse(addFeedBack.TestId));
var feedBack = new FeedBacks(test.Name, addFeedBack.UserId, Int32.Parse(addFeedBack.TestId), addFeedBack.Text, addFeedBack.Name, test.TeacherId);
try
{
feedBackRepository.Create(feedBack);
await feedBackRepository.SaveChangesAsync();
return(true);
}
catch (Exception)
{
return(false);
}
}
public ActionResult CreateNew(FeedBacks feedBacks)
{
feedBacks.ModifieddBy = Notice.SystemAddmin;
feedBacks.Creared = DateTime.Now;
feedBacks.Modified = DateTime.Now;
feedBacks.CreatedBy = Notice.SystemAddmin;
string content = "You have notification from Bright Day center \n" +
"Member " + feedBacks.name + " has mail is: \n" + feedBacks.Email
+ " Response content: \n" + feedBacks.Content + "\n at " + feedBacks.Creared;
if (ModelState.IsValid)
{
db.FeedBacks.Add(feedBacks);
db.SaveChanges();
var sendMail = new SendMail.EmailService();
sendMail.Send(Notice.MailXuan, Notice.Subject1, content);
return(RedirectToAction(Notice.Index, Notice.Home));
}
return(RedirectToAction(Notice.Index, Notice.Home));
}
public FeedBacks GetById(string id)
{
FeedBacks feedBacks = null;
try
{
Database db = this.GetDatabase();
string storeNameProcedure = "FeedBack_Get_By_Id";
DbCommand dbCommand = db.GetStoredProcCommand(storeNameProcedure);
db.AddInParameter(dbCommand, "id", DbType.String, id);
using (IDataReader dataReader = db.ExecuteReader(dbCommand))
{
feedBacks = FillObject(dataReader);
}
}
catch (Exception)
{
throw;
}
return(feedBacks);
}
public static FeedBacks FillObject(IDataReader _dr)
{
List <FeedBacks> list = new List <FeedBacks>();
try
{
while (_dr.Read())
{
FeedBacks feedBacks = new FeedBacks();
feedBacks.Id = _dr["Id"].ToString();
feedBacks.EmployeeCode = _dr["EmployeeCode"].ToString();
feedBacks.Titles = _dr["Titles"].ToString();
feedBacks.FeedBack = _dr["FeedBack"].ToString();
feedBacks.Contents = _dr["Contents"].ToString();
feedBacks.FileAttached = _dr["FileAttached"].ToString();
feedBacks.CreatedBy = _dr["CreatedBy"].ToString();
feedBacks.CreatedAt = ConvertHelper.ToDateTime(_dr["CreatedAt"], DateTime.Now);
feedBacks.UpdatedBy = _dr["UpdatedBy"].ToString();
feedBacks.UpdatedAt = ConvertHelper.ToDateTime(_dr["UpdatedAt"], DateTime.Now);
feedBacks.IsDeleted = ConvertHelper.ToInt32(_dr["IsDeleted"], 0);
if (list.IndexOf(feedBacks) < 0)
{
list.Add(feedBacks);
}
if (list.Count > 0)
{
FeedBacks[] fb = list.ToArray();
if (fb != null && fb.Length > 0)
{
return(fb[0]);
}
}
}
}
finally
{
_dr.Close();
}
return(null);
}
public List <FeedBacks> InsertFeedBacks(FeedBacks feedBack)
{
try
{
var result = ListByStoredProcedure <FeedBacks>(StoredProc.InsertFeedBacks,
new StoredProcedureParameter("Name", feedBack.Name, DbType.String)
, new StoredProcedureParameter("Phone", feedBack.Phone, DbType.String)
, new StoredProcedureParameter("Email", feedBack.Email, DbType.String)
, new StoredProcedureParameter("Address", feedBack.Address, DbType.String)
, new StoredProcedureParameter("Content", feedBack.Content, DbType.String)
, new StoredProcedureParameter("Status", feedBack.Status, DbType.Boolean)
, new StoredProcedureParameter("CreatedDate", feedBack.CreatedDate, DbType.DateTime)
, new StoredProcedureParameter("LastUpdatedBy", feedBack.LastUpdatedBy, DbType.String)
, new StoredProcedureParameter("LastUpdatedDate", feedBack.LastUpdatedDate, DbType.DateTime)
, new StoredProcedureParameter("IsDelete", feedBack.IsDelete, DbType.Boolean));
return(result);
}
catch (Exception e)
{
_logger.Error($"InsertFeedBacks Failed: {e.Message}\n {e.StackTrace}");
return(new List <FeedBacks>());
}
}
public ExcutionResult Update(FeedBacks employees)
{
ExcutionResult rowAffected = new ExcutionResult();
try
{
Database db = this.GetDatabase();
string storeNameProcedure = "FeedBacks_Update";
using (DbCommand dbCommand = db.GetStoredProcCommand(storeNameProcedure))
{
db.AddInParameter(dbCommand, "Id", DbType.String, employees.Id);
db.AddInParameter(dbCommand, "EmployeeCode", DbType.String, employees.EmployeeCode);
db.AddInParameter(dbCommand, "Titles", DbType.String, employees.Titles);
db.AddInParameter(dbCommand, "FeedBack", DbType.String, employees.FeedBack);
db.AddInParameter(dbCommand, "Contents", DbType.String, employees.Contents);
db.AddInParameter(dbCommand, "FileAttached", DbType.String, employees.FileAttached);
db.AddInParameter(dbCommand, "CreatedBy", DbType.String, employees.CreatedBy);
db.AddInParameter(dbCommand, "CreatedAt", DbType.DateTime, employees.CreatedAt);
db.AddInParameter(dbCommand, "UpdatedBy", DbType.String, employees.CreatedBy);
db.AddInParameter(dbCommand, "UpdatedAt", DbType.DateTime, employees.CreatedAt);
db.AddInParameter(dbCommand, "IsDeleted", DbType.Int32, employees.IsDeleted);
db.AddOutParameter(dbCommand, "IsCheck", DbType.Int32, 0x20);
db.ExecuteNonQuery(dbCommand);
var isCheck = ConvertHelper.ToInt32(db.GetParameterValue(dbCommand, "IsCheck"), 0);
if (isCheck == 1)
{
rowAffected.Message = "Update Failed";
}
}
}
catch (Exception e)
{
rowAffected.ErrorCode = 1;
rowAffected.Message = e.Message;
}
return(rowAffected);
}
public override void Execute()
{
try
{
var initValue1 = ActionInParameterManager["ActionParameter1"];
var value1 = initValue1.GetValue();
var initValue2 = ActionInParameterManager["ActionParameter2"];
var value2 = initValue2.GetValue();
var calculateType = BasicValueCalculateD2.GetCalculateType(ActionInParameterManager["CalculateType"].GetValueInString());
var value3 = BasicValueCalculateD2.Calculate(calculateType, value1, value2);
FeedBacks.Add(new Message {
Description = $"参数Value1：[{value1}],Value2：[{value2}],Value3：[{value3}]"
});
ActionOutParameterManager["ResultParameter"].SetValue(value3);
}
catch (Exception ex)
{
Log.Error($"执行TwoParameterCalculateAction 出错{ex}");
}
}
public static ExcutionResult Insert(FeedBacks feedBacks)
{
ExcutionResult rowAffected = provider.Insert(feedBacks);
return(rowAffected);
}
public ActionResult Details(int id)
{
FeedBacks c = context.FeedBacks.Where(x => x.FeedBackId == id).SingleOrDefault();
return(View(c));
}
public DateTime Get_LM(HeadersFor headerFor, int id = 1)
{
DateTime rez = Over.LM;
switch (headerFor)
{
case (HeadersFor.Index):
var lm = TaP.Where(t => t.IsNew).Select(t => t.LM).Max();
if (Over.LM > lm)
{
rez = Over.LM;
}
else
{
rez = lm;
}
break;
case (HeadersFor.Category):
var lm2 = TaP.Where(t => t.CategoryId == id).Select(t => t.LM).Max();
if (Over.LM > lm2)
{
rez = Over.LM;
}
else
{
rez = lm2;
}
break;
case (HeadersFor.Position):
var lm3 = TaP.Where(t => t.TovarId == id).Select(t => t.LM).Max();
if (Over.LM > lm3)
{
rez = Over.LM;
}
else
{
rez = lm3;
}
break;
case (HeadersFor.Services):
var lm4 = Services.Select(s => s.LM).Max();
if (Over.LM > lm4)
{
rez = Over.LM;
}
else
{
rez = lm4;
}
break;
case (HeadersFor.Feedbacks):
var lm5 = FeedBacks.Select(f => f.Date).Max();
if (Over.LM > lm5)
{
rez = Over.LM;
}
else
{
rez = lm5;
}
break;
}
return(rez);
}
public static ExcutionResult Delete(FeedBacks feedBacks)
{
ExcutionResult rowAffected = provider.Delete(feedBacks);
return(rowAffected);
}
