public List <Client> GetClientDetailsAsync(int Id)
{
try
{
SqlDataReader reader = null;
if (myconn.State != ConnectionState.Open)
{
myconn.Open();
}
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "SP_ClientGet";
sqlCmd.Parameters.Add(new SqlParameter("@Id", Id));
sqlCmd.Connection = myconn;
reader = sqlCmd.ExecuteReader();
List <Client> lst = new List <Client>();
if (!reader.HasRows)
{
lst.Add(new Client());
lst[0].statusType = stypeService.GetStatusTypeDetailsAsync(0);
}
else
{
while (reader.Read())
{
lst.Add(new Client()
{
Id = Convert.ToInt32(reader.GetValue(0)),
clientName = reader.GetValue(1).ToString(),
companyId = Convert.ToInt32(reader.GetValue(2)),
companyName = reader.GetValue(3).ToString(),
email = reader.GetValue(4).ToString(),
address = reader.GetValue(5).ToString(),
phoneNumber = reader.GetValue(6).ToString(),
createdDate = Convert.ToDateTime(reader.GetValue(7)),
modifiedDate = reader.GetValue(8) == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(reader.GetValue(8)),
statusId = Convert.ToInt32(reader.GetValue(9)),
statusName = reader.GetValue(10).ToString(),
userId = Convert.ToInt32(reader.GetValue(11)),
});
}
lst[0].statusType = stypeService.GetStatusTypeDetailsAsync(0);
}
if (myconn.State != ConnectionState.Closed)
{
myconn.Close();
}
return(lst);
}
catch (Exception ex)
{
gs.LogData(ex);
throw ex;
}
}
public List <Account> GetUserDetailsAsync(int Id, int roleId)
{
try
{
DataTable dtUsers = new DataTable();
SqlDataAdapter daUsers;
if (myconn.State != ConnectionState.Open)
{
myconn.Open();
}
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "SP_UserGet";
sqlCmd.Parameters.Add(new SqlParameter("@Id", Id));
sqlCmd.Connection = myconn;
daUsers = new SqlDataAdapter(sqlCmd);
dtUsers.Clear();
daUsers.Fill(dtUsers);
List <Account> lst = new List <Account>();
if (dtUsers.Rows.Count == 0)
{
lst.Add(new Account());
lst[0].statusTypeList = stypeService.GetStatusTypeDetailsAsync(0);
lst[0].membersList = mService.GetMembersDetailsAsync(0, 'U');
lst[0].scList = scService.GetSubContractorDetailsAsync(0, 'U');
lst[0].rolesList = GetRoles(0);
lst[0].menuList = mnuService.GetMenuDetails(roleId, 'S');
}
else
{
foreach (DataRow item in dtUsers.Rows)
{
lst.Add(new Account()
{
Id = Convert.ToInt32(item[0]),
userName = gs.CipherText(item[1].ToString(), "D"),
password = gs.CipherText(item[2].ToString(), "D"),
memberId = Convert.ToInt32(item[3]),
memberName = item[4].ToString(),
subcontractorId = Convert.ToInt32(item[5]),
subcontractorName = item[6].ToString(),
roleId = Convert.ToInt32(item[7]),
roles = item[8].ToString(),
statusId = Convert.ToInt32(item[9]),
statusName = item[10].ToString(),
userType = item[11].ToString(),
createdDate = Convert.ToDateTime(item[12]),
modifiedDate = item[13] == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(item[13]),
userId = Convert.ToInt32(item[14])
});
}
lst[0].statusTypeList = stypeService.GetStatusTypeDetailsAsync(0);
lst[0].membersList = mService.GetMembersDetailsAsync(0, 'U');
lst[0].scList = scService.GetSubContractorDetailsAsync(0, 'U');
lst[0].rolesList = GetRoles(0);
lst[0].menuList = mnuService.GetMenuDetails(roleId, 'S');
}
if (myconn.State != ConnectionState.Closed)
{
myconn.Close();
}
return(lst);
}
catch (Exception ex)
{
gs.LogData(ex);
throw ex;
}
}
public List <Project> GetProjectDetailsAsync(int ID, int clientID)
{
try
{
DataTable dtProject = new DataTable();
if (myconn.State != ConnectionState.Open)
{
myconn.Open();
}
SqlCommand sqlCmd = new SqlCommand();
sqlCmd.CommandType = CommandType.StoredProcedure;
sqlCmd.CommandText = "SP_ProjectGet";
sqlCmd.Parameters.Add(new SqlParameter("@ID", ID));
sqlCmd.Parameters.Add(new SqlParameter("@clientID", clientID));
sqlCmd.Connection = myconn;
SqlDataAdapter daProject = new SqlDataAdapter(sqlCmd);
dtProject.Clear();
daProject.Fill(dtProject);
List <Project> lst = new List <Project>();
if (dtProject.Rows.Count == 0)
{
lst.Add(new Project());
lst[0].members = pm.GetProjectMembersDetailsAsync(0, 0);
lst[0].subContractors = ps.GetProjectSubContractorsDetailsAsync(0, 0);
lst[0].location = location.GetLocationDetailsAsync(0);
lst[0].client = client.GetClientDetailsAsync(0);
lst[0].sortype = sortype.GetSORTypeDetailsAsync(0);
lst[0].subsortype = subsortype.GetSubSORTypeDetailsAsync(0);
lst[0].team = team.GetTeamDetailsAsync(0, 'I');
lst[0].subcontractor = subcontractor.GetSubContractorDetailsAsync(0, 'I');
lst[0].statusType = statusType.GetStatusTypeDetailsAsync(0);
}
else
{
foreach (DataRow item in dtProject.Rows)
{
lst.Add(new Project()
{
Id = Convert.ToInt32(item[0]),
projName = item[1].ToString(),
locId = Convert.ToInt32(item[2]),
locName = item[3].ToString(),
clientId = Convert.ToInt32(item[4]),
clientName = item[5].ToString(),
startDate = Convert.ToDateTime(item[6]),
endDate = Convert.ToDateTime(item[7]),
statusId = Convert.ToInt32(item[8]),
statusName = item[9].ToString(),
createdDate = Convert.ToDateTime(item[10]),
modifiedDate = item[11] == DBNull.Value ? (DateTime?)null : Convert.ToDateTime(item[11]),
userId = Convert.ToInt32(item[12]),
projRates = pr.GetProjectRatesDetailsAsync(0, Convert.ToInt32(item[0])),
projMembers = pm.GetProjectMembersDetailsAsync(0, Convert.ToInt32(item[0])),
projSubContractors = ps.GetProjectSubContractorsDetailsAsync(0, Convert.ToInt32(item[0])),
projJobTypes = pj.GetProjectJobTypesDetailsAsync(0, Convert.ToInt32(item[0]))
});
}
lst[0].members = pm.GetProjectMembersDetailsAsync(0, 0);
lst[0].subContractors = ps.GetProjectSubContractorsDetailsAsync(0, 0);
lst[0].location = location.GetLocationDetailsAsync(0);
lst[0].client = client.GetClientDetailsAsync(0);
lst[0].sortype = sortype.GetSORTypeDetailsAsync(0);
lst[0].subsortype = subsortype.GetSubSORTypeDetailsAsync(0);
lst[0].team = team.GetTeamDetailsAsync(0, 'I');
lst[0].subcontractor = subcontractor.GetSubContractorDetailsAsync(0, 'I');
lst[0].statusType = statusType.GetStatusTypeDetailsAsync(0);
}
if (myconn.State != ConnectionState.Closed)
{
myconn.Close();
}
return(lst);
}
catch (Exception ex)
{
gs.LogData(ex);
throw ex;
}
}
