public static Imgname createAnnouncement(AddAnnouncement ann)
{
string subgrpIDs = "";
try
{
if (ann.isSubGrpAdmin == "1" && ann.annType == "0")
{
subgrpIDs = SubGroupDirectory.GetAdminSubGroupList(ann.grpID, ann.memID);
}
MySqlParameter[] param = new MySqlParameter[17];
param[0] = new MySqlParameter("?annID", string.IsNullOrEmpty(ann.announID) ? "0" : ann.announID);
param[1] = new MySqlParameter("?annType", ann.annType);
param[2] = new MySqlParameter("?announTitle", ann.announTitle);
param[3] = new MySqlParameter("?announceDEsc", string.IsNullOrEmpty(ann.announceDEsc) ? "" : ann.announceDEsc);
param[4] = new MySqlParameter("?memID", ann.memID);
param[5] = new MySqlParameter("?grpID", ann.grpID);
param[6] = new MySqlParameter("?memprofileIDs", string.IsNullOrEmpty(ann.inputIDs) ? "" : ann.inputIDs);
param[7] = new MySqlParameter("?moduleId", ann.moduleId); // Added by Nandu on 07/11/2016 Task--> Module replica
param[8] = new MySqlParameter("?announcementImg", string.IsNullOrEmpty(ann.announImg) ? "0" : ann.announImg);
param[9] = new MySqlParameter("?sendSMSAll", string.IsNullOrEmpty(ann.sendSMSAll) ? "0" : ann.sendSMSAll);
param[10] = new MySqlParameter("?sendSMSNonSmartPh", string.IsNullOrEmpty(ann.sendSMSNonSmartPh) ? "0" : ann.sendSMSNonSmartPh);
param[11] = new MySqlParameter("?publishDate", ann.publishDate);
param[12] = new MySqlParameter("?expiryDate", ann.expiryDate);
param[13] = new MySqlParameter("?IsSubGrpAdmin", string.IsNullOrEmpty(ann.isSubGrpAdmin) ? "0" : ann.isSubGrpAdmin);
param[14] = new MySqlParameter("?subgrpIDs", subgrpIDs);
param[15] = new MySqlParameter("?annRepeatDate", string.IsNullOrEmpty(ann.AnnouncementRepeatDates) ? "" : ann.AnnouncementRepeatDates);
param[16] = new MySqlParameter("?reglink", ann.reglink);
using (TouchBaseWebAPI.Data.row_productionEntities context = new TouchBaseWebAPI.Data.row_productionEntities())
{
context.Connection.Open();
var Result = context.ExecuteStoreQuery <Imgname>("CALL V6_USPAddAnnouncement(?annID,?annType,?announTitle,?announceDEsc,?memID,?grpID,?memprofileIDs,?moduleId,?announcementImg,?publishDate,?expiryDate,?sendSMSAll,?sendSMSNonSmartPh,?IsSubGrpAdmin,?subgrpIDs,?annRepeatDate,?reglink)",
param).SingleOrDefault();
return(Result);
}
}
catch (Exception ex)
{
ManageExceptions.TraceException("Announcement/AddAnnouncement", "createAnnouncement()", Convert.ToString(ex.InnerException), Convert.ToString(ex.Message), Convert.ToString(ex.StackTrace));
throw ex;
}
}
public object AddAnnouncement(AddAnnouncement addann)
{
dynamic TBAddAnnouncementResult;
int str = -1;
try
{
Imgname Result = Announcement.createAnnouncement(addann);
if (!string.IsNullOrEmpty(Result.imgName))
{
str = GlobalFuns.UploadImage(addann.grpID, Result.imgName, "announcement");
}
else
{
str = 0;
}
if (Result != null)
{
if (str == 0)
{
TBAddAnnouncementResult = new { status = "0", message = "success" };
if (addann.announID != "0")
{
//string url = ConfigurationManager.AppSettings["imgPath"] + "php/EditAnnouncement.php?AnnID=" + addann.announID;
//GroupMaster.Send(url);
}
}
else
{
TBAddAnnouncementResult = new { status = "1", message = "failed" }
};
}
else
{
TBAddAnnouncementResult = new { status = "0", message = "Record not found" };
}
}
catch
{
TBAddAnnouncementResult = new { status = "1", message = "failed" };
}
return(new { TBAddAnnouncementResult });
}
public IActionResult UpdateNews([FromBody] JObject data)
{
var LoginUserIdentifier = "";
try
{
//gets the login token from Auth0
LoginUserIdentifier = User.FindFirst(ClaimTypes.NameIdentifier).Value;
}
catch (Exception e)
{
LoginUserIdentifier = "";
}
var connStr = _config["ConnectionStrings:DefaultConnection"];
AddAnnouncement addAnnouncement = data["Announcement"].ToObject <AddAnnouncement>();
using (IDbConnection db = new SqlConnection(connStr))
{
var SqlStr = @"Update Announcements
set Subject = @Subject,
Message = @Message
where id = @id";
db.Execute(SqlStr, new
{
Subject = addAnnouncement.Subject,
Message = addAnnouncement.Message,
id = addAnnouncement.ID,
}
);
}
return(Ok());
}
public async Task <IActionResult> Add(AddAnnouncement addAnnouncement)
{
if (ModelState.IsValid)
{
var announcement = new Announcement
{
Title = addAnnouncement.Title,
Content = addAnnouncement.Content,
PostDate = DateTime.UtcNow,
UrlSlug = Utils.GenerateSlug(addAnnouncement.Title)
};
await _naniWebContext.Announcements.AddAsync(announcement);
await _naniWebContext.SaveChangesAsync();
return(RedirectToAction("List"));
}
TempData["Error"] = true;
return(RedirectToAction("Add"));
}
public IActionResult AddNews([FromBody] JObject data)
{
var LoginUserIdentifier = "";
try
{
//gets the login token from Auth0
LoginUserIdentifier = User.FindFirst(ClaimTypes.NameIdentifier).Value;
}
catch (Exception e)
{
LoginUserIdentifier = "";
}
var connStr = _config["ConnectionStrings:DefaultConnection"];
string DateAdded = DateTime.UtcNow.ToString();
AddAnnouncement addAnnouncement = data["Announcement"].ToObject <AddAnnouncement>();
using (IDbConnection db = new SqlConnection(connStr))
{
var SqlStr = @"insert into Announcements values (@PropGuid, @Subject, @Message, @Auth0ID, @DateAdded)";
var result = db.Execute(SqlStr, new
{
PropGuid = addAnnouncement.HouseSelect,
Subject = addAnnouncement.Subject,
Message = addAnnouncement.Message,
Auth0ID = LoginUserIdentifier,
DateAdded = DateAdded
}
);
}
return(Ok());
}
