protected void Page_Load(object sender, EventArgs e)
{
if (Session["userName"] == null)
{
Response.Redirect("~/Login/Login.aspx");
}
else
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection conn = new SqlConnection(CS))
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlDataAdapter da = new SqlDataAdapter("select FirstName,LastName,Address,Gender,BloodGroup,E_mail,ContactNumber from bloodBank", conn);
DataSet ds = new DataSet();
da.Fill(ds);
DashboardGridView.DataSource = ds;
DashboardGridView.DataBind();
}
}
}
private async void Init()
{
try
{
DashboardGridView.ShowLoadingPanel();
UnitOfWork unitOfWork = new UnitOfWork();
var documents = unitOfWork.DocumentActionsRepo.Fetch(x =>
x.RoutedToUsers.Any(m => m.Id == User.UserId) && x.IsSend == true && x.isDone != true, includeProperties: "RoutedToUsers");
this.cboUsers.Properties.DataSource = await unitOfWork.UsersRepo.Fetch(x => x.OfficeId == staticSettings.OfficeId).ToListAsync();
DashboardGridControl.DataSource = await documents.ToListAsync();
this.documentActionsBindingSource.DataSource = await documents.ToListAsync();
this.cboUsers.EditValue = User.UserId;
if (!User.UsersInRole("Super Administrator"))
{
this.DashboardGridView.Columns[0].VisibleIndex = -1;
}
this.lblTotalCount.Text = $@"Total Count {documents.Count()}";
// this.Detail(await documents.FirstOrDefaultAsync());
DashboardGridView.HideLoadingPanel();
}
catch (Exception e)
{
}
}
private void lblControlNo_Click(object sender, EventArgs e)
{
if (DashboardGridView.GetFocusedRow() is DocumentActions documentActions)
{
if (documentActions.TableName == "Obligations")
{
Main frm = Application.OpenForms["Main"] as Main;
frm.pnlMain.Controls.Clear();
var obr = new ucObligations()
{
Dock = DockStyle.Fill
};
obr.txtSearch.Text = documentActions.ControlNo;
frm.pnlMain.Controls.Add(obr);
obr.btnSearch.PerformClick();
}
else
{
Main frm = Application.OpenForms["Main"] as Main;
frm.pnlMain.Controls.Clear();
var pr = new PR.UCPurchaseRequest(documentActions.ControlNo)
{
Dock = DockStyle.Fill
};
//pr.txtSearch.Text = documentActions.ControlNo;
pr.loadAddEditPurchaseRequest.Search(documentActions.ControlNo, true);
frm.pnlMain.Controls.Add(pr);
pr.btnSearch.PerformClick();
}
}
}
private async void DashboardGridView_FocusedRowChanged(object sender, DevExpress.XtraGrid.Views.Base.FocusedRowChangedEventArgs e)
{
if (DashboardGridView.GetFocusedRow() is DocumentActions item)
{
await Detail(item);
}
}
private void DashboardGridView_RowCountChanged(object sender, EventArgs e)
{
if (DashboardGridView.GetRow(DashboardGridView.FocusedRowHandle) is DocumentActions item)
{
Detail(item);
}
}
private void btnTaskDone_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
if (DashboardGridView.GetFocusedRow() is DocumentActions item)
{
frmTaskDone frm = new frmTaskDone(item);
frm.ShowDialog();
Init();
}
}
private void btnTaskDelete_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
if (DashboardGridView.GetFocusedRow() is DocumentActions item)
{
if (MessageBox.Show("Do you want to submit this?", "Submit", MessageBoxButtons.YesNo, MessageBoxIcon.Question) == DialogResult.No)
{
return;
}
UnitOfWork unitOfWork = new UnitOfWork();
item = unitOfWork.DocumentActionsRepo.Find(x => x.Id == item.Id, "RoutedToUsers");
item.RoutedToUsers.Remove(unitOfWork.UsersRepo.Find(x => x.Id == User.UserId));
unitOfWork.Save();
Init();
}
}
private void btnAddAction_ButtonClick(object sender, DevExpress.XtraEditors.Controls.ButtonPressedEventArgs e)
{
if (DashboardGridView.GetFocusedRow() is DocumentActions item)
{
frmDocActions frm = new frmDocActions(MethodType.Add, new DocumentActions()
{
TableName = item.TableName,
ActionDate = DateTime.Now,
RefId = item.RefId,
CreatedBy = User.UserId,
DateCreated = DateTime.Now,
ControlNo = item.ControlNo,
Year = item.Year
});
frm.ShowDialog();
Init();
}
}
private async void Init()
{
try
{
DashboardGridView.ShowLoadingPanel();
var docs = await httpClient.GetAsync("api/dashboard/GetDocumentActions");
var userscontent = await httpClient.GetAsync("api/dashboard/GetUsers");
var docContent = await docs.Content.ReadAsStringAsync();
var documents = Newtonsoft.Json.JsonConvert.DeserializeObject <List <DocumentActionsVM> >(docContent);
this.cboUsers.Properties.DataSource = Newtonsoft.Json.JsonConvert.DeserializeObject <List <Users> >(await userscontent.Content.ReadAsStringAsync());
this.documentActionsBindingSource.DataSource = documents;
//txtSearchKey.Properties.DataSource = await Task.Run(() =>
// {
// var userIds = unitOfWork.UsersRepo.Fetch(x => x.OfficeId == staticSettings.OfficeId)
// .Select(x => x.Id);
// return unitOfWork.DocumentActionsRepo.Fetch(x => x.RoutedToUsers.Any(m => userIds.Contains(m.Id))).Distinct()
// .ToList();
// });
this.documentActionsBindingSource.DataSource = documents;
this.cboUsers.EditValue = User.UserId;
if (!User.UsersInRole("Super Administrator"))
{
this.DashboardGridView.Columns[0].VisibleIndex = -1;
}
this.lblTotalCount.Text = $@"Total Count {documents.Count()}";
this.Detail(documents.FirstOrDefault());
DashboardGridView.HideLoadingPanel();
}
catch (Exception e)
{
}
}
protected void Search_Button_Click(object sender, EventArgs e)
{
string CS = ConfigurationManager.ConnectionStrings["DBCS"].ConnectionString;
using (SqlConnection conn = new SqlConnection(CS))
{
if (conn.State == ConnectionState.Closed)
{
conn.Open();
}
SqlDataAdapter da = new SqlDataAdapter("spSearchBy", conn);
da.SelectCommand.CommandType = CommandType.StoredProcedure;
da.SelectCommand.Parameters.AddWithValue("@bloodGroupSearch", search.Text + "%");
DataSet ds = new DataSet();
da.Fill(ds);
DashboardGridView.DataSource = ds;
DashboardGridView.DataBind();
}
}
private void lblControlNo_Click(object sender, EventArgs e)
{
if (DashboardGridView.GetFocusedRow() is DocumentActions documentActions)
{
}
}
