public bool UpdateBoardStatus(int board_id, int type_process)
{
try
{
db.Configuration.LazyLoadingEnabled = false;
M_Board board = db.M_Board.Find(board_id);
if (board == null)
{
return(false);
}
board.Board_Status_Id = type_process;
db.Entry(board).State = System.Data.EntityState.Modified;
db.SaveChanges();
return(true);
/*Add it to log file */
LogData = "data:" + JsonConvert.SerializeObject(board, logFileModule.settings);
logFileModule.logfile(10, "تغير حالة المجلس/اللجنة", "Update the board", LogData);
}catch (Exception er) {
/*Add it to log file */
LogData = "data:" + JsonConvert.SerializeObject(er, logFileModule.settings);
logFileModule.logfile(10, "حدث خطاء في النظام", "An Exception has occurred", LogData);
return(false);
}
}
private void load_board_info(M_Board Current_Board)
{
// Board Properties
txtArabicName.Text = Truncate(Current_Board.Board_Name_Ar, 20);;
txtEnglishName.Text = Truncate(Current_Board.Board_Name_En, 20);
txtCreatedDate.Text = Truncate(Current_Board.Create_Date.ToString(), 20);
if (SessionWrapper.LoggedUser.Language_id == 1)
{
txtType.Text = Truncate(Current_Board.M_Board_Type.Board_Type_Name_Ar, 20);
txtClassification.Text = Truncate(Current_Board.M_Board_Classification.Board_Classification_Name_Ar, 20);
}
else
{
txtType.Text = Truncate(Current_Board.M_Board_Type.Board_Type_Name_En, 20);
txtClassification.Text = Truncate(Current_Board.M_Board_Classification.Board_Classification_Name_En, 20);
}
//Edit Board info if you are supervisor
Classes.EditBoardPermission EBP = new Classes.EditBoardPermission();
Can_Edit = EBP.GetEditPermission(Current_Board);
if (Can_Edit)
{
txtEditBoard.Text = "<a href='../../../../Pages/Eminutes/BoardManagment/BoardInfo.aspx?BoardId=" + Current_Board.Board_Id + "' class='text-muted m-r-10 f-16'> <i style='color:#4183d7' class='icofont icofont-edit'></i></a>";
txtMeetingMembers.Text = "<a href='../../../../Pages/Eminutes/BoardManagment/BoardMember.aspx?BoardId=" + Current_Board.Board_Id + "' class='text-muted m-r-10 f-16'> <i style='color:#4183d7' class='icofont icofont-edit'></i></a>";
txtEditLocations.Text = "<a href='../../../../Pages/Eminutes/BoardManagment/BoardLocations.aspx?BoardId=" + Current_Board.Board_Id + "' class='text-muted m-r-10 f-16'> <i style='color:#4183d7' class='icofont icofont-edit'></i></a>";
txtAddMeeting.Text = "<a href='MeetingManagment/MeetingInfo.aspx?BoardID=" + Current_Board.Board_Id + "' class='text-muted m-r-10 f-16'> <i style='color:green' class='icofont icofont-ui-add'></i></a>";
}
else
{
txtEditBoard.Text = " <i class='icofont icofont-ui-note m-r-10'></i>";
txtMeetingMembers.Text = " <i class='icofont icofont-ui-note m-r-10'></i>";
txtEditLocations.Text = " <i class='icofont icofont-ui-note m-r-10'></i>";
txtAddMeeting.Text = " <i class='icofont icofont-ui-note m-r-10'></i>";
}
}
public void ResetGhostPostion()
{
for (int i = 0; i < M_Board.GetLength(0); i++)
{
for (int j = 0; j < M_Board.GetLength(1); j++)
{
M_Board[i, j] = FieldObject.blank;
}
}
}
/// <summary>
/// Member type (1 = Supervisor , 2 = secretarial , 3 = Members)
/// </summary>
/// <param name="sender"></param>
/// <param name="e"></param>
protected void Page_Load(object sender, EventArgs e)
{
if (SessionWrapper.LoggedUser == null)
{
Response.Redirect("~/Pages/Setting/Auth/Login.aspx");
}
int board_id = 0;
if (Request["BoardId"] == null)
{
Response.Redirect("~/Pages/Eminutes/Home.aspx");
}
board_id = int.Parse(Request["BoardId"].ToString());
Current_Board = db.M_Board.FirstOrDefault(x => x.Board_Id == board_id);
if (Current_Board != null)
{
// load current board info
load_board_info(Current_Board);
loadDownloadAttachment(Current_Board.Board_Id);
//Load sub boards
List <M_Board> sub_board = db.M_Board.Where(x => x.Parent == board_id).ToList();
if (sub_board.Count > 0)
{
Classes.EditBoardPermission EBP = new Classes.EditBoardPermission();
SubBoard.Text = EBP.LoadBoad(sub_board, "12");
}
// Load member
List <M_Board_Member> list_member = db.M_Board_Member.Where(x => x.Board_Id == board_id).ToList();
if (list_member.Count > 0)
{
LoadMember(list_member);
}
//Load Locations
List <M_Board_Location> Locations = db.M_Board_Location.Where(x => x.Board_Id == board_id).ToList();
if (Locations.Count > 0)
{
LoadLocations(Locations);
}
//Load Meetings
LoadMeetings(board_id);
}
else
{
Response.Redirect("~/Pages/Admin/Eminutes/Home.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (SessionWrapper.LoggedUser == null)
{
Response.Redirect("~/Pages/Setting/Auth/Login.aspx");
}
int board_id = 0;
M_Board boardinfo = null;
txtStatusofBoard.Enabled = false;
if (Request["BoardId"] != null)
{
board_id = int.Parse(Request["BoardId"].ToString());
boardinfo = db.M_Board.FirstOrDefault(x => x.Board_Id == board_id);
}
if (SessionWrapper.LoggedUser.Language_id == 1)
{
if (boardinfo != null)
{
Save.Text = "تحديث"; IsUpdate = true;
}
else
{
Save.Text = "حفظ";
}
Cancel.Text = "الغاء";
}
else
{
if (boardinfo != null)
{
Save.Text = "Update"; IsUpdate = true;
}
else
{
Save.Text = "Save";
}
Cancel.Text = "Cancel";
}
if (!IsPostBack)
{
fillDropDown();
txtStatusofBoard.SelectedValue = "1";
if (boardinfo != null)
{
LoadInfo(boardinfo);
}
}
}
public bool GetEditPermission(M_Board board)
{
try
{
M_Board_Member member = board.M_Board_Member.Where(x => x.Employee_Id == SessionWrapper.LoggedUser.Employee_Id).FirstOrDefault();
if ((member.Member_Type_Id == 1 || member.Member_Type_Id == 2) && (board.Board_Status_Id == 3))
{
return(true);
}
else
{
return(false);
}
}
catch { return(false); }
}
private void LoadInfo(M_Board boardinfo)
{
try
{
txtArabicName.Text = boardinfo.Board_Name_Ar;
txtEnglishName.Text = boardinfo.Board_Name_En;
txtArabicDescription.Text = boardinfo.Board_Description_Ar;
txtEnglishDescription.Text = boardinfo.Board_Description_En;
txtStatusofBoard.SelectedValue = boardinfo.Board_Status_Id.ToString();
txtTypeofBoard.SelectedValue = boardinfo.Board_Type_Id.ToString();
txtClassification.SelectedValue = boardinfo.Board_Classification_Id.ToString();
txtParent.SelectedValue = boardinfo.Parent.ToString();
try
{
DateTime startDate = DateTime.Parse(boardinfo.Start_Date.ToString());
DateTime endDate = DateTime.Parse(boardinfo.End_Date.ToString());
txtStartDate.Value = string.Format("{0:yyyy-MM-dd}", startDate);
txtEndDate.Value = string.Format("{0:yyyy-MM-dd}", endDate);
}catch { }
}
catch { }
}
protected void Save_Click(object sender, EventArgs e)
{
if (IsUpdate)
{
update();
}
else
{
string str = string.Empty;
try
{
// Create Board info
M_Board board = db.M_Board.Create();
board.Board_Name_Ar = txtArabicName.Text;
board.Board_Name_En = txtEnglishName.Text;
board.Board_Description_Ar = txtArabicDescription.Text;
board.Board_Description_En = txtEnglishDescription.Text;
board.Board_Type_Id = int.Parse(txtTypeofBoard.SelectedValue.ToString());
board.Board_Status_Id = 1; // int.Parse(txtStatusofBoard.SelectedValue.ToString());
board.Board_Classification_Id = int.Parse(txtClassification.SelectedValue.ToString());
board.Parent = int.Parse(txtParent.SelectedValue.ToString());
board.Create_Date = DateTime.Now;
if (txtTypeofBoard.SelectedValue == "3" && (txtStartDate.Value.ToString() == "" || txtStartDate.Value.ToString() == ""))
{
if (SessionWrapper.LoggedUser.Language_id == 1)
{
LtrMessage.Text = "<div class='alert alert-warning' role='alert'>الرجاء اختيار تاريخ البداية والنهاية</div>";
}
else
{
LtrMessage.Text = "<div class='alert alert-warning' role='alert'>Please Select start date & end date...</div>";
}
return;
}
else if ((txtTypeofBoard.SelectedValue == "3"))
{
board.Start_Date = DateTime.Parse(txtStartDate.Value.ToString());
board.End_Date = DateTime.Parse(txtEndDate.Value.ToString());
}
string message = "";
db.M_Board.Add(board);
db.SaveChanges();
int board_id = db.M_Board.Max(x => x.Board_Id);
if (addAttachments != null)
{
AttachmentFile(board_id, addAttachments, @"~\Pages\Eminutes\media\M_Attachments\");
}
// Update exist member
M_Board_Member member = db.M_Board_Member.Create();
member.Board_Id = board_id;
member.Employee_Id = SessionWrapper.LoggedUser.Employee_Id;
member.Member_Type_Id = 1; // رئيس
db.M_Board_Member.Add(member);
db.SaveChanges();
if (SessionWrapper.LoggedUser.Language_id == 1)
{
message = "Board add success...";
}
else
{
message = "تم اضافة المجلس/اللجنة بنجاح";
}
LtrMessage.Text = "<div class='alert alert-success' role='alert'>" + message + "</div>";
clear();
}
catch {
string message = "System Error...";
if (SessionWrapper.LoggedUser.Language_id == 1)
{
message = "حدث خطاء ...";
}
LtrMessage.Text = "<div class='alert alert-danger' role='alert'>" + message + "</div>";
}
}
}
private bool update()
{
int board_id = int.Parse(Request["BoardId"].ToString());
string str = string.Empty;
try
{
// Create Board info
M_Board board = db.M_Board.Find(board_id);
board.Board_Name_Ar = txtArabicName.Text;
board.Board_Name_En = txtEnglishName.Text;
board.Board_Description_Ar = txtArabicDescription.Text;
board.Board_Description_En = txtEnglishDescription.Text;
board.Board_Type_Id = int.Parse(txtTypeofBoard.SelectedValue.ToString());
board.Board_Status_Id = int.Parse(txtStatusofBoard.SelectedValue.ToString());
board.Board_Classification_Id = int.Parse(txtClassification.SelectedValue.ToString());
board.Parent = int.Parse(txtParent.SelectedValue.ToString());
board.Create_Date = DateTime.Now;
if (txtTypeofBoard.SelectedValue == "1" || txtTypeofBoard.SelectedValue == "2")
{
board.Start_Date = null;
board.End_Date = null;
}
else if ((txtStartDate.Value.ToString() == "" || txtEndDate.Value.ToString() == ""))
{
string messages = "Please Select start date & end date...";
if (SessionWrapper.LoggedUser.Language_id == 1)
{
messages = "الرجاء اختيار تاريخ البداية والنهاية";
}
LtrMessage.Text = "<div class='alert alert-warning' role='alert'>" + messages + "</div>";
return(false);
}
else
{
board.Start_Date = DateTime.Parse(txtStartDate.Value.ToString());
board.End_Date = DateTime.Parse(txtEndDate.Value.ToString());
}
AttachmentFile(board.Board_Id, addAttachments, @"~\Pages\Eminutes\media\M_Attachments\");
db.Entry(board).State = System.Data.EntityState.Modified;
db.SaveChanges();
}
catch {
string messages = "System Error...";
if (SessionWrapper.LoggedUser.Language_id == 1)
{
messages = "حدث خطاء ...";
}
LtrMessage.Text = "<div class='alert alert-danger' role='alert'>" + messages + "</div>";
return(false);
}
string message = "Board update successfully..";
if (SessionWrapper.LoggedUser.Language_id == 1)
{
message = "تم تحديث المجلس/اللجنة بنجاح";
}
LtrMessage.Text = "<div class='alert alert-success' role='alert'>" + message + "</div>";
return(true);
}
