protected void btnAddWorkFlowMessage_Click(object sender, EventArgs e)
{
// get the textbox value and use it to create a new record in Project
TextBox txtSubject = (TextBox)frmWorkFlowMessage.FindControl("txtSubject");
TextBox txtTo = (TextBox)frmWorkFlowMessage.FindControl("txtTo");
TextBox txtFrom = (TextBox)frmWorkFlowMessage.FindControl("txtFrom");
TextBox txtCC = (TextBox)frmWorkFlowMessage.FindControl("txtCC");
TextBox txtMessage = (TextBox)frmWorkFlowMessage.FindControl("txtMessage");
using (Models.TLGX_MAPPEREntities1 myEntity = new Models.TLGX_MAPPEREntities1())
{
Models.m_WorkFlowMessage myWorkflowMessage = new Models.m_WorkFlowMessage()
{
Create_Date = DateTime.Now,
Create_User = System.Web.HttpContext.Current.User.Identity.Name,
To = txtTo.Text.Trim(),
From = txtFrom.Text.Trim(),
Cc = txtCC.Text.Trim(),
Text = txtMessage.Text.Trim(),
m_WorkFlowMessage_Id = Guid.NewGuid(),
Subject = txtSubject.Text.Trim()
};
myEntity.m_WorkFlowMessage.Add(myWorkflowMessage);
myEntity.SaveChanges();
// refresh page however you like, but you'll need to set focus to the Appproval Role Master tab
}
}
protected void frmWorkFlowMessage_ItemUpdating(object sender, FormViewUpdateEventArgs e)
{
string myDataKey = e.Keys["m_WorkFlowMessage_Id"].ToString();
Guid myRow_Id = Guid.Parse(myDataKey);
// get the textbox value and use it to create a new record in Project
TextBox txtSubject = (TextBox)frmWorkFlowMessage.FindControl("txtSubject");
TextBox txtTo = (TextBox)frmWorkFlowMessage.FindControl("txtTo");
TextBox txtFrom = (TextBox)frmWorkFlowMessage.FindControl("txtFrom");
TextBox txtCC = (TextBox)frmWorkFlowMessage.FindControl("txtCC");
TextBox txtMessage = (TextBox)frmWorkFlowMessage.FindControl("txtMessage");
using (Models.TLGX_MAPPEREntities1 context = new Models.TLGX_MAPPEREntities1())
{
var result = (from apr in context.m_WorkFlowMessage
where apr.m_WorkFlowMessage_Id == myRow_Id
select apr).First();
result.m_WorkFlowMessage_Id = myRow_Id;
result.Subject = txtSubject.Text.Trim();
result.From = txtFrom.Text.Trim();
result.To = txtTo.Text.Trim();
result.Text = txtMessage.Text.Trim();
result.Edit_Date = DateTime.Now;
result.Edit_User = System.Web.HttpContext.Current.User.Identity.Name;
context.SaveChanges();
// refresh page however you like, but you'll need to set focus to the Appproval Role Master tab
}
}
public DataTable GetSupplierList()
{
DataTable dtRet = new DataTable();
using (Models.TLGX_MAPPEREntities1 context = new Models.TLGX_MAPPEREntities1())
{
var supplierData = (from s in context.Suppliers
orderby s.Name ascending
select new Models.BusinessEntity.Suppliers
{
Supplier_Id = s.Supplier_Id,
Code = s.Code,
Name = s.Name,
SupplierType = s.SupplierType,
SupplierOwner = s.SupplierOwner,
Create_Date = s.Create_Date,
Create_User = s.Create_User,
Edit_Date = s.Edit_Date,
Edit_User = s.Edit_User
}
).ToList();
dtRet = ConversionClass.CreateDataTable(supplierData);
return(dtRet);
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (!IsPostBack)
{
fillstatus();
fillteams();
}
using (Models.TLGX_MAPPEREntities1 context = new Models.TLGX_MAPPEREntities1())
{
var teamData = (from s in context.m_Teams
select new Models.dataProject.Teams
{
Team_Id = s.Team_ID,
Team_Name = s.Team_Name,
Status = s.Status,
CREATE_DATE = s.CREATE_DATE,
CREATE_USER = s.CREATE_USER,
UPDATE_DATE = s.UPDATE_DATE,
UPDATE_USER = s.UPDATE_USER
}
).ToList();
grdTeamList.DataSource = teamData;
grdTeamList.DataBind();
}
}
protected void frmActivityMaster_ItemUpdating(object sender, FormViewUpdateEventArgs e)
{
string myDataKey = e.Keys["Activity_Master_ID"].ToString();
Guid myRow_Id = Guid.Parse(myDataKey);
TextBox txtActivityName = (TextBox)frmActivityMaster.FindControl("txtActivityName");
TextBox txtActivityClassName = (TextBox)frmActivityMaster.FindControl("txtActivityClassName");
TextBox txtActivityMethodName = (TextBox)frmActivityMaster.FindControl("txtActivityMethodName");
TextBox txtStatus = (TextBox)frmActivityMaster.FindControl("txtStatus");
TextBox txtStatusMessage = (TextBox)frmActivityMaster.FindControl("txtStatusMessage");
TextBox txtDescription = (TextBox)frmActivityMaster.FindControl("txtDescription");
using (Models.TLGX_MAPPEREntities1 context = new Models.TLGX_MAPPEREntities1())
{
var result = (from apr in context.m_Activity_Master
where apr.Activity_Master_ID == myRow_Id
select apr).First();
result.UPDATE_DATE = DateTime.Now;
result.UPDATE_USER = System.Web.HttpContext.Current.User.Identity.Name;
result.Activity_Master_ID = myRow_Id;
result.Activity_Name = txtActivityName.Text.Trim();
result.Activity_Class_Name = txtActivityClassName.Text.Trim();
result.Activity_Method_Name = txtActivityMethodName.Text.Trim();
result.Status = txtStatus.Text.Trim();
result.Status_Message = txtStatusMessage.Text.Trim();
result.Description = txtDescription.Text.Trim();
context.SaveChanges();
// refresh page however you like, but you'll need to set focus to the Appproval Role Master tab
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack)
{
}
else
{
if (Request.QueryString["Team_Id"] != null)
{
frmMasterTeam.ChangeMode(FormViewMode.Edit);
// use Team_Id to populate the datasource
Guid myTeam_Id = Guid.Parse(Request.QueryString["Team_Id"]);
using (Models.TLGX_MAPPEREntities1 context = new Models.TLGX_MAPPEREntities1())
{
var Team = context.m_Teams.Find(myTeam_Id);
var list = new List <Models.m_Teams> {
Team
};
frmMasterTeam.DataSource = list;
frmMasterTeam.DataBind();
}
}
else
{
//leave the datasource blank and change to insert mode
frmMasterTeam.ChangeMode(FormViewMode.Insert);
}
}
}
// not handling OBJECT ID at the moment as i don't know how you will impliment it
protected void frmApprovalStatusMasters_ItemUpdating(object sender, FormViewUpdateEventArgs e)
{
string myDataKey = e.Keys["Appr_status_id"].ToString();
Guid myRow_Id = Guid.Parse(myDataKey);
TextBox txtStatus = (TextBox)frmApprovalStatusMasters.FindControl("txtStatus");
TextBox txtObjectType = (TextBox)frmApprovalStatusMasters.FindControl("txtObjectType");
TextBox txtHierarchy = (TextBox)frmApprovalStatusMasters.FindControl("txtHierarchy");
using (Models.TLGX_MAPPEREntities1 context = new Models.TLGX_MAPPEREntities1())
{
var result = (from apr in context.m_Approval_StatusMaster
where apr.Appr_status_id == myRow_Id
select apr).First();
{
result.Status = txtStatus.Text.Trim();
result.Object_type = txtObjectType.Text.Trim();
result.Object_id = Guid.Empty; // dummying in a GUID as i'm not sure what's happening
result.UPDATE_DATE = DateTime.Now;
result.UPDATE_USER = System.Web.HttpContext.Current.User.Identity.Name;
result.Status_hierarchy = int.Parse(txtHierarchy.Text.Trim());
}
context.SaveChanges();
// refresh page however you like, but you'll need to set focus to the Appproval Role Master tab
}
}
// runs the insert on a new
protected void btnAddActivityMaster_Click(object sender, EventArgs e)
{
// get the textbox value and use it to create a new record in Project
TextBox txtActivityName = (TextBox)frmActivityMaster.FindControl("txtActivityName");
TextBox txtActivityClassName = (TextBox)frmActivityMaster.FindControl("txtActivityClassName");
TextBox txtActivityMethodName = (TextBox)frmActivityMaster.FindControl("txtActivityMethodName");
TextBox txtStatus = (TextBox)frmActivityMaster.FindControl("txtStatus");
TextBox txtStatusMessage = (TextBox)frmActivityMaster.FindControl("txtStatusMessage");
TextBox txtDescription = (TextBox)frmActivityMaster.FindControl("txtDescription");
using (Models.TLGX_MAPPEREntities1 myEntity = new Models.TLGX_MAPPEREntities1())
{
Models.m_Activity_Master myActivityMaster = new Models.m_Activity_Master()
{
Activity_Master_ID = Guid.NewGuid(),
Activity_Name = txtActivityName.Text.Trim(),
Activity_Class_Name = txtActivityClassName.Text.Trim(),
Activity_Method_Name = txtActivityMethodName.Text.Trim(),
Status = txtStatus.Text.Trim(),
Status_Message = txtStatusMessage.Text.Trim(),
Description = txtDescription.Text.Trim(),
CREATE_DATE = DateTime.Now,
CREATE_USER = System.Web.HttpContext.Current.User.Identity.Name
};
myEntity.m_Activity_Master.Add(myActivityMaster);
myEntity.SaveChanges();
// refresh page however you like, but you'll need to set focus to the Appproval Role Master tab
}
}
// not handling OBJECT ID at the moment as i don't know how you will impliment it
protected void frmApprovalStatusMasters_ItemInserting(object sender, FormViewInsertEventArgs e)
{
// get the textbox value and use it to create a new record in Project
TextBox txtStatus = (TextBox)frmApprovalStatusMasters.FindControl("txtStatus");
TextBox txtObjectType = (TextBox)frmApprovalStatusMasters.FindControl("txtObjectType");
TextBox txtHierarchy = (TextBox)frmApprovalStatusMasters.FindControl("txtHierarchy");
using (Models.TLGX_MAPPEREntities1 myEntity = new Models.TLGX_MAPPEREntities1())
{
Models.m_Approval_StatusMaster myApprovalStatusMaster = new Models.m_Approval_StatusMaster()
{
Appr_status_id = Guid.NewGuid(),
Status = txtStatus.Text.Trim(),
Object_type = txtObjectType.Text.Trim(),
Object_id = Guid.Empty, // dummying in a GUID
Status_hierarchy = int.Parse(txtHierarchy.Text.Trim()), // you'll need to add validation on this bit
CREATE_DATE = DateTime.Now,
CREATE_USER = System.Web.HttpContext.Current.User.Identity.Name
};
myEntity.m_Approval_StatusMaster.Add(myApprovalStatusMaster);
myEntity.SaveChanges();
// refresh page however you like, but you'll need to set focus to the Appproval Role Master tab
}
}
//performs the insert but no rebind added
protected void btnAddApprovalRoleMaster_Click(object sender, EventArgs e)
{
// get the textbox value and use it to create a new record in Project
TextBox txtApprovalRoleName = (TextBox)frmApprovalRoleMaster.FindControl("txtRoleName");
TextBox txtDescription = (TextBox)frmApprovalRoleMaster.FindControl("txtDescription");
DropDownList ddlStatus = (DropDownList)frmApprovalRoleMaster.FindControl("ddlStatus");
using (Models.TLGX_MAPPEREntities1 myEntity = new Models.TLGX_MAPPEREntities1())
{
Models.m_Approval_RoleMaster myApprovalRoleMaster = new Models.m_Approval_RoleMaster()
{
Appr_Role_ID = Guid.NewGuid(),
Role_Name = txtApprovalRoleName.Text.Trim(),
Description = txtDescription.Text.Trim(),
Status = ddlStatus.SelectedValue.ToString(),
CREATE_DATE = DateTime.Now,
CREATE_USER = System.Web.HttpContext.Current.User.Identity.Name
};
myEntity.m_Approval_RoleMaster.Add(myApprovalRoleMaster);
myEntity.SaveChanges();
// refresh page however you like, but you'll need to set focus to the Appproval Role Master tab
}
}
// binds formview to gridview selected item
protected void grdActivityMasters_SelectedIndexChanged(object sender, EventArgs e)
{
Guid myRowId = Guid.Parse(grdActivityMasters.SelectedDataKey.Value.ToString());
frmActivityMaster.ChangeMode(FormViewMode.Edit);
using (Models.TLGX_MAPPEREntities1 context = new Models.TLGX_MAPPEREntities1())
{
var myActivityMaster = context.m_Activity_Master.Find(myRowId);
var list = new List <Models.m_Activity_Master> {
myActivityMaster
};
frmActivityMaster.DataSource = list;
frmActivityMaster.DataBind();
}
}
protected void grdWorkFlowMessage_SelectedIndexChanged(object sender, EventArgs e)
{
Guid myRowId = Guid.Parse(grdWorkFlowMessage.SelectedDataKey.Value.ToString());
frmWorkFlowMessage.ChangeMode(FormViewMode.Edit);
using (Models.TLGX_MAPPEREntities1 context = new Models.TLGX_MAPPEREntities1())
{
var myWorkflowMessage = context.m_WorkFlowMessage.Find(myRowId);
var list = new List <Models.m_WorkFlowMessage> {
myWorkflowMessage
};
frmWorkFlowMessage.DataSource = list;
frmWorkFlowMessage.DataBind();
}
}
//needs postback handling
protected void Page_Load(object sender, EventArgs e)
{
using (Models.TLGX_MAPPEREntities1 context = new Models.TLGX_MAPPEREntities1())
{
var activityMasterData = (from s in context.m_Activity_Master
select new Models.DynamicWorkflow.ActivityMaster
{
Activity_Master_Id = s.Activity_Master_ID,
Activity_Class_Name = s.Activity_Class_Name,
Activity_Method_Name = s.Activity_Method_Name,
Activity_Name = s.Activity_Name,
Description = s.Description,
Status = s.Status,
Status_Message = s.Status_Message
}
).ToList();
grdActivityMasters.DataSource = activityMasterData;
grdActivityMasters.DataBind();
}
}
protected void btnAddProject_Click(object sender, EventArgs e)
{
// get the textbox value and use it to create a new record in Project
TextBox txtProjectName = (TextBox)frmProject.FindControl("txtProjectName");
using (Models.TLGX_MAPPEREntities1 myEntity = new Models.TLGX_MAPPEREntities1())
{
Models.Project myProject = new Models.Project()
{
Project_ID = Guid.NewGuid(),
Project_Name = txtProjectName.Text.Trim(),
Status = "Active",
CREATE_DATE = DateTime.Now,
CREATE_USER = System.Web.HttpContext.Current.User.Identity.Name
};
myEntity.Projects.Add(myProject);
myEntity.SaveChanges();
};
// ask rubesh of we can pull the last inserted row id from EDF
}
//needs postback handling
protected void Page_Load(object sender, EventArgs e)
{
using (Models.TLGX_MAPPEREntities1 context = new Models.TLGX_MAPPEREntities1())
{
var approvalRoleMasterData = (from s in context.m_Approval_RoleMaster
select new Models.DynamicWorkflow.ApprovalRoleMaster
{
Appr_Role_ID = s.Appr_Role_ID,
Description = s.Description,
Role_Name = s.Role_Name,
Status = s.Status,
CREATE_DATE = s.CREATE_DATE,
CREATE_USER = s.CREATE_USER,
UPDATE_DATE = s.UPDATE_DATE,
UPDATE_USER = s.UPDATE_USER
}
).ToList();
grdApprovalRoleMasters.DataSource = approvalRoleMasterData;
grdApprovalRoleMasters.DataBind();
}
}
//needs postback handling...
protected void Page_Load(object sender, EventArgs e)
{
using (Models.TLGX_MAPPEREntities1 context = new Models.TLGX_MAPPEREntities1())
{
var ApprovalStatusMasterData = (from s in context.m_Approval_StatusMaster
select new Models.DynamicWorkflow.ApprovalStatusMaster
{
Appr_status_id = s.Appr_status_id,
Object_Id = s.Object_id ?? Guid.Empty,
Object_type = s.Object_type,
Status = s.Status,
CREATE_DATE = s.CREATE_DATE,
CREATE_USER = s.CREATE_USER,
UPDATE_DATE = s.UPDATE_DATE,
UPDATE_USER = s.UPDATE_USER,
Status_hierarchy = s.Status_hierarchy ?? 0
}
).ToList();
grdApprovalStatusMasters.DataSource = ApprovalStatusMasterData;
grdApprovalStatusMasters.DataBind();
}
}
protected void Page_Load(object sender, EventArgs e)
{
if (Page.IsPostBack)
{
}
else
{
if (Request.QueryString["Project_Id"] != null)
{
frmProject.ChangeMode(FormViewMode.Edit);
// use Project_Id to populate the datasource
Guid myProject_ID = Guid.Parse(Request.QueryString["Project_Id"]);
using (Models.TLGX_MAPPEREntities1 context = new Models.TLGX_MAPPEREntities1())
{
var projectData = context.Projects.Find(myProject_ID);
var list = new List <Models.Project> {
projectData
};
frmProject.DataSource = list;
frmProject.DataBind();
fillStatusDropdown();
}
}
else
{
//leave the datasource blank and change to insert mode
frmProject.ChangeMode(FormViewMode.Insert);
}
}
}
// you need to handle the postback here dude
protected void Page_Load(object sender, EventArgs e)
{
using (Models.TLGX_MAPPEREntities1 context = new Models.TLGX_MAPPEREntities1())
{
var workflowMessageData = (from s in context.m_WorkFlowMessage
select new Models.DynamicWorkflow.WorkFlowMessage
{
WorkFlowMessage_Id = s.m_WorkFlowMessage_Id,
Cc = s.Cc,
Create_Date = s.Create_Date,
Create_User = s.Create_User,
Edit_Date = s.Edit_Date,
Edit_User = s.Edit_User,
From = s.From,
Subject = s.Subject,
Text = s.Text,
To = s.To
}
).ToList();
grdWorkFlowMessage.DataSource = workflowMessageData;
grdWorkFlowMessage.DataBind();
}
}
