public CResult TakeObject(SecurityUser_Entity oSecurityUser_Entity, EntityCommon.Mode Mode)
{
if (EntityCommon.Mode.dbzOk == Mode)
{
oDataSet = (DataSet)m_oCSQLCommandExecutor.DataAdapterQueryRequest("Select * from SecurityUser where UsrUserName = '******' And UsrPassword = '******'", oCommon.DBCon).Data;
if (oDataSet.Tables[0].Rows.Count > 0)
{
SqlCommand oSqlCommand = new SqlCommand("Update SecurityUser Set UsrPassword = '******' Where UsrUserName = '******' And UsrPassword = '******'", oCommon.DBCon);
int i = oSqlCommand.ExecuteNonQuery();
if (i > -1)
{
oCResult.IsSuccess = true;
oCResult.Message = "Successfull";
}
}
else
{
oCResult.IsSuccess = false;
oCResult.Message = "User Name or password is wrong.";
}
}
return(oCResult);
}
public CResult TakeObject(SecurityUser_Entity oSecurityUser_Entity, EntityCommon.Mode Mode)
{
if (EntityCommon.Mode.dbzAdd == Mode)
{
oCResult = m_oCSQLCommandExecutor.CheckDuplicate("Select * from SecurityUser where UsrUserName = '******' And UsrPassword = '******')", oCommon.DBCon);
if (oCResult.IsSuccess != false)
{
SqlCommand oSqlCommand = new SqlCommand("insert into SecurityUser(UsrDepartment,UsrLevel,UsrUserName,UsrFullName,UsrPassword,UsrEmailAddress,UsrActive,DateOfEntry) values('" + oSecurityUser_Entity.Department + "','" + oSecurityUser_Entity.Level + "','" + oSecurityUser_Entity.UserName + "','" + oSecurityUser_Entity.FullName + "','" + m_oCSQLCommandExecutor.EncripPassword(oSecurityUser_Entity.Password) + "','" + oSecurityUser_Entity.EmailAddress + "','" + oSecurityUser_Entity.Active + "','" + DateTime.Now.ToShortDateString() + "')", oCommon.DBCon);
try
{
int i = oSqlCommand.ExecuteNonQuery();
if (i > -1)
{
oCResult.IsSuccess = true;
oCResult.Message = "Successfull";
oDataSet = (DataSet)m_oCSQLCommandExecutor.DataAdapterQueryRequest("Select UsrDepartment,UsrLevel,UsrUserName from SecurityUser order by UsrUserName", oCommon.DBCon).Data;
oCResult.DataTableContainerSub = m_oCSQLCommandExecutor.LoadTable(oDataSet);
}
}
catch (Exception ex)
{
oCResult.IsSuccess = false;
oCResult.Message = ex.ToString();
}
}
}
if (EntityCommon.Mode.dbzEdit == Mode)
{
oCResult = m_oCSQLCommandExecutor.CheckDuplicate("Select * from SecurityUser where UsrUserName = '******' And UsrPassword = '******'", oCommon.DBCon);
if (oCResult.IsSuccess == false)
{
SqlCommand oSqlCommand = new SqlCommand("update SecurityUser set UsrDepartment='" + oSecurityUser_Entity.Department + "',UsrLevel='" + oSecurityUser_Entity.Level + "',UsrFullName='" + oSecurityUser_Entity.FullName + "',UsrPassword='******',UsrEmailAddress='" + oSecurityUser_Entity.EmailAddress + "',UsrActive='" + oSecurityUser_Entity.Active + "',DateOfEntry='" + DateTime.Now.ToShortDateString() + "' where UsrUserName = '******'", oCommon.DBCon);
try
{
int i = oSqlCommand.ExecuteNonQuery();
if (i > -1)
{
oCResult.IsSuccess = true;
oCResult.Message = "Successfull";
oDataSet = (DataSet)m_oCSQLCommandExecutor.DataAdapterQueryRequest("Select UsrDepartment,UsrLevel,UsrUserName from SecurityUser order by UsrUserName", oCommon.DBCon).Data;
oCResult.DataTableContainerSub = m_oCSQLCommandExecutor.LoadTable(oDataSet);
}
}
catch (Exception ex)
{
oCResult.IsSuccess = false;
oCResult.Message = ex.ToString();
}
}
else
{
oCResult.IsSuccess = false;
oCResult.Message = "Id not found.";
}
}
if (EntityCommon.Mode.dbzDelete == Mode)
{
oCResult = m_oCSQLCommandExecutor.CheckDuplicate("Select * from SecurityUser where UsrUserName = '******' And UsrPassword = '******'", oCommon.DBCon);
if (oCResult.IsSuccess == false)
{
SqlCommand oSqlCommand = new SqlCommand("Delete from SecurityUser where UsrUserName = '******'", oCommon.DBCon);
try
{
int i = oSqlCommand.ExecuteNonQuery();
if (i > -1)
{
oCResult.IsSuccess = true;
oCResult.Message = "Successfull";
oDataSet = (DataSet)m_oCSQLCommandExecutor.DataAdapterQueryRequest("Select UsrDepartment,UsrLevel,UsrUserName from SecurityUser order by UsrUserName", oCommon.DBCon).Data;
oCResult.DataTableContainerSub = m_oCSQLCommandExecutor.LoadTable(oDataSet);
}
}
catch (Exception ex)
{
oCResult.IsSuccess = false;
oCResult.Message = ex.ToString();
}
}
else
{
oCResult.IsSuccess = false;
oCResult.Message = "Id not found.";
}
}
return(oCResult);
}
public CResult LoadData(SecurityUser_Entity oSecurityUser_Entity, string strCR)
{
oDataSet = (DataSet)m_oCSQLCommandExecutor.DataAdapterQueryRequest("Select UsrUserName,UsrDepartment,UsrLevel from SecurityUser Where UsrUserName Like'%" + strCR + "%' order by UsrUserName", oCommon.DBCon).Data;
oCResult.DataTableContainerSub = m_oCSQLCommandExecutor.LoadTable(oDataSet);
return(oCResult);
}
