public List <AdprojectDetails> FetchProjectDetails()
{
// AdprojectDetails ProjName = new AdprojectDetails();
List <AdprojectDetails> listofproject = new List <AdprojectDetails>();
string con = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
using (SqlConnection conn = new SqlConnection(con))
{
conn.Open();
SqlCommand cmd = new SqlCommand("select ProjectName from LTProject", conn);
// flag = Convert.ToBoolean(cmd.ExecuteScalar());
SqlDataReader dr = cmd.ExecuteReader();
if (dr.FieldCount != 0)
{
while (dr.Read())
{
AdprojectDetails ProjName1 = new AdprojectDetails();
ProjName1.ProjectName = dr["ProjectName"].ToString();
listofproject.Add(ProjName1);
}
}
return(listofproject);
}
}
public int InsertProjectToDB(AdprojectDetails AdprojectDetails)
{
int row = 0;
string con = ConfigurationManager.ConnectionStrings["ConnectionString"].ConnectionString;
using (SqlConnection conn = new SqlConnection(con))
{
conn.Open();
SqlCommand cmd = new SqlCommand("insert into LTProject values('" + AdprojectDetails.ProjectName + "')", conn);
// flag = Convert.ToBoolean(cmd.ExecuteScalar());
row = cmd.ExecuteNonQuery();
if (row > 0)
{
return(1);
}
else
{
return(0);
}
}
}