protected void OpenByIdButton_Click(object sender, EventArgs e)
{
string textboxValue = OpenByIdTextBox.Text;
if (textboxValue != null)
{
if (textboxValue.Length > 0)
{
int cardId = 0;
Int32.TryParse(textboxValue, out cardId);
if (cardId != 0)
{
ChancelerryDb dataContext = new ChancelerryDb(new NpgsqlConnection(WebConfigurationManager.AppSettings["ConnectionStringToPostgre"]));
int regId;
Int32.TryParse(Session["registerID"].ToString(), out regId);
CollectedCards cardIdReal = (from a in dataContext.CollectedCards
where a.FkRegister == regId &&
a.MaInFieldID == cardId &&
a.Active
select a).FirstOrDefault();
if (cardIdReal != null)
{
Session["canEdit"] = true;
Session["cardID"] = cardIdReal.CollectedCardID;
Session["version"] = 200500;
Response.Redirect("CardEdit.aspx");
}
}
}
}
}
protected void GridViewRegisters_RowCommand(object sender, GridViewCommandEventArgs e)
{
ChancelerryDb dataContext = new ChancelerryDb(new NpgsqlConnection(WebConfigurationManager.AppSettings["ConnectionStringToPostgre"]));
int userId;
Int32.TryParse(Session["userID"].ToString(), out userId); // Port
switch (e.CommandName)
{
case "Link":
{
List <DataForGv> registers = (from rum in dataContext.RegistersUsersMap
join reg in dataContext.Registers on rum.FkRegister equals reg.RegisterID
where reg.Active && rum.Active && rum.FkUser == userId
select new DataForGv()
{
Id = reg.RegisterID, Name = reg.Name
}).ToList();
// CommandArgument - номер строки.
Session["registerID"] = registers[Convert.ToInt32(e.CommandArgument)].Id;
Session["searchList"] = new List <TableActions.SearchValues>();
Session["vSearchList"] = null;
Session["currentPage"] = null;
Response.Redirect("RegisterView.aspx");
}
break;
}
}
public void DeleteCard(object sender, EventArgs e)
{
ImageButton thisButton = (ImageButton)sender;
int currentCardId = Convert.ToInt32(thisButton.Attributes["_cardID"]);
HttpContext.Current.Session["cardID"] = currentCardId;
int regId;
int.TryParse(HttpContext.Current.Session["registerID"].ToString(), out regId);
ChancelerryDb dataContext = new ChancelerryDb(new NpgsqlConnection(WebConfigurationManager.AppSettings["ConnectionStringToPostgre"]));
CollectedCards card = (from c in dataContext.CollectedCards
where
c.FkRegister == regId &&
c.CollectedCardID == currentCardId
select c).FirstOrDefault();
if (card != null)
{
card.Active = false;
}
dataContext.SubmitChanges();
HttpContext.Current.Response.Redirect("~/kanz/RegisterView.aspx", true);
}
protected void Page_Load(object sender, EventArgs e)
{
var UserSer = Session["userID"];
if (UserSer == null)
{
FormsAuthentication.SignOut();
Session.Abandon();
Response.Redirect("~/Account/Login.aspx");
}
ChancelerryDb dataContext = new ChancelerryDb(new NpgsqlConnection(WebConfigurationManager.AppSettings["ConnectionStringToPostgre"]));
Users user = (from u in dataContext.Users
where u.UserID == (int)UserSer
select u).FirstOrDefault();
if (user != null)
{
Session["pageCntrl"] = 0;
Directions(user);
}
else
{
FormsAuthentication.SignOut();
Session.Abandon();
Response.Redirect("~/Account/Login.aspx");
}
}
protected void Page_Load(object sender, EventArgs e)
{
var userID = Session["userID"];
if (userID == null)
{
Response.Redirect("~/Default.aspx");
}
int userId = (int)userID;
if (userId != 1)
{
GoToAdmin.Visible = false;
GoToAdmin.Enabled = false;
}
else
{
GoToAdmin.Visible = true;
GoToAdmin.Enabled = true;
}
/////////////////////////////////////////////////////////////////////
ChancelerryDb dataContext = new ChancelerryDb(new NpgsqlConnection(WebConfigurationManager.AppSettings["ConnectionStringToPostgre"]));
// Забираем только прикрепленные реестры в RegUsrMap для данного пользователя и проверяем на активность в Registers.
List <DataForGv> registers = (from rum in dataContext.RegistersUsersMap
join reg in dataContext.Registers on rum.FkRegister equals reg.RegisterID
where reg.Active && rum.Active && rum.FkUser == (int)userID
select new DataForGv()
{
Id = reg.RegisterID, Name = reg.Name
}).ToList();
GridViewRegisters.DataSource = registers;
BoundField boundField = new BoundField();
boundField.DataField = "Id";
boundField.HeaderText = "ID";
boundField.Visible = false;
GridViewRegisters.Columns.Add(boundField);
ButtonField coluButtonField = new ButtonField();
coluButtonField.DataTextField = "Name";
coluButtonField.HeaderText = "Реестры документов";
coluButtonField.ButtonType = ButtonType.Link;
coluButtonField.CommandName = "Link";
GridViewRegisters.Columns.Add(coluButtonField);
DataBind();
}
public Table CreateTable(int dictionaryId)
{
Table tableToReturn = new Table();
ChancelerryDb chancDb =
new ChancelerryDb(new NpgsqlConnection(WebConfigurationManager.AppSettings["ConnectionStringToPostgre"]));
List <DictionarysValues> allValues = (from a in chancDb.DictionarysValues
where a.Active == true &&
a.FkDictionary == dictionaryId
select a).Distinct().ToList();
foreach (DictionarysValues currentValue in allValues)
{
TableRow currentTableRow = new TableRow();
{
TableCell currentTableCell1 = new TableCell();
{
currentTableCell1.Width = 600;
TextBox valueTextBox = new TextBox();
valueTextBox.ID = "dictValue_" + currentValue.DictionaryValueID.ToString();
valueTextBox.Attributes.Add("name", valueTextBox.ID);
valueTextBox.Width = 600;
valueTextBox.Style.Add("max-width", "100%");
valueTextBox.Text = currentValue.Value;
currentTableCell1.Controls.Add(valueTextBox);
}
TableCell currentTableCell2 = new TableCell();
{
ImageButton deleteButton = new ImageButton();
deleteButton.ImageUrl = "~/kanz/icons/delButtonIcon.jpg";
deleteButton.Height = 20;
deleteButton.Width = 20;
deleteButton.CommandArgument = currentValue.DictionaryValueID.ToString();
deleteButton.Click += DelValueButtonClick;
currentTableCell2.Controls.Add(deleteButton);
}
TableCell currentTableCell3 = new TableCell();
{
ImageButton saveButton = new ImageButton();
saveButton.ImageUrl = "~/kanz/icons/saveButtonIcon.jpg";
saveButton.Height = 20;
saveButton.Width = 20;
saveButton.CommandArgument = currentValue.DictionaryValueID.ToString();
saveButton.Click += SaveValueButtonClick;
currentTableCell3.Controls.Add(saveButton);
}
currentTableRow.Cells.Add(currentTableCell1);
currentTableRow.Cells.Add(currentTableCell2);
currentTableRow.Cells.Add(currentTableCell3);
}
tableToReturn.Rows.Add(currentTableRow);
}
return(tableToReturn);
}
public void CreateTree()
{
ChancelerryDb chancDb = new ChancelerryDb(new NpgsqlConnection(WebConfigurationManager.AppSettings["ConnectionStringToPostgre"]));
TreeViewData treeViewData = new TreeViewData();
Struct first = (from a in chancDb.Struct where a.Active == true && a.FkParent == null select a).FirstOrDefault();
List <Struct> allStruct = (from a in chancDb.Struct where a.Active == true && a.FkParent != null select a).ToList();
treeViewData = RecursiveFillTreeView(allStruct, first);
TreeViewTable treeViewTable = new TreeViewTable();
//mainDiv.InnerHtml=treeViewTable.CreateTreeViewTable(treeViewData);
mainDiv.Controls.Add(treeViewTable.GetPanelWithTable(treeViewData));
}
protected void AddValue_Click(object sender, ImageClickEventArgs e)
{
ChancelerryDb chancDb =
new ChancelerryDb(new NpgsqlConnection(WebConfigurationManager.AppSettings["ConnectionStringToPostgre"]));
DictionarysValues newValue = new DictionarysValues();
newValue.Active = true;
newValue.FkDictionary = Convert.ToInt32(DictionarysList.SelectedValue);
newValue.Value = " ";
chancDb.DictionarysValues.InsertOnSubmit(newValue);
chancDb.SubmitChanges();
divForTable.Controls.Clear();
divForTable.Controls.Add(CreateTable(Convert.ToInt32(DictionarysList.SelectedValue)));
}
public void SaveValueButtonClick(object sender, EventArgs e)
{
ImageButton saveButton = (ImageButton)sender;
int id = Convert.ToInt32(saveButton.CommandArgument);
ChancelerryDb chancDb =
new ChancelerryDb(new NpgsqlConnection(WebConfigurationManager.AppSettings["ConnectionStringToPostgre"]));
DictionarysValues currentValues = (from a in chancDb.DictionarysValues
where a.DictionaryValueID == id
select a).FirstOrDefault();
if (currentValues != null)
{
TextBox myTextBox = (TextBox)divForTable.FindControl("dictValue_" + id);
currentValues.Value = myTextBox.Text;
chancDb.SubmitChanges();
}
divForTable.Controls.Clear();
divForTable.Controls.Add(CreateTable(Convert.ToInt32(DictionarysList.SelectedValue)));
}
protected void Page_Load(object sender, EventArgs e)
{
if (!Page.IsPostBack)
{
ChancelerryDb chancDb =
new ChancelerryDb(new NpgsqlConnection(WebConfigurationManager.AppSettings["ConnectionStringToPostgre"]));
List <Dictionarys> dictionaryse = (from a in chancDb.Dictionarys
where a.Active == true
select a).ToList();
DictionarysList.Items.Clear();
foreach (Dictionarys currentDictionary in dictionaryse)
{
ListItem tmpListItem = new ListItem();
tmpListItem.Text = currentDictionary.Name;
tmpListItem.Value = currentDictionary.DictionaryID.ToString();
DictionarysList.Items.Add(tmpListItem);
}
}
divForTable.Controls.Clear();
divForTable.Controls.Add(CreateTable(Convert.ToInt32(DictionarysList.SelectedValue)));
}
public string Export(string filePath, string tmpFilesPath, int cardId, int userId, int type, int instance)
{
ChancelerryDb chancDb = new ChancelerryDb(new NpgsqlConnection(WebConfigurationManager.AppSettings["ConnectionStringToPostgre"]));
List <CollectedFieldsValues> allCollectedInCard = (from a in chancDb.CollectedFieldsValues
where a.FkCollectedCard == cardId
select a).ToList();
OpenFile(filePath);
List <string> allMarks = GetAllMarks();
foreach (string key in allMarks)
{
string resultValue = "";
if (key == "#markUserName#")
{
string tmpValue = (from a in chancDb.Users where a.UserID == userId select a.Name).FirstOrDefault().ToString();
resultValue = RussianStringToHexString(tmpValue);
}
else if (key == "#markTodayDate#")
{
DateTime tmp = DateTime.Now;
resultValue = tmp.Day.ToString("00") + "." + tmp.Month.ToString("00") + "." + tmp.Year.ToString("0000");
}
else
{
resultValue = GetValueByMark(key, allCollectedInCard, instance);
}
ReplaceMarkWithValue(key, resultValue);
}
string path = CreateNewFile(tmpFilesPath, cardId, userId, type);
int sendStatus = SendFileToClient(path);
return(sendStatus.ToString());
}
protected void LogIn(object sender, EventArgs e)
{
if (IsValid)
{
ChancelerryDb datacontext = new ChancelerryDb(new NpgsqlConnection(WebConfigurationManager.AppSettings["ConnectionStringToPostgre"]));
var user = (from u in datacontext.Users where
u.Login == Email.Text &&
u.Password == Password.Text &&
u.Active
select u).FirstOrDefault();
if (user != null)
{
Session["userID"] = user.UserID;
Response.Redirect("~/Default.aspx");
}
else
{
FailureText.Text = "Неверный адрес электронной почты или пароль.";
ErrorMessage.Visible = true;
}
}
}
private Dictionary <string, string> GetDataEndExport(int cardId, int instance)
{
ChancelerryDb chancDb = new ChancelerryDb(new NpgsqlConnection(WebConfigurationManager.AppSettings["ConnectionStringToPostgre"]));
int userId = 0;
int.TryParse(Session["userID"].ToString(), out userId);
if (userId == 0)
{
Response.Redirect("~/Default.aspx");
}
Users user = (from a in chancDb.Users where a.UserID == userId select a).FirstOrDefault();
if (user == null)
{
Response.Redirect("~/Default.aspx");
}
List <CollectedFieldsValues> allCollectedInCard = (from a in chancDb.CollectedFieldsValues
where a.FkCollectedCard == cardId
select a).ToList();
Dictionary <string, string> newTmpDict = new Dictionary <string, string>();
newTmpDict.Add("#markForWhoomStruct#", GetDataFromDb(allCollectedInCard, instance, 0));
newTmpDict.Add("#markForWhoomName#", GetDataFromDb(allCollectedInCard, instance, 0));
newTmpDict.Add("#markDocDate#", GetDataFromDb(allCollectedInCard, -1, 0));
newTmpDict.Add("#markDocNumber#", GetDataFromDb(allCollectedInCard, -1, 0));
newTmpDict.Add("#markDocContent#", GetDataFromDb(allCollectedInCard, -1, 0));
newTmpDict.Add("#markItemNumber#", GetDataFromDb(allCollectedInCard, instance, 0));
newTmpDict.Add("#markItemCnrtlDate#", GetDataFromDb(allCollectedInCard, instance, 0));
newTmpDict.Add("#markItemContent#", GetDataFromDb(allCollectedInCard, instance, 0));
newTmpDict.Add("#markResponsible#", GetDataFromDb(allCollectedInCard, -1, 0));
newTmpDict.Add("#markExecutor#", "???");
newTmpDict.Add("#markUser#", user.Name);
newTmpDict.Add("#markTodayDate#", DateTime.Now.Date.ToString());
return(newTmpDict);
}
protected void Page_Load(object sender, EventArgs e)
{
var userID = Session["userID"];
if (userID == null)
{
Response.Redirect("~/Default.aspx");
}
///////////////////////////////////////////
if (!Page.IsPostBack)
{
Session["searchList"] = new List <TableActions.SearchValues>();
DataTable dataTable = new DataTable();
dataTable.Columns.Add(new DataColumn("fieldId", typeof(int)));
dataTable.Columns.Add(new DataColumn("fieldName", typeof(string)));
dataTable.Columns.Add(new DataColumn("fieldWeight", typeof(double)));
dataTable.Columns.Add(new DataColumn("fieldIsAdd", typeof(bool)));
using (ChancelerryDb dataContext = new ChancelerryDb(new NpgsqlConnection(WebConfigurationManager.AppSettings["ConnectionStringToPostgre"])))
{
int regId;
int userId;
int.TryParse(Session["registerID"].ToString(), out regId);
int.TryParse(Session["userID"].ToString(), out userId);
//кусок Ваге // создаем для пользователя все связи к выбранному регистру если их нет
List <Fields> allFieldsInTable = (from a in dataContext.Fields
join b in dataContext.FieldsGroups
on a.FkFieldsGroup equals b.FieldsGroupID
join c in dataContext.RegistersModels
on b.FkRegisterModel equals c.RegisterModelID
join d in dataContext.Registers
on c.RegisterModelID equals d.FkRegistersModel
where a.Active == true &&
b.Active == true &&
c.Active == true &&
d.Active == true
//&& d.RegisterID == (int) Session["registerID"] PORT
&& d.RegisterID == regId
select a).Distinct().ToList();
List <Fields> allFieldsWithUser = (from a in dataContext.Fields
join b in dataContext.RegistersView on a.FieldID equals b.FkField
join c in dataContext.RegistersUsersMap on b.FkRegistersUsersMap equals c.RegistersUsersMapID
where
a.Active == true &&
c.Active == true
// && b.active == tr
// && c.FkRegister == (int)Session["registerID"] PORT
// && c.FkUser == (int)Session["userID"] PORT
&& c.FkRegister == regId &&
c.FkUser == userId
select a).ToList();
RegistersUsersMap registerUserMap = (from a in dataContext.RegistersUsersMap
where a.Active
// && a.FkUser == (int)Session["userID"] PORT
// && a.FkRegister == (int)Session["registerID"] PORT
&& a.FkUser == userId &&
a.FkRegister == regId
select a).FirstOrDefault();
foreach (Fields currentField in allFieldsInTable)
{
if (allFieldsWithUser.Contains(currentField))
{
continue;
}
else
{
RegistersView registersView = new RegistersView();
registersView.Active = true;
registersView.FkRegistersUsersMap = registerUserMap.RegistersUsersMapID;
registersView.FkField = currentField.FieldID;
registersView.Weight = 0;
dataContext.RegistersView.InsertOnSubmit(registersView);
dataContext.SubmitChanges();
}
}
/*
* // Кусок Ваге окончен :)
* // Все возможные поля для таблицы в данном реестре
* var all = (from a in dataContext.Fields
* join b in dataContext.RegistersView on a.fieldID equals b.fk_field
* join c in dataContext.RegistersUsersMap on b.fk_registersUsersMap equals c.registersUsersMapID
* where c.fk_register == (int)Session["registerID"]
* select new {a.fieldID, a.name, b.weight}).Distinct();
*
* // Уже прикрученные поля к этому пользователю
* var userView = (from a in dataContext.Fields
* join b in dataContext.RegistersView on a.fieldID equals b.fk_field
* join c in dataContext.RegistersUsersMap on b.fk_registersUsersMap equals c.registersUsersMapID
* where c.fk_register == (int)Session["registerID"] && c.fk_user == (int)Session["userID"] && b.active
* select a.fieldID).Distinct().ToList();
*
* var allCross = new List<ViewFieldData>();
*
* // Проходим по всем полям
* foreach (var qwe in all)
* {
* // Если это поле прикручено к таблице этого реестра и этому пользователю в ТАБЛИЦЕ RegisterView, то отмечаем его с галочкой Checked true
* allCross.Add(userView.Contains(qwe.fieldID)
* ? new ViewFieldData()
* {
* id = qwe.fieldID,
* name = qwe.name,
* weight = qwe.weight,
* isAdd = true
* }
* // если нет то с галочкой UnChecked false
* : new ViewFieldData()
* {
* id = qwe.fieldID,
* name = qwe.name,
* weight = qwe.weight,
* isAdd = false
* });
* }
*
* // Проходим по allCross, добавляем дааные из него в таблицу
*
* foreach (var item in allCross)
* {
* DataRow dataRow = dataTable.NewRow();
* dataRow["fieldId"] = item.id;
* dataRow["fieldName"] = item.name;
* dataRow["fieldWeight"] = item.weight;
* dataRow["fieldIsAdd"] = item.isAdd;
* dataTable.Rows.Add(dataRow);
* }
*/
foreach (var item in allFieldsWithUser)
{
DataRow dataRow = dataTable.NewRow();
dataRow["fieldId"] = item.FieldID;
dataRow["fieldName"] = item.Name;
dataRow["fieldWeight"] = (from a in dataContext.RegistersView
where
a.FkRegistersUsersMap == registerUserMap.RegistersUsersMapID &&
a.FkField == item.FieldID
//&& a.active == true
select a.Weight).FirstOrDefault();
dataRow["fieldIsAdd"] = (from a in dataContext.RegistersView
where
a.FkRegistersUsersMap == registerUserMap.RegistersUsersMapID &&
a.FkField == item.FieldID
//&& a.active == true
select a.Active).FirstOrDefault();
dataTable.Rows.Add(dataRow);
}
GridView1.DataSource = dataTable;
ViewState["Gridview1"] = dataTable;
GridView1.DataBind();
}
}
}
protected void Button1_Click(object sender, EventArgs e)
{
int regId;
int userId;
int.TryParse(Session["registerID"].ToString(), out regId);
int.TryParse(Session["userID"].ToString(), out userId);
int rowIndex = 0;
//Button button = (Button) sender;
using (ChancelerryDb dataContext = new ChancelerryDb(new NpgsqlConnection(WebConfigurationManager.AppSettings["ConnectionStringToPostgre"])))
{
// Запись в RegisterUserMap для данного пользователя и реестра
var regUsrMap = (from a in dataContext.RegistersUsersMap
// where a.FkRegister == (int)Session["registerID"] && a.FkUser == (int) Session["userID"] PORT
where a.FkRegister == regId && a.FkUser == userId
select a).FirstOrDefault();
if (ViewState["Gridview1"] != null)
{
DataTable dataTable = (DataTable)ViewState["Gridview1"];
// Проходим по всей таблице
if (dataTable.Rows.Count > 0)
{
for (int i = 1; i <= dataTable.Rows.Count; i++)
{
// Находим компоненты
Label fieldId = (Label)GridView1.Rows[rowIndex].FindControl("fieldId");
// TextBox fieldName = (TextBox) GridView1.Rows[rowIndex].FindControl("fieldName");
TextBox fieldWeight = (TextBox)GridView1.Rows[rowIndex].FindControl("fieldWeight");
CheckBox fieldIsAdd = (CheckBox)GridView1.Rows[rowIndex].FindControl("fieldIsAdd");
int fieldid;
double fieldweight = Convert.ToDouble(fieldWeight.Text);
int.TryParse(fieldId.Text, out fieldid);
// Запрос на существование записи в ТАБЛИЦЕ(БД) registersView с параметрами из таблицы
RegistersView registersView = (from a in dataContext.RegistersView
where
a.FkRegistersUsersMap == regUsrMap.RegistersUsersMapID &&
//a.FkField == Convert.ToInt32(fieldId.Text)
a.FkField == fieldid
select a).FirstOrDefault();
// Если такая запись в ТАБЛИЦЕ существует, то присваиваем значения active и weight из таблицы(на странице)
if (registersView != null)
{
registersView.Active = fieldIsAdd.Checked;
registersView.Weight = Convert.ToDouble(fieldWeight.Text);
}
else
{
// Если нет, то создаем новую запись в таблице RegistersView с параметрами из таблицы
registersView = new RegistersView();
registersView.Active = true;
registersView.FkRegistersUsersMap = regUsrMap.RegistersUsersMapID;
//registersView.FkField = Convert.ToInt32(fieldId.Text); PORT
//registersView.Weight = Convert.ToDouble(fieldWeight.Text); PORT
registersView.FkField = fieldid;
registersView.Weight = fieldweight;
dataContext.RegistersView.InsertOnSubmit(registersView);
}
dataContext.SubmitChanges();
rowIndex++;
}
}
}
}
Response.Redirect("RegisterView.aspx");
}
