// PUT: api/LightDetails/5
public void Put(string id, [FromBody] LightDetails value)
{
try
{
LightDetailsDAL.Update(id, value);
}
catch (Exception ex)
{
string message = ex.Message;
}
}
// POST: api/LightDetails
public void Post([FromBody] LightDetails value)
{
try
{
LightDetailsDAL.Insert(value);
}
catch (Exception ex)
{
string message = ex.Message;
}
}
public static List <LightDetails> GetAll()
{
List <LightDetails> lightdetailslist = new List <LightDetails>();
try
{
using (SqlConnection con = new SqlConnection(conString))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string query = "SELECT * FROM LightDetails";
SqlCommand cmd = new SqlCommand(query, con);
SqlDataReader reader = cmd.ExecuteReader();
if (reader != null)
{
if (reader.HasRows)
{
while (reader.Read())
{
LightDetails lightdetails = new LightDetails()
{
LightId = reader["LightId"].ToString(),
//LightType = reader["LightType"].ToString(),
LightName = reader["LightName"].ToString(),
//LightFileName = reader["LightFileName"].ToString(),
//LightFilePath = reader["LightFilePath"].ToString(),
LightCost = int.Parse(reader["LightCost"].ToString()),
// LightCreatedBy = reader["LightCreatedBy"].ToString(),
};
lightdetailslist.Add(lightdetails);
}
reader.Close();
}
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
catch (Exception ex)
{
throw ex;
}
return(lightdetailslist);
}
public static List <LightDetails> Get(int CustomerId)
{
List <LightDetails> lightlist = new List <LightDetails>();
try
{
using (SqlConnection con = new SqlConnection(conString))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string query = "select LightName, LightCost from LightDetails, BookingLight " +
"where (LightDetails.LightId = BookingLight.LightNameID or LightDetails.LightId = BookingLight.LightType) " +
"and CustomerId = @CustomerId ";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.Add(new SqlParameter("@CustomerId", CustomerId));
SqlDataReader reader = cmd.ExecuteReader();
if (reader != null)
{
if (reader.HasRows)
{
while (reader.Read())
{
LightDetails light = new LightDetails()
{
LightName = reader["LightName"].ToString(),
LightCost = int.Parse(reader["LightCost"].ToString()),
};
lightlist.Add(light);
}
reader.Close();
}
}
if (con.State == ConnectionState.Open)
{
con.Close();
}
}
}
catch (Exception ex)
{ throw ex; }
return(lightlist);
}
public static bool Update(string LightId, LightDetails lightdetails)
{
bool status = false;
try
{
using (SqlConnection con = new SqlConnection(conString))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string query = "UPDATE LightDetails SET LightName=@LightName," +
" LightCost=@LightCost " +
"WHERE LightId=@LightId";
SqlCommand cmd = new SqlCommand(query, con);
cmd.Parameters.Add(new SqlParameter("@LightId", lightdetails.LightId));
// cmd.Parameters.Add(new SqlParameter("@LightType", lightdetails.LightType));
cmd.Parameters.Add(new SqlParameter("@LightName", lightdetails.LightName));
//cmd.Parameters.Add(new SqlParameter("@LightFileName", lightdetails.LightFileName));
//cmd.Parameters.Add(new SqlParameter("@LightFilePath", lightdetails.LightFilePath));
cmd.Parameters.Add(new SqlParameter("@LightCost", lightdetails.LightCost));
// cmd.Parameters.Add(new SqlParameter("@LightCreatedBy", lightdetails.LightCreatedBy));
cmd.ExecuteNonQuery();
if (con.State == ConnectionState.Open)
{
con.Close();
}
status = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(status);
}
public static bool Insert(LightDetails lightdetails)
{
bool status = false;
try
{
using (SqlConnection con = new SqlConnection(conString))
{
if (con.State == ConnectionState.Closed)
{
con.Open();
}
string qyery = "Insert into LightDetails(LightId,LightName,LightCost) " +
"Values(@LightId,@LightName,@LightCost)";
SqlCommand cmd = new SqlCommand(qyery, con);
cmd.Parameters.Add(new SqlParameter("@LightId", lightdetails.LightId));
//cmd.Parameters.Add(new SqlParameter("@LightType", lightdetails.LightType));
cmd.Parameters.Add(new SqlParameter("@LightName", lightdetails.LightName));
//cmd.Parameters.Add(new SqlParameter("@LightFileName", lightdetails.LightFileName));
//cmd.Parameters.Add(new SqlParameter("@LightFilePath", lightdetails.LightFilePath));
cmd.Parameters.Add(new SqlParameter("@LightCost", lightdetails.LightCost));
//cmd.Parameters.Add(new SqlParameter("@LightCreatedBy", lightdetails.LightCreatedBy));
cmd.ExecuteNonQuery();
if (con.State == ConnectionState.Open)
{
con.Close();
}
status = true;
}
}
catch (Exception ex)
{
throw ex;
}
return(status);
}
