public void Save(ClsBllServiceEntry ObjBll, int flag) { if (CON.State == ConnectionState.Closed) { CON.Open(); } SqlCommand ObjCmd = new SqlCommand("SP_SERVICEENTRY"); ObjCmd.CommandType = CommandType.StoredProcedure; ObjCmd.Connection = CON; ObjCmd.Parameters.Clear(); ObjCmd.Parameters.Add("@FLAG", SqlDbType.BigInt).Value = flag; if (flag == 3) { ObjCmd.Parameters.Add("@SERVICEID", SqlDbType.BigInt).Value = ObjBll.ServiceId; } ObjCmd.Parameters.Add("@PRODUCTID", SqlDbType.BigInt).Value = ObjBll.ProductId; ObjCmd.Parameters.Add("@SERVICENAME", SqlDbType.VarChar).Value = ObjBll.ServiceName; ObjCmd.Parameters.Add("@TIMEREQUIREDDAYS", SqlDbType.VarChar).Value = ObjBll.TimeRequiredDays; ObjCmd.Parameters.Add("@TIMEREQUIREDHOURS", SqlDbType.VarChar).Value = ObjBll.TimeRequiredHours; ObjCmd.Parameters.Add("@TIMEREQUIREDMINUTES", SqlDbType.VarChar).Value = ObjBll.TimeRequiredMinutes; ObjCmd.Parameters.Add("@SERVICECOST", SqlDbType.VarChar).Value = ObjBll.ServiceCost; ObjCmd.ExecuteNonQuery(); }
public void Delete(ClsBllServiceEntry ObjBll, int flag) { if (CON.State == ConnectionState.Closed) { CON.Open(); } SqlCommand ObjCmd = new SqlCommand("SP_SERVICEENTRY"); ObjCmd.CommandType = CommandType.StoredProcedure; ObjCmd.Connection = CON; ObjCmd.Parameters.Clear(); ObjCmd.Parameters.Add("@FLAG", SqlDbType.BigInt).Value = flag; ObjCmd.Parameters.Add("@SERVICEID", SqlDbType.BigInt).Value = ObjBll.ServiceId; ObjCmd.ExecuteNonQuery(); }
public DataTable ReturnDataTable(ClsBllServiceEntry ObjBll, int flag) { if (CON.State == ConnectionState.Closed) { CON.Open(); } SqlCommand ObjCmd = new SqlCommand("SP_SERVICEENTRY"); ObjCmd.CommandType = CommandType.StoredProcedure; ObjCmd.Connection = CON; ObjCmd.Parameters.Clear(); ObjCmd.Parameters.Add("@FLAG", SqlDbType.BigInt).Value = flag; //ObjCmd.Parameters.Add("@SERVICEID", SqlDbType.VarChar).Value = ObjBll.ServiceId; SqlDataAdapter sda = new SqlDataAdapter(ObjCmd); DataTable Dt = new DataTable(); sda.Fill(Dt); return(Dt); }