/////////////////////////////////////////////////////////////////////////// Update ///////////////////////////////////////////////////////
public bool Update(ClassStock z)
{
bool isSuccess = false;
SqlConnection conn2 = new SqlConnection(myid2);
try
{
string sql2 = "UPDATE Stocks SET PatternID=@PatternID, PatternName=@PatternName, AvailableQty=@AvailableQty, AddedQty=@AddedQty, AddedDate=@AddedDate WHERE Sid=@Sid";
SqlCommand cmd2 = new SqlCommand(sql2, conn2);
cmd2.Parameters.AddWithValue("@Sid", z.Sid);
cmd2.Parameters.AddWithValue("@PatternID", z.PatternID);
cmd2.Parameters.AddWithValue("@PatternName", z.PatternName);
cmd2.Parameters.AddWithValue("@AvailableQty", z.AvailableQty);
cmd2.Parameters.AddWithValue("@AddedQty", z.AddedQty);
cmd2.Parameters.AddWithValue("@AddedDate", z.AddedDate);
conn2.Open();
int rows = cmd2.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception)
{
}
finally
{
conn2.Close();
}
return(isSuccess);
}
/////////////////////////////////////////////////////////////////////////// Insert ///////////////////////////////////////////////////////
public bool Insert(ClassStock z)
{
bool isSuccess = false;
SqlConnection conn2 = new SqlConnection(myid2);
try
{
string sql2 = "INSERT INTO Stocks(PatternID, PatternName, AvailableQty, AddedQty, AddedDate) VALUES(@PatternID, @PatternName, @AvailableQty, @AddedQty, @AddedDate)";
SqlCommand cmd2 = new SqlCommand(sql2, conn2);
//cmd2.Parameters.AddWithValue("@Sid", z.Sid);
cmd2.Parameters.AddWithValue("@PatternID", z.PatternID);
cmd2.Parameters.AddWithValue("@PatternName", z.PatternName);
cmd2.Parameters.AddWithValue("@AvailableQty", z.AvailableQty);
cmd2.Parameters.AddWithValue("@AddedQty", z.AddedQty);
cmd2.Parameters.AddWithValue("@AddedDate", z.AddedDate);
conn2.Open();
int rows = cmd2.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception)
{
conn2.Close();
}
return(isSuccess);
}
/////////////////////////////////////////////////////////////////////////// Delete ///////////////////////////////////////////////////////
public bool Delete(ClassStock z)
{
bool isSuccess = false;
SqlConnection conn2 = new SqlConnection(myid2);
try
{
string sql2 = "DELETE FROM Stocks WHERE Sid=@Sid";
SqlCommand cmd2 = new SqlCommand(sql2, conn2);
cmd2.Parameters.AddWithValue("@Sid", z.Sid);
conn2.Open();
int rows = cmd2.ExecuteNonQuery();
if (rows > 0)
{
isSuccess = true;
}
else
{
isSuccess = false;
}
}
catch (Exception)
{
}
finally
{
conn2.Close();
}
return(isSuccess);
}