public List <ClientCodeDetails> GetType(string selectedClient)
{
List <ClientCodeDetails> SelectedClientCodes = new List <ClientCodeDetails>();
con.Open();
try
{
string str = " select DISTINCT m.[Type] from CLIENT c, MODIFICATION m where c.INTERNAL_CLIENT_NUM = m.INTERNAL_CLIENT_NUM and c.CLIENT_CODE = '{0}'";
string sql = string.Format(str, selectedClient);
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ClientCodeDetails selectedClientCode = new ClientCodeDetails()
{
Type = reader["Type"].ToString(),
};
SelectedClientCodes.Add(selectedClientCode);
}
}
catch (Exception e)
{
throw e;
}
finally { con.Close(); }
return(SelectedClientCodes);
}
public List <ClientCodeDetails> GetProjectCodes(string selectedClient)
{
List <ClientCodeDetails> SelectedClientCodes = new List <ClientCodeDetails>();
con.Open();
try
{
string str = "select DISTINCT Project_code from CLIENT where CLIENT_CODE='{0}'";
string sql = string.Format(str, selectedClient);
SqlCommand cmd = new SqlCommand(sql, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
ClientCodeDetails selectedClientCode = new ClientCodeDetails()
{
Project_Code = reader["Project_code"].ToString(),
};
SelectedClientCodes.Add(selectedClientCode);
}
}
catch (Exception e)
{
throw e;
}
finally { con.Close(); }
return(SelectedClientCodes);
}
public IHttpActionResult PostLoadSavedUserDATA([FromBody] ClientCodeDetails ccd)
{
Check_Points_List cd = new Check_Points_List();
List <CheckPoints> LoadSavedUserDATA = cd.LoadSavedUserDATA(ccd.Client_Code, ccd.Project_Code, ccd.Extension_code);
return(Ok(LoadSavedUserDATA));
}
public List <ClientCodeDetails> GetClientCodes(string user)
{
List <ClientCodeDetails> SelectedClientCodes = new List <ClientCodeDetails>();
ClientCodeDetails selectedClientCode = null;
try
{
con.Open();
string str = "select DISTINCT CLIENT_CODE from CLIENT order by CLIENT_CODE";
// string sql = string.Format(str, RouteID, c.DepartureDate);
SqlCommand cmd = new SqlCommand(str, con);
SqlDataReader reader = cmd.ExecuteReader();
while (reader.Read())
{
selectedClientCode = new ClientCodeDetails()
{
user = user,
status = true,
Client_Code = reader["CLIENT_CODE"].ToString(),
};
SelectedClientCodes.Add(selectedClientCode);
}
}
catch (Exception)
{
selectedClientCode = new ClientCodeDetails()
{
status = false
};
SelectedClientCodes.Add(selectedClientCode);
return(SelectedClientCodes);
}
finally { con.Close(); }
return(SelectedClientCodes);
}
