public List<Data_Associate> SearchAssociate(int AssociateID, int? DesignationID, string FirstName, string LastName, int? ProjectID, int? LocationID, ref int? count)
{
int DesID = (DesignationID == null) ? 0 : Convert.ToInt32(DesignationID);
int ProID = (ProjectID == null) ? 0 : Convert.ToInt32(ProjectID);
int LocID = (LocationID == null) ? 0 : Convert.ToInt32(LocationID);
List<Data_Associate> Associates = new List<Data_Associate>();
SqlConnection sqlConn = new SqlConnection(base.Connection.ConnectionString);
using (sqlConn)
{
try
{
SqlCommand cmd = sqlConn.CreateCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "dbo.Search_Associate";
cmd.Parameters.AddWithValue("@AssociateID", AssociateID);
cmd.Parameters.AddWithValue("@DesignationID", DesID);
cmd.Parameters.AddWithValue("@FirstName", FirstName);
cmd.Parameters.AddWithValue("@LastName", LastName);
cmd.Parameters.AddWithValue("@ProjectID", ProID);
cmd.Parameters.AddWithValue("@LocationID", LocID);
if (sqlConn.State != ConnectionState.Open)
sqlConn.Open();
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Data_Associate associate = new Data_Associate()
{
AssociateID = (rdr["AssociateID"].ToString() == string.Empty) ? 0 : Convert.ToInt32(rdr["AssociateID"].ToString()),
FirstName = rdr["FirstName"].ToString(),
LastName = rdr["LastName"].ToString(),
Mobile = rdr["Mobile"].ToString(),
email = rdr["email"].ToString(),
DirectReportID = (rdr["DirectReportID"].ToString() == string.Empty) ? 0 : Convert.ToInt32(rdr["DirectReportID"].ToString()),
IsActive = (rdr["IsActive"].ToString() == string.Empty) ? false : Convert.ToBoolean(rdr["IsActive"].ToString()),
IsApproved = (rdr["IsApproved"].ToString() == string.Empty) ? false : Convert.ToBoolean(rdr["IsApproved"].ToString()),
ModifiedBy = (rdr["ModifiedBy"].ToString() == string.Empty) ? 0 : Convert.ToInt32(rdr["ModifiedBy"].ToString()),
//ModifiedOn = Convert.ToDateTime(rdr["ModifiedOn"]),
ProjectName = rdr["ProjectName"].ToString(),
Location = rdr["Location"].ToString(),
Designation = rdr["Designation"].ToString(),
DOJ = rdr["DOJ"].ToString(),
DOB = rdr["DOB"].ToString(),
UserId = rdr["UserId"].ToString(),
};
Associates.Add(associate);
}
rdr.Close();
}
catch (Exception ex)
{
throw ex;
}
}
return Associates;
}
public List <Data_Associate> SearchAssociate(int AssociateID, int?DesignationID, string FirstName, string LastName, int?ProjectID, int?LocationID, ref int?count)
{
int DesID = (DesignationID == null) ? 0 : Convert.ToInt32(DesignationID);
int ProID = (ProjectID == null) ? 0 : Convert.ToInt32(ProjectID);
int LocID = (LocationID == null) ? 0 : Convert.ToInt32(LocationID);
List <Data_Associate> Associates = new List <Data_Associate>();
SqlConnection sqlConn = new SqlConnection(base.Connection.ConnectionString);
using (sqlConn)
{
try
{
SqlCommand cmd = sqlConn.CreateCommand();
cmd.CommandType = System.Data.CommandType.StoredProcedure;
cmd.CommandText = "dbo.Search_Associate";
cmd.Parameters.AddWithValue("@AssociateID", AssociateID);
cmd.Parameters.AddWithValue("@DesignationID", DesID);
cmd.Parameters.AddWithValue("@FirstName", FirstName);
cmd.Parameters.AddWithValue("@LastName", LastName);
cmd.Parameters.AddWithValue("@ProjectID", ProID);
cmd.Parameters.AddWithValue("@LocationID", LocID);
if (sqlConn.State != ConnectionState.Open)
{
sqlConn.Open();
}
SqlDataReader rdr = cmd.ExecuteReader();
while (rdr.Read())
{
Data_Associate associate = new Data_Associate()
{
AssociateID = (rdr["AssociateID"].ToString() == string.Empty) ? 0 : Convert.ToInt32(rdr["AssociateID"].ToString()),
FirstName = rdr["FirstName"].ToString(),
LastName = rdr["LastName"].ToString(),
Mobile = rdr["Mobile"].ToString(),
email = rdr["email"].ToString(),
DirectReportID = (rdr["DirectReportID"].ToString() == string.Empty) ? 0 : Convert.ToInt32(rdr["DirectReportID"].ToString()),
IsActive = (rdr["IsActive"].ToString() == string.Empty) ? false : Convert.ToBoolean(rdr["IsActive"].ToString()),
IsApproved = (rdr["IsApproved"].ToString() == string.Empty) ? false : Convert.ToBoolean(rdr["IsApproved"].ToString()),
ModifiedBy = (rdr["ModifiedBy"].ToString() == string.Empty) ? 0 : Convert.ToInt32(rdr["ModifiedBy"].ToString()),
//ModifiedOn = Convert.ToDateTime(rdr["ModifiedOn"]),
ProjectName = rdr["ProjectName"].ToString(),
Location = rdr["Location"].ToString(),
Designation = rdr["Designation"].ToString(),
DOJ = rdr["DOJ"].ToString(),
DOB = rdr["DOB"].ToString(),
UserId = rdr["UserId"].ToString(),
};
Associates.Add(associate);
}
rdr.Close();
}
catch (Exception ex)
{
throw ex;
}
}
return(Associates);
}
