private void refreshList()
{
TEMPOServerProxy tsp = TEMPO.RequestBroker.TEMPOServerProxy.Instance;
EmployeeDS eds = tsp.GetAllEmployees();
ctv.refreshTree(eds);
}
//Init
private void initConstructor(DBMAINContext poDB)
{
//DBContext
this.db = poDB;
//VM
this.oVM = new TaskVM();
//DS
this.oDS = new TaskDS(this.db);
this.oDSDetail = new TaskdDS(this.db);
this.oDSDetail_worker = new Taskd_workerDS(this.db);
this.oDSEmployee = new EmployeeDS(this.db);
this.oDSEmployeeuser = new EmployeeuserDS(this.db);
this.oDSMonth = new MonthDS(this.db);
this.oDSYear = new YearDS(this.db);
this.oDSProgresssts = new ProgressstsDS(this.db);
this.oDSValidatests = new ValidatestsDS(this.db);
this.oDSProject = new ProjectDS(this.db);
//CRUD
this.oCRUD = new Task_workerCRUD(this.db);
//BL
//MAP
//JSON
JsSerialize = new JavaScriptSerializer();
} //End initConstructor
public EmployeeCRUDPanel() : base(new Point(20, 140), new Size(820, 430), "EmployeeCRUD", false)
{
// background
this.setGraphic(new Bitmap(typeof(TEMPO.Client.MainScreen), "Resources.CRUDpanel.png"));
// obtain the data from the server
TEMPOServerProxy tsp = TEMPO.RequestBroker.TEMPOServerProxy.Instance;
EmployeeDS eds = tsp.GetAllEmployees();
// populate the control
ctv = new CRUDTreeViewDS("Employees", eds, "EmployeeName");
// assign the event handler
ctv.onCRUDItemClicked += new CRUDTreeViewDS.CRUDItemClickedDelegate(openEntity);
ctv.Location = new Point(32, 71);
ctv.Size = new Size(306, 222);
this.Controls.Add(ctv);
entrypanel = new EmployeeCRUDEntryPanel(EmployeeCRUDEntryPanel.EntryType.Save);
entrypanel.Visible = false;
entrypanel.onRecordMaintained += new EmployeeCRUDEntryPanel.RecordMaintainDelegate(refreshList);
this.Controls.Add(entrypanel);
createpanel = new EmployeeCRUDEntryPanel(EmployeeCRUDEntryPanel.EntryType.Create);
createpanel.Visible = false;
createpanel.onRecordMaintained += new EmployeeCRUDEntryPanel.RecordMaintainDelegate(refreshList);
this.Controls.Add(createpanel);
create = new GraphicButton(new Point(180, 315), new Size(155, 28));
create.setGraphic(new Bitmap(typeof(TEMPO.Client.MainScreen), "Resources.addnewdocument.png"));
create.Click += new System.EventHandler(newRecord);
this.Controls.Add(create);
}
public void Update(EmployeeDS ds)
{
string sql;
SqlConnection conn = new SqlConnection(this.DBConnectionString);
sql = "insert into Employee (EmployeeName, Password, Rate, Active) values (@EmployeeName, @Password, @Rate, @Active); SELECT @@IDENTITY as EmpID";
SqlCommand insertCommand = new SqlCommand(sql, conn);
insertCommand.Parameters.Add("@EmployeeName", System.Data.SqlDbType.VarChar, 255, "EmployeeName");
insertCommand.Parameters.Add("@Password", System.Data.SqlDbType.VarChar, 15, "Password");
insertCommand.Parameters.Add("@Rate", System.Data.SqlDbType.Decimal, 9, "Rate");
insertCommand.Parameters.Add("@Active", System.Data.SqlDbType.Bit, 1, "Active");
insertCommand.UpdatedRowSource = UpdateRowSource.FirstReturnedRecord;
sql = "update Employee set EmployeeName = @EmployeeName, Password = @Password, Rate = @Rate, Active = @Active Where Empid = @EmpID";
SqlCommand updateCommand = new SqlCommand(sql, conn);
updateCommand.Parameters.Add("@EmployeeName", System.Data.SqlDbType.VarChar, 255, "EmployeeName");
updateCommand.Parameters.Add("@Password", System.Data.SqlDbType.VarChar, 15, "Password");
updateCommand.Parameters.Add("@Rate", System.Data.SqlDbType.Decimal, 9, "Rate");
updateCommand.Parameters.Add("@Active", System.Data.SqlDbType.Bit, 1, "Active");
updateCommand.Parameters.Add("@EmpID", System.Data.SqlDbType.Int, 4, "EmpID");
sql = "delete from Employee Where Empid = @EmpID";
SqlCommand deleteCommand = new SqlCommand(sql, conn);
deleteCommand.Parameters.Add("@EmpID", System.Data.SqlDbType.Int, 4, "EmpID");
try {
SqlHelper.UpdateDataset(insertCommand, deleteCommand, updateCommand, ds, "Employee");
}
catch {
throw new Exception();
}
}
public override global::System.Data.DataSet Clone()
{
EmployeeDS cln = ((EmployeeDS)(base.Clone()));
cln.InitVars();
cln.SchemaSerializationMode = this.SchemaSerializationMode;
return(cln);
}
public void CreateEmployee(EmployeeDS ds, int[] roles)
{
EmployeeDALC edalc = new EmployeeDALC();
edalc.Update(ds);
AuthorizationDALC adalc = new AuthorizationDALC();
adalc.UpdateRoles(roles, ds.Employee[0].EmpID);
}
public void UpdateEmployees(EmployeeDS ds, int[] roles, int empid)
{
EmployeeDALC edalc = new EmployeeDALC();
edalc.Update(ds);
AuthorizationDALC adalc = new AuthorizationDALC();
adalc.UpdateRoles(roles, empid);
}
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedDataSetSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
EmployeeDS ds = new EmployeeDS();
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
global::System.Xml.Schema.XmlSchemaAny any = new global::System.Xml.Schema.XmlSchemaAny();
any.Namespace = ds.Namespace;
sequence.Items.Add(any);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}
//BL
//MAP
//Init
private void initConstructor(DBMAINContext poDB)
{
//DBContext
this.db = poDB;
//VM
this.oVM = new TaskreportVM();
//DS
this.oDS = new TaskreportDS(this.db);
this.oDSEmployee = new EmployeeDS(this.db);
//CRUD
//this.oCRUD = new TaskreportCRUD(this.db);
//BL
//MAP
} //End initConstructor
//BL
//MAP
//Init
private void initConstructor(DBMAINContext poDB)
{
//DBContext
this.db = poDB;
//VM
this.oVM = new EmployeeVM();
//DS
this.oDS = new EmployeeDS(this.db);
this.oDSUnit = new UnitDS(this.db);
this.oDSJobtitle = new JobtitleDS(this.db);
//CRUD
this.oCRUD = new EmployeeCRUD(this.db);
//BL
//MAP
} //End initConstructor
} //End public static void setValidCredential(User_DetailVM poViewmodel)
public static void setEmployee_Jobinfo(string psRES_RUID)
{
if ((psRES_RUID != null) && (psRES_RUID != ""))
{
EmployeeDS oDS = new EmployeeDS();
//EmployeeJobinfo oVM = oDS.getData_Jobinfo(psRES_RUID);
Employee_jobattrVM oVM = oDS.getData_jobattr(psRES_RUID);
hlpConfig.SessionInfo.setAppUsrRES_RUID(psRES_RUID);
hlpConfig.SessionInfo.setAppUsrRES_NM(oVM.RES_NM1);
hlpConfig.SessionInfo.setAppUsrDEPT_RUID(oVM.DEPT_RUID);
hlpConfig.SessionInfo.setAppUsrDEPT_NM(oVM.DEPT_NM);
hlpConfig.SessionInfo.setAppUsrJOBTTL_RUID(oVM.JOB_TITLE_RUID);
hlpConfig.SessionInfo.setAppUsrJOBTTL_NM(oVM.JOB_TITLE_NM);
} //End if ((psRES_RUID != null) && (psRES_RUID != ""))
} //End public static void setEmployee_Jobinfo(string psRES_RUID)
/// <summary>
/// Authenticate a user and return their ID
/// </summary>
/// <param name="username">the username of the user to authenticate</param>
/// <param name="password">the password of the user to authenticate</param>
/// <returns></returns>
public int AuthenticateUser(string username, string password)
{
DbCommand command = tempodb.GetStoredProcCommand("GetEmployee");
// assign the paramater
tempodb.AddInParameter(command, "@employeename", DbType.String, username);
tempodb.AddInParameter(command, "@password", DbType.String, password);
// build the empty data set
EmployeeDS employeeds = new EmployeeDS();
// populate the dataset
tempodb.LoadDataSet(command, employeeds, new string[] { "Employee" });
if (employeeds.Employee.Count != 0)
{
return(employeeds.Employee[0].EmpID);
}
else
{
return(-1);
}
}
/// <summary>
/// Get a specific Employee
/// </summary>
/// <param name="employeeid">the id of the employee to get</param>
/// <returns>a strongly typed employee data set</returns>
public EmployeeDS GetAllEmployees()
{
string sql;
sql = "select * from Employee;";
EmployeeDS empds = new EmployeeDS();
string[] tables = new string[] { "Employee" };
SqlParameter[] sqlparams = new SqlParameter[5];
SqlParameter temp = new SqlParameter("@EmpID", SqlDbType.Int, 4, "EmpID");
temp.Direction = System.Data.ParameterDirection.Output;
sqlparams[0] = temp;
temp = new SqlParameter("@EmployeeName", SqlDbType.VarChar, 4, "EmployeeName");
temp.Direction = System.Data.ParameterDirection.Output;
sqlparams[1] = temp;
temp = new SqlParameter("@Password", SqlDbType.VarChar, 4, "Password");
temp.Direction = System.Data.ParameterDirection.Output;
sqlparams[2] = temp;
temp = new SqlParameter("@Rate", SqlDbType.Decimal, 4, "Rate");
temp.Direction = System.Data.ParameterDirection.Output;
sqlparams[3] = temp;
temp = new SqlParameter("@Active", SqlDbType.Bit, 4, "Active");
temp.Direction = System.Data.ParameterDirection.Output;
sqlparams[4] = temp;
SqlHelper.FillDataset(this.DBConnectionString, System.Data.CommandType.Text, sql, empds, tables, sqlparams);
return(empds);
}
} //End public static void setValidCredential()
public static void setValidCredential(string psUsername = null, UsercredentialVM poViewmodel = null, int?pnMdleId = null)
{
hlpConfig.SessionInfo.setAppUsername(psUsername);
hlpConfig.SessionInfo.setAppUserdisplayname(poViewmodel.DISPLAY_NAME);
hlpConfig.SessionInfo.setAppUserId(poViewmodel.ID);
hlpConfig.SessionInfo.setAppRoleId(poViewmodel.ROLE_ID);
hlpConfig.SessionInfo.setAppResId(poViewmodel.RES_ID);
hlpConfig.SessionInfo.setAppMdleId(pnMdleId);
hlpConfig.SessionInfo.setAppUserIMG(poViewmodel.USER_IMG);
string sTempinfo1 = "";
string sTempinfo2 = "";
string sTempinfo3 = "";
string sTempinfo4 = "";
string sIMG = Utility_FileUploadDownload.getImage_UserNA();
if (poViewmodel.ROLE_ID == APPBASE.Svcbiz.valFLAG.FLAG_ROLE_P)
{
StudentDS oDSStudent = new StudentDS();
var oData = oDSStudent.getData_shortinfo(poViewmodel.RES_ID);
if (oData != null)
{
if (oData.STUDENT_IMG != null)
{
sIMG = Utility_FileUploadDownload.getImage_Student(oData.STUDENT_IMG);
}
sTempinfo1 = "";
if (oData.BRANCH_DESC != null)
{
sTempinfo1 = oData.BRANCH_DESC;
}
sTempinfo2 = "";
if (oData.CLASSTYPE_NAME != null)
{
sTempinfo2 = oData.CLASSTYPE_NAME;
}
sTempinfo3 = "";
if (oData.CLASSROOM_NAME != null)
{
sTempinfo3 = oData.CLASSROOM_NAME;
}
sTempinfo4 = "";
if (oData.CLASSTYPE_ID != null)
{
sTempinfo4 = oData.CLASSTYPE_ID.ToString();
}
} //End if (oData != null)
} //End if (poViewmodel.ROLE_ID == APPBASE.Svcbiz.valFLAG.FLAG_ROLE_P)
else
{
EmployeeDS oDSEmployee = new EmployeeDS();
var oData = oDSEmployee.getData_shortinfo(poViewmodel.RES_ID);
if (oData != null)
{
if (oData.EMPLOYEE_IMG != null)
{
sIMG = Utility_FileUploadDownload.getImage_Employee(oData.EMPLOYEE_IMG);
}
sTempinfo1 = "";
if (oData.BRANCH_DESC != null)
{
sTempinfo1 = oData.BRANCH_DESC;
}
sTempinfo2 = "";
if (oData.SENTRA_NAME != null)
{
sTempinfo2 = oData.SENTRA_NAME;
}
sTempinfo3 = "";
if (oData.JOBTITLE_DESC != null)
{
sTempinfo3 = oData.JOBTITLE_DESC;
}
} //End if (oData != null)
} //End if (poViewmodel.ROLE_ID == APPBASE.Svcbiz.valFLAG.FLAG_ROLE_P)
hlpConfig.SessionInfo.setAppResIMG(sIMG);
hlpConfig.SessionInfo.setAppResinfo1(sTempinfo1);
hlpConfig.SessionInfo.setAppResinfo2(sTempinfo2);
hlpConfig.SessionInfo.setAppResinfo3(sTempinfo3);
hlpConfig.SessionInfo.setAppResinfo4(sTempinfo4);
} //End public static void setValidCredential()
public static global::System.Xml.Schema.XmlSchemaComplexType GetTypedTableSchema(global::System.Xml.Schema.XmlSchemaSet xs)
{
global::System.Xml.Schema.XmlSchemaComplexType type = new global::System.Xml.Schema.XmlSchemaComplexType();
global::System.Xml.Schema.XmlSchemaSequence sequence = new global::System.Xml.Schema.XmlSchemaSequence();
EmployeeDS ds = new EmployeeDS();
global::System.Xml.Schema.XmlSchemaAny any1 = new global::System.Xml.Schema.XmlSchemaAny();
any1.Namespace = "http://www.w3.org/2001/XMLSchema";
any1.MinOccurs = new decimal(0);
any1.MaxOccurs = decimal.MaxValue;
any1.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any1);
global::System.Xml.Schema.XmlSchemaAny any2 = new global::System.Xml.Schema.XmlSchemaAny();
any2.Namespace = "urn:schemas-microsoft-com:xml-diffgram-v1";
any2.MinOccurs = new decimal(1);
any2.ProcessContents = global::System.Xml.Schema.XmlSchemaContentProcessing.Lax;
sequence.Items.Add(any2);
global::System.Xml.Schema.XmlSchemaAttribute attribute1 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute1.Name = "namespace";
attribute1.FixedValue = ds.Namespace;
type.Attributes.Add(attribute1);
global::System.Xml.Schema.XmlSchemaAttribute attribute2 = new global::System.Xml.Schema.XmlSchemaAttribute();
attribute2.Name = "tableTypeName";
attribute2.FixedValue = "EmployeeDataTable";
type.Attributes.Add(attribute2);
type.Particle = sequence;
global::System.Xml.Schema.XmlSchema dsSchema = ds.GetSchemaSerializable();
if (xs.Contains(dsSchema.TargetNamespace))
{
global::System.IO.MemoryStream s1 = new global::System.IO.MemoryStream();
global::System.IO.MemoryStream s2 = new global::System.IO.MemoryStream();
try {
global::System.Xml.Schema.XmlSchema schema = null;
dsSchema.Write(s1);
for (global::System.Collections.IEnumerator schemas = xs.Schemas(dsSchema.TargetNamespace).GetEnumerator(); schemas.MoveNext();)
{
schema = ((global::System.Xml.Schema.XmlSchema)(schemas.Current));
s2.SetLength(0);
schema.Write(s2);
if ((s1.Length == s2.Length))
{
s1.Position = 0;
s2.Position = 0;
for (; ((s1.Position != s1.Length) &&
(s1.ReadByte() == s2.ReadByte()));)
{
;
}
if ((s1.Position == s1.Length))
{
return(type);
}
}
}
}
finally {
if ((s1 != null))
{
s1.Close();
}
if ((s2 != null))
{
s2.Close();
}
}
}
xs.Add(dsSchema);
return(type);
}