public List <subService> GetSubServices()
{
SqlConnection scon = new SqlConnection(conn);
List <subService> objSubServiceList = new List <subService>();
using (SqlCommand scmd = new SqlCommand())
{
scmd.Connection = scon;
scmd.CommandType = CommandType.Text;
scmd.CommandText = "SELECT * FROM SubService_category";
scon.Open();
SqlDataReader sdr = scmd.ExecuteReader();
while (sdr.Read())
{
subService objsubServiceMaster = new subService();
objsubServiceMaster.subServiceId = Convert.ToInt32(sdr["subServiceId"]);
objsubServiceMaster.SubServiceName = sdr["SubServiceName"].ToString();
objsubServiceMaster.Cost = float.Parse(sdr["Cost"].ToString());
objsubServiceMaster.duration = float.Parse(sdr["duration"].ToString());
objsubServiceMaster.ServiceID = Convert.ToInt32(sdr["ServiceID"]);
objSubServiceList.Add(objsubServiceMaster);
}
if (sdr != null)
{
sdr.Dispose();
sdr.Close();
}
scon.Close();
return(objSubServiceList.ToList());;
}
}
public subService GetSubServiceById(int id)
{
SqlConnection scon = new SqlConnection(conn);
subService objsubServiceMaster = new subService();
using (SqlCommand scmd = new SqlCommand())
{
scmd.Connection = scon;
scmd.CommandType = CommandType.Text;
scmd.CommandText = "SELECT * FROM SubService_category where subServiceId=" + id + "";
scon.Open();
SqlDataReader sdr = scmd.ExecuteReader();
if (sdr.Read())
{
objsubServiceMaster.subServiceId = Convert.ToInt32(sdr["subServiceId"]);
objsubServiceMaster.SubServiceName = sdr["SubServiceName"].ToString();
objsubServiceMaster.Cost = float.Parse(sdr["Cost"].ToString());
objsubServiceMaster.duration = float.Parse(sdr["duration"].ToString());
objsubServiceMaster.ServiceID = Convert.ToInt32(sdr["ServiceID"]);
}
if (sdr != null)
{
sdr.Dispose();
sdr.Close();
}
scon.Close();
return(objsubServiceMaster);
}
}
public void Addtocart(int id, int cid)
{
subService s = GetSubServiceById(id);
if (getServiceCart(id))
{
}
else
{
SqlConnection con = new SqlConnection(conn);
string qry = "insert into ServiceCart(SubServiceId,Name,cost,duration,customerId)values(" + s.subServiceId + ",'" + s.SubServiceName + "'," + s.Cost + "," + s.duration + "," + cid + ")";
try
{
SqlCommand cmd = new SqlCommand(qry, con);
con.Open();
cmd.ExecuteNonQuery();
con.Close();
}
catch (Exception e)
{
}
}
}
