/// <summary>
/// Search data from GENERAL_AUT_USERROLE table
/// </summary>
/// <param name="dt"></param>
/// <param name="URoleID"></param>
/// <returns></returns>
/// <remarks>
/// Author: PhatLT. FPTSS.
/// Created date: 14/02/2011
/// </remarks>
public DataTable Search(DataTable dt, string URoleID)
{
clsCommon common = new clsCommon();
string strSql = "SELECT UROLE_ID, ROLE_NAME FROM GENERAL_AUT_USERROLE ";
StringBuilder sb = new StringBuilder();
if(URoleID != null && URoleID.Length > 0)
{
sb.Append(string.Format(" UROLE_ID LIKE '{0}' ", common.EncodeKeyword(URoleID)));
}
if(sb.Length > 0)
strSql = strSql + " WHERE " + sb.ToString();
return dao.GetDataTable(dt, strSql);
}
/// <summary>
/// Check whether data of user is valid
/// </summary>
/// <returns></returns>
/// <remarks>
/// Author: PhatLT. FPTSS.
/// Created date: 14/02/2011
/// </remarks>
public bool ValidateData()
{
DataRowView rview = (DataRowView)_manager.Current;
DataRow row = rview.Row;
clsCommon common = new clsCommon();
row.ClearErrors();
ep.SetError(txtConfirmPassword, "");
string userName = row["USERNAME"].ToString();
if(userName.Length == 0)
{
row.SetColumnError("USERNAME", clsResources.GetMessage("errors.required", lblUserName.Text));
txtUserName.Focus();
return false;
}
else if(!common.IsLetterAndDigit(userName))
{
row.SetColumnError("USERNAME", clsResources.GetMessage("errors.string.specialChar", lblUserName.Text));
txtUserName.Focus();
return false;
}
if(row["PASSWORD"].ToString().Length == 0)
{
row.SetColumnError("PASSWORD", clsResources.GetMessage("errors.required", lblPassword.Text));
txtPassword.Focus();
return false;
}
if(txtConfirmPassword.Text != txtPassword.Text)
{
ep.SetError(txtConfirmPassword, clsResources.GetMessage("errors.compare.equal", lblConfirmPassword.Text, lblPassword.Text));
return false;
}
if(row["FIRSTNAME"].ToString().Length == 0)
{
row.SetColumnError("FIRSTNAME", clsResources.GetMessage("errors.required", lblFirstName.Text));
txtFirstName.Focus();
return false;
}
if(row["LASTNAME"].ToString().Length == 0)
{
row.SetColumnError("LASTNAME", clsResources.GetMessage("errors.required", lblLastName.Text));
txtFirstName.Focus();
return false;
}
if(row["EMAIL"] == DBNull.Value)
{
row.SetColumnError("EMAIL", clsResources.GetMessage("errors.required", lblEmail.Text));
txtEmail.Focus();
return false;
}
else if(row["EMAIL"].ToString().Length > 0 && !common.IsEmail(row["EMAIL"].ToString()))
{
row.SetColumnError("EMAIL", clsResources.GetMessage("errors.email", lblAddress.Text));
txtAddress.Focus();
return false;
}
if(row["ADDRESS"] == DBNull.Value)
{
row.SetColumnError("ADDRESS", clsResources.GetMessage("errors.required", lblAddress.Text));
txtAddress.Focus();
return false;
}
if(row["PHONE"] == DBNull.Value)
{
row.SetColumnError("PHONE", clsResources.GetMessage("errors.required", lblPhone.Text));
txtPhone.Focus();
return false;
}
if(txtStartDate.Value > txtEndDate.Value)
{
row.SetColumnError("END_DATE", clsResources.GetMessage("errors.compare.datetime", lblStartDate.Text, lblEndDate.Text));
txtStartDate.Focus();
return false;
}
if(row["UROLE_ID"] == DBNull.Value)
{
row.SetColumnError("UROLE_ID", clsResources.GetMessage("errors.required", lblURoleID.Text));
cboURoleID.Focus();
return false;
}
if(row["STATUS"] == DBNull.Value)
{
row.SetColumnError("STATUS", clsResources.GetMessage("errors.required", lblStatus.Text));
cboURoleID.Focus();
return false;
}
if(row["DESCRIPTION"] == DBNull.Value)
{
row.SetColumnError("DESCRIPTION", clsResources.GetMessage("errors.required", lblDescription.Text));
txtDescription.Focus();
return false;
}
if(!bln_IsEdit && bo.Exist(row["USERNAME"].ToString()))
{
row.SetColumnError("USERNAME", clsResources.GetMessage("errors.userName.exist"));
txtUserName.Focus();
return false;
}
return true;
}
/// <summary>
/// Search data from
/// </summary>
/// <param name="dt"></param>
/// <param name="userName"></param>
/// <param name="firstName"></param>
/// <param name="lastName"></param>
/// <param name="email"></param>
/// <param name="roleID"></param>
/// <param name="status"></param>
/// <returns></returns>
/// <remarks>
/// Author: PhatLT. FPTSS.
/// Created date: 14/02/2011
/// </remarks>
public DataTable Search(DataTable dt, string userName, string firstName, string lastName, string email, string roleID, string status)
{
clsCommon common = new clsCommon();
string strSql = "SELECT USERNAME, PASSWORD, FIRSTNAME, LASTNAME, EMAIL, ADDRESS, PHONE, START_DATE, END_DATE, PWD_CHG_DATE, STATUS, UROLE_ID, DESCRIPTION FROM GENERAL_AUT_USER";
StringBuilder sb = new StringBuilder();
if(userName != null && userName.Length > 0)
{
sb.Append(string.Format(" AND USERNAME LIKE '{0}' ", common.EncodeKeyword(userName)));
}
if(roleID != null && roleID.Length > 0)
{
sb.Append(string.Format(" AND UROLE_ID = '{0}' ", common.EncodeString(roleID)));
}
if(status != null && status.Length > 0)
{
sb.Append(string.Format(" AND STATUS = '{0}' ", common.EncodeString(status)));
}
if(firstName != null && firstName.Length > 0)
{
sb.Append(string.Format(" AND FIRSTNAME LIKE '{0}' ", common.EncodeKeyword(firstName)));
}
if(lastName != null && lastName.Length > 0)
{
sb.Append(string.Format(" AND LASTNAME LIKE '{0}' ", common.EncodeKeyword(lastName)));
}
if(email != null && email.Length > 0)
{
sb.Append(string.Format(" AND EMAIL LIKE '{0}' ", common.EncodeKeyword(email)));
}
if(sb.Length > 0)
strSql = strSql + " WHERE " + sb.ToString(4, sb.Length - 4);
return dao.GetDataTable(dt, strSql);
}
/// <summary>
/// tra ve gia tri tuan: tu tuan hien tai cho den tuan 52
/// </summary>
/// <remarks>
/// Author: Nguyen Minh Khoa G3
/// Modified: 18-Apr-2011
/// </remarks>
/// <returns>intWeeks</returns>
public int[] InitWeek()
{
clsCommon common = new clsCommon();
int intCurrentWeek = common.GetInt(GetWeekSingle());
if(intCurrentWeek < 52)
intCurrentWeek += 1;
int intArraySize = 53-intCurrentWeek;
int[] intWeeks = new int[intArraySize];
int i=0;
while(intCurrentWeek<=52)
{
intWeeks[i] = intCurrentWeek;
i++;
intCurrentWeek++;
}
return intWeeks;
}
/// <summary>
/// Get all customers
/// </summary>
/// <returns></returns>
/// <remarks>
/// Author: PhatLT. FPTSS.
/// Created date: 14/02/2011
/// </remarks>
public DataTable GetCustomers()
{
clsCommon common = new clsCommon();
string strSql = string.Format("SELECT DISTINCT CUST_CODE, CUST_NAME FROM GENERAL_DISTRIBUTOR_HIERARCHY ORDER BY CUST_CODE");
DataTable dt = dao.GetDataTable(strSql);
DataRow row = dt.NewRow();
row[0] = string.Empty;
row[1] = string.Empty;
dt.Rows.InsertAt(row, 0);
return dt;
}
/// <summary>
/// Export data table to Excel
/// </summary>
/// <remarks>
/// Author: PhatLT. FPTSS.
/// Created date: 14/02/2011
/// </remarks>
public void ExportToExcel(DataView view, DataGridTableStyle grdStyle, int startRow, int startCol, Excel.Worksheet sheet)
{
clsCommon common = new clsCommon();
string[] headers = null;
int[] indexes = null;
common.GetExportInfo(view, grdStyle.GridColumnStyles, ref headers, ref indexes);
ExportToExcel(view, headers, indexes, startRow, startCol, sheet);
}
/// <summary>
/// Export data table to Excel like DataGridTableStyle
/// </summary>
/// <param name="view"></param>
/// <param name="grdStyle"></param>
/// <param name="startRow"></param>
/// <param name="startCol"></param>
/// <remarks>
/// Author: PhatLT. FPTSS.
/// Created date: 14/02/2011
/// </remarks>
public void ExportToExcel(DataView view, DataGridTableStyle grdStyle, int startRow, int startCol)
{
if(view == null || grdStyle == null)
return;
clsCommon common = new clsCommon();
string[] headers = null;
int[] indexes = null;
common.GetExportInfo(view, grdStyle.GridColumnStyles, ref headers, ref indexes);
ExportToExcel(view, headers, indexes, startRow, startCol);
}
